User Data Vs. Database
I have been thinking about storing some data, which my users upload, in text files rather than database, since often I do not know how much information users submit for things like item description or images URL paths.
This information may be very short or very long. MS SQL Server requires a maximum field length to be set. Thus, if user enters 5 characters into 5000 character field, a lot of space will be wasted. On the other hand, the database reference would point to the text
files to read users' data and display it on page.
View Replies
ADVERTISEMENT
How can I protect from SQL-injection in this instance?Code:
sql = "
SELECT dbo.admin.id, dbo.admin.email
FROM dbo.admin
WHERE dbo.admin.username = '"&Request.Form("user")&"'"
View Replies
View Related
how do i get data from a user on one page and display the result on the other page
actually i have written a prgoram that displays a set of checkboxes and based on the checkboxes selected the related data is displayed .but the problem is the data is displayed on the same page below the list of check boxes. Code:
View Replies
View Related
I am inserting data into Access when user logs on:
..............
SQL = "INSERT INTO tblLog (fldUserName,fldTimeIn,fldSID) VALUES ('" & u & "',#" & session("Date") & "#,'" & session.SessionID & "')"
con.Execute(SQL)
.....................
in here it inserts the date :01/09/2003
But when logging out :
.............
SQL="UPDATE tblLog SET fldOffline=1,fldProper=1 WHERE fldUserName= '" & session("admin") & "' AND fldTimeIn=#" & session("date") & "# AND fldOffline=0"
con.execute(SQL)
...............
it doesn't update the record.If I eliminate the date query here,it updates there is no syntax error is there?
View Replies
View Related
I am storing user entered form data from an ASP page in a MSSQL 2000 database. I would like to give my administrators a way to download a tab file with the entries. Is writing an ASP page the best way to do this? And if so, how can I convert database records into a file that will download through the browser?
View Replies
View Related
i have a table which has many field, they go across and are named as a1a2a3a4a5a6-a16 the next row will be b1b2b3b4b5b6-b16 the last row is g1g2g3g4g5g6-g16 and so on.
now in the first column i.e which would be a1 b1 c1 d1 e1 f1 g1, the user enters a part number what i want to do is prevent him or her entering the same part no.
twice if this the case the two filds with same part no should be cleared.i.e if user enter p45 in a1 then p45 in d1 then both a1 and d1 should be cleared would be better if the later was only cleared but any method would do. Code:
View Replies
View Related
I am developing an ASP application where the user may spend large amounts of time manipulating data on a worksheet. An amount of time that will certainly exceed the security mandated session timeout intervel of 15 minutes.
So the user pushes save after the session has timed out and is thrown to the user login window -- all according to standards. How can I either detect the timeout before the submit or preserve the user entered data despite the redirect?
View Replies
View Related
I need to allow user to save dataset to their computer in Microsoft Money
format. I searched internet for help on this but found nothing helpful. I
also chatted with MS Online Concierge to no avail.
If you could, please provide pointers to steps how to accomplish this. If
you will provide the steps yourself, please be very explicit in what you
provide.
View Replies
View Related
I'm looking for a code already written if it is possible (as i need to do this soon)I have a database(access) and the users submit data from a asp page and it stores the values. Then it also allows the users to login to the web page using the data (username and password) inserted by the user.
What i want is that when the user logins, to be able to modify the inserted data..Perhaps the user wants to change the e-mail address. I tried doing some search in google but the results were no good.
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
I keep getting an error that says:
Error Type:
Microsoft JET Database Engine (0x80004005)
The Microsoft Jet database engine cannot open the file 'c:inetpubwwwrootannoneil\_databaseannoneil_AN D.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
/annoneil/artist.asp, line 96
The code was working fine a few days ago but now I cannot figure this out.
View Replies
View Related
Is there any way to use asp to determine a users SQL Server database access rights.
I.e I have given a users data read only/ data write only in SQL server, how can I pick that up in an application so that only write only users can see a hyper link.
I know I could create a few more pages with a table in a database with various rights but I just want to read rights directly allocated from SQL Server.
View Replies
View Related
I am writing a small ASP booking engine which allows users to book a ticket provided the num_tickets field in my db table is > 0. Each booking causes the num_tickets field to be decremented. So if a user tries to book when there are no tickets left he gets an appropriate error message. However, if a user books the last remaining ticket and the num_tickets field is set to 0, he can simply hit the "back" button and book again (which decrements num_tickets to -1 and so on). Is there a way I can make the page refresh or expire to stop this from happening? is it a sessions problem?
View Replies
View Related
i'm going to ask the way to use database to check user permission level in asp..
View Replies
View Related
I am currently writing a little gadget where users can create, delete, alter... tables in a database. Some kind of MyAspAdmin... Everything works fine as long as I specify the MSSQL-Login-Infos database, user and password.
But if I want to make it possible to switch from one database to another, here comes the problem: The user has to choose a database that he wants to work in, and type in user and password.
I need the (probably very easy) solution, how i can check if this user/password/chosen_database combination is correct. Code:
View Replies
View Related
I have a page where students can choose activities in a day... this then directs them to their timetable for that day.
However, if they go back to the choose.asp page and they have already registered, I redirect them to timetable.asp - because I don't want them to change their options.
I have their username stored as a session variable and it works fine for most students - however for the example student O'SMITH-JONESMark the page falls over.
I am using Dreamweaver's 'redirect if username exists' server behaviour. Code below... Can anyone tell me how to fix this so the code is not tripping up over the odd characters? Code:
View Replies
View Related
I need code to capture a users ip address once they agree to a disclaimer (a form yes/no). If the user states no a message telling them they do not have access and a redirect back to the home page.
I need to put the ip address along with the date a sql server database. I am lost as to how to code this and also how to set it up in my directories.
View Replies
View Related
I am having trouble trying to detect if no records are retrieved by the search. There doesn't seem to be a problem with the connection to the database or the SQL query. I think the problem is somewhere in my If statement. Code:
View Replies
View Related
I have a master table called ad_dump. ad_dump is an Active Directory dump of 20,000 users across the domain. I capture user's logon to filter ad_dump on department so only user's department personnel show.
This ad_dump will supply data for many databases. Therefore, each application requires a user to "choose" which personnel belongs into a local application(personnel). Personnel choice is the ad_dump of personnel of logged on user's department. The user selects choices by checkbox and submits.
How can I collect the form's hidden values and have them inserted into another database? I assume I can use the form collection object but I cannot seem to figure it out. Code:
View Replies
View Related
How to get the last row of data from database which is integer value by using ASP?
View Replies
View Related
I am using a ASP page(User_Account.asp) to create username and password & updating the info into the database through another ASP page(User_Account_Upload.asp).
The problem I am facing is that, at random instances the data gets duplicated. I tried to check if the user Id exixts in the database before updating. After implementing this logic, whenever I create a new user, if the ASP page tries to store the username for the 2nd time, it generates an error message that the user_id exists and doesn't update the database. However, this error message is displayed on the screen even though the user_id was created for the 1st time ....
View Replies
View Related
I want to display a system maintenance notification on my webpage using a splash screen. I got the code for splash screen from Dynamic Drive and added it on my web page. Now here is my problem. I have created a table in my SQL database with these two fields, Flag and Description. I am trying to connect this splash screen to this table.
This is because-if the flag is set to 1 the splash screen will pop up and display the data in the description field on the splash screen and if it is set 0 the screen will not pop-up at all. Two things I am having trouble with-
1. Displaying the data on the splash screen. I made the connection to my db but can't get it to display it on my splash screen.
2. How to make the splash screen pop-up only if the Flag field is set to 1.
View Replies
View Related
Here's my scenario: I send an email to my customers which contains an embedded URL with a recordnumber within it. What I want to do is create a variable for the recordnumber, write a select statement against my database using the variable as the argument for the WHERE clause, and display the results of the SELECT (its always a single value) within an HTML page.
Here are snippets of the code. The recordnumber is represented by strCallID and the resultset that I'm trying to display is strATG (shown near the bottom of the HTML)
All the connection string stuff has already been taken care of, so that's not included in this code:
View Replies
View Related
I'm using Dreamweaver MX with ASP VBScript and using a MS Access Database. For about the longest time now, I've been trying to make a Mailing List form online and when you submit the data, [data] goes into the Access Database.
The Form is obviously working fine, although sometimes I do get errors, I'm mainly trying to get this data skullduggery working. Is that even possible (with ASP even)? I have to use ASP and I can't use SQL (because I would), but I think my n00b self has tried everything I could think of. Code:
View Replies
View Related
i wanna check one cell value from database and then if cell value is 0 than put this image in the dynamic table, if it's 1 than put other image to dynamic table, and so on Code:
View Replies
View Related
I have a page that allows users to sign on and then have access to the site. What I need to do is to have them sign on and see selected (tables) or data that is in the database.
I need some help. How would this be written. Unfortunalely the only book I have on the subject is asp.net. Code:
View Replies
View Related
I on my site i have a form that users fill in, once they have filled it in, they are then redirected to a preview page. All this is fine.
Then users get redirected to a secure third party that takes all the customers credit card details and checks them all.
If they are all authorised then it will the go back to my page to confirm that everything is ok and that their information has now been added.
What the problem is that i can not carry the information through the secure servers pages and what I need to do is basically get the user to fill out the form have it inserted to the database, then they pay for it, If all ok i want to be able to insert a "confirmed" into the payment field for the advert that they have placed or if it fails for it to say "awaiting payment" in the payment field and a message on the screen to tell them to contact sales team.
View Replies
View Related
I have a site and im trying to make a create account page for users to create an account. Unfortunately after getting everything working right i find out that for some reason the code is not adding the users to the database, i have double and even triple checked my sql connection string im at a complete and total loss Code:
View Replies
View Related
I have 2 textboxes. In first text box i need to enter name, the second text box shud be automatically filled with the person'd id.
Both the name and id is coming from database. I tried using this code, but i'm getting error saying System.NullReferenceException: Object reference not set to an instance of an object. at line 1 Code:
View Replies
View Related
I want my users to be able to update their data(they store hours spend in different courses per week) stored in the Access database. So far they are able to update only one record(i.e. for only one week).....all they do is search for their records using their User_Id and click the WeekNo they want to update.
when there are (e.g. WeekNo1, WeekNo2.....) the user can only update data for WeekNo1 and when they click WeekNo2 the link takes them to WeekNo1 data.Please guys I need help cos I've been trying so hard to figure out what might be the problem and failed.
View Replies
View Related
How to use the for loop to display all the data in database? For example, displaying the data that start with "a".
View Replies
View Related
I have a database which consist of these field:
[Room,Subject,Time,Day]
When the admin enter data to the form, the data will go to another page and will be displayed in a classtimetable form,according to the time, day and room number. i am using Macromedia Ultradev 4 to develiop this page. what i want to do some programming here is.. when the admin enter the data,
1. Room and Time can be same, but in different Room,
2. Room and Time cannot be same(with previous data) in the same Room,
how to code this?
View Replies
View Related
I’m in the middle of designing a simple website poll... nothing to fancy a simply question and results type thing... however I’ve hit a problem in that I cannot figure out how to add one to the running total when a vote is cast. For example:
Do you like this website:
A: Yes Lots – radio button if selected adds one to yeslots column
B: It’s ok - radio button if selected adds one to Itsok column
C: It could be improved - radio button if selected adds one to Itcouldbeimproved column
And of course we’re using an Access database for this one.
View Replies
View Related