how to create a spreadsheet with info from a database. Is there a way to create the spreadsheet on the users computer instead of on the web server? I want to prevent a whole lot of xls files from being created and stored on the server.
Very ill today so unable to concentrate and need some help with some fairly simple stuff... Below is standard code on my page which is recieving variables from Flash and imputting them into a database. What i need this page to do is to and your help doing it is: 1. Check if the email address exists in the dbase? 2. If it exists then to update the field 'High_score' 3. If it doesnt exists then to create a new record and input as the code below does.
I am tryin to create a database of users for my system,each user is given a username based on their own name(surname and first name), however if 2 users with the same or similar name enter their details they will be given the same username,for example john drew would return drewj as thier username, so would jack drew, when a new user is entering their details how do i check that the username generated for them does not already exist,i.e i need to compare the username generated for the new user with all usernames already held in the database,if the username does already exist i want to add a digit to the end of the username how is this done using asp?
I am designing a website were we will give provision for users to upload files. I have heard that u have to use Some "file Upload" Component.where do get this file upload component.? or is there any other way to do file uploading without fielupload component?
We have an ASP application which links to various word and excel documents stored in a folder called attachments. The documents are extermely confidential in nature and we would like restrict the access to them through the application only. How can we prevent users from guessing the name of the document and reach it.
I am working on a e-commerce site for a while and few days ago I was going throuh the actual plan and checking what's can and cant be done.the way I am getting data in and out of the databse is having a mojor issue with the speed here. Can I create a static page of feature products as they are updated once every month.. basically I want to be able have the products in the dadabase and but its no point calling up to the database to get these information everytime someone visits the page.I want to create a static page so that it only changes when an administrator request it to change.like a monthly update.
I am trying to create a file on another server, but I get either "Permission Denied" or "Path not found" errors. If it helps, the folder I am attempting to put it in is a shared folder. here is the path that I am trying to put the file in...Code:
set f=fs.CreateTextFile("192.168.50.15E:Common est.txt",true)
I have looked on the net, but obvious not in the correct place for this.with this mega tourney site i am working on, i am thinking of several ways to do this efficiently. so what i want to do, is when a new tourney is created, create a folder on my server that is named the id number of the tourney. this is the easy part.
next, i will have a temp folder with all the tourney files in it, that i would want to copy to the new folder. but i have not found a good way to copy these files.can someone stear me in the right direction?currently, i have been using querystrings to determine the correct id, and it is working fine. i just think that doing it this wat, would be easuer to keep each event seperate.
i know how to create text files using ASP, but is there any way to create fixed width text file using ASP? i need to have the data lined up in the same location at each row.
I need to implement the following functionality in asp. I have got an asp page which renders some html onto the browser.Now instead of rendering the html to the browser i should save that as an html file in server itself.
I have made a asp page that will read a db table and select certain fields concerning the current day's activities to be written to a text file. After the information about the current day's activities has been compiled, it is stored in a variable and written to a text file.
What I would like to do is create a text file for each day instead of over-writing the same one. Is there another Server.CreateObject method that will allow the 'creation' of a text file rather than just over-writing a text file that already exists? I would use "month(date)", "day(date)","year(date)" to append to a text file name to keep it unique.
Below is what I currently use to create a text file. But any new information will only overwrite what is already contained in the text file. Code:
I want to be able to log in a database any transactions my users perform. For example logging in, requesting a page, downloading a resource, logging out etc.
What is the most practical way to code this? I was thinking of trying to use an include file which would have a function to add a log in the database for each page on the site or when a particular action is performed.
I have a website that we display images we have saved into a SQL Server 2000 database as binary BLOB. This is on a Windows 2003 Server. Just recently (a week ago) this website began to save the images it is displaying on the website as ASP pages in the Temporary Internet Files > IE.Content > Folder.
We have other websites where we use the exact same code and these do not save files on the server when they are displayed.
Here is the code to display the image: Set rs = objConn.Execute( SQL ) Response.ContentType = "application/octet-stream" Response.BinaryWrite rs("Product_Image")
SQL is the SQL String to get the image from database
When I add this code:
Response.ContentType = "image/jpeg"
The images still display on the website, but now are saved in the Temporary Internet Files folder as JPG's.
How do we have a track of users who have logged in? I want to have a table of record with usernames and the status(logged in or logged out).
Whenever the user logs in, the status shud indicate he is logged in and when he logs out the status shud change accordingly. Does anybody know how to do this???
I am using asp codes to connect to my access database. But i have a query in mind. Will my database still work if more than 1 user is logon to edit the database records?
is this a permissions issue that happened at the server side When I go to one of the .asp pages it brings up the "malicious code" prompt,asking whether I should open or save the file. How do I make it so it just executes the file?
My database tables uses two users, namely dbo. and viss. so in sql server 2005, every table has the following name structure:
dbo.members viss.customers etc
In source code, sql queries are used without adding usernames. Like,
INSERT INTO members UPDATE customers
Now I get sql erros as 'invalid tablename members' to solve this I add username to query, like dbo.members. That would solve the problem, but is there an easier way to solve this? Because I'm working with a complicated application and it has allot of files, adjusting each query is an option but any other solution? Code:
I have a database that is setup with a messages table... I have been asked to modify the following script to do the following...
Message ALL Users or Message All Admins or Message Individual Users (with the option to select multiple users - such as 2 or 3) or Message Individual Admins...
The Database is designed with a User table and each user is assigned a "Type" such as "admin" or "user" - can anyone look at the following and give me an idea how to implement this function?
It needs to be setup where the admins and users are seperated so its ok to have two Options boxes that display a users section and a admin section..
I have an intranet which all staff have access to. All staff can log in to the intranet to amend their own personal info. Currently staff have seperate passwords for logging on to their machines (ie ACL on network server) and logging on to the intranet.
Is it possible to have someone automatically logged in to the intranet based on their windows username and password for the domain?
Just wondering if anyone else has tried this. I think I saw this as an option in ASP.NET but my intranet is built using ASP.
I want to create a page in ASP language which gives me information about currently logged users. I thought to do it by this way: when somebody will log in to page, there will be a value of this user id stored in the table among the other fields in the form which are filling in. After clicking on the button "Log off" the value of the user id will be deleted from the MS SQL Server 2000 database. I would do it, but I don`t know how to solve the problem when somebody will close the Internet Explorer window by clicking "x". Then the procedure of deleting a value of user id will not call, and this value will be still stored in the database, so I will not have actual state of currently logged users.Maybe there is another possiblity to do it?
I need to display information a list of Active users on a web site.I can do the count using the global.asa but need to display individual information about each "active user" without writing it all to a database and then pulling it out again.Info I need :
IP Address - Request.ServerVariables("REMOTE_HOST") The page they are on - Request.ServerVariables("SCRIPT_NAME") the page they were on - Request.ServerVariables("HTTP_REFERER")
Can I write this stuff into sessions and call them all out?
I need to authenticate users to enter in a NTLM-protected virtual directory,but I can't pop up a NT-login dialogue box - I can only do a web-based username/password form (my client is a "usability" firm!). After searchingand searching, I finally found up with this solution to use ADSI to authenticate users transparently:
http://www.eggheadcafe.com/articles/20010126.asp
I tried the script and I am able to authenticate that the user exists with the correct password, but when I redirect the user to the virtual directory,the popup box is still popping up! I think what is happening is that I am not actually passing the username/password to the NT server.
Is anybody familiar with using ADSI for NT log in's?Am I on the righttrack?And if so, how do I actually do this so that the NT login boxdoesn't pop up?
I am trying to create a website for students where they have to log in before they can access any of the materials on the site. Therefore the login will be done on the homepage. Providing log in is successful, I then want to be able to track which student downloads which materials. I know how to deal with the login code but am not sure when I create the session variables to track the users. Is this done on the following page? Also do I need to use the global.asa file?
does the session on start event happen the minute the student arrives at the homepage or can I tell it to start once the students have logged in? any advice will be gladly received.
i would like to automitically log when a user signs in, presumably using a seperate Access database. Can anyone point to to a simple way of accomplishing this?
We have an extranet located on one server that users access via a redirect on a URL. To access the extranet, they click on a link and have to enter their windows network logon details.
They then access the extranet which is based on Microsoft Sharepoint Services. I have written customised ASP pages, located on a second server on the same network, but want to use the same windows logon details.