How To Read An SQL Server Into A ASP Page And Then Change, Add, Delete And Write It Back To SQL Server
I need to read a SQL Server table into a Web Page and within the Web
Page to permit my users to make changes to the records, delete or add
new records and then save the entire contents back to the SQL Server
table back.
The functionality I am looking is almost the same as In the SQL
Enterprise Manager whereby I can choose a table open the table and
then return all rows and I can maintain the same and save it back to
the SQL Server table. I want almost a similar web interface to such a
functionality.
Even if not a generic functionality as the SQL Enterprise Manager
table maintenance appreciate if somebody can share the code with a
sample how I can do it in ASP pages + T-SQL if need be.
Is it possible to do the following in asp: To read an html page from a server (not mine) every 5 minutes and copy it to my server. The html page just contains a list of numbers.
I have a csv file that has 2 columns - Name and Team. I want to display both of these on a page in seperate dropdown boxes..Ideally I would then like to have an option where the user of the page can click a button to change which team an employee is a part off, in effect overwriting that line of data but not deleting everything else in the file
The code below lets me see each column from the csv file on a page in a separate dropdown box but I don't think I have the logic right to do what I need..I've checked Google and w3schools but I must not be searching for the correct thing as I can't find a way to do this... Code:
How can I change a server.mappath back to the virtual path. I am creating a search function on my site and it search through the files on the server. I start with the server.mappath("/") and it searches through all the files just fine but the file path is displayed at d:sitefolderfile.asp. how can i change that path back to the virtual path (/folder/file.asp)?
How would I get an ASP page to delete an image file, probably a .jpg off the server.
Basically, what I want to do, is that when the user deletes a product item from the database, it will also delete the corresponding image file from the images folder. So that the server space doesn't just fill up with redundant image files over time.
If it makes any difference the image files are uploaded using a PHP script, I've no idea how it works, but it does.
I have a Product and that product contains some documents.The documents are uploaded to server and can be viewed in my asp application.
In admin module i have given option to edit or delete that product.In the event of edit just the records in the database get changed.But in the case of delete i have to do 2 things
1. Delete all the data related to that product. 2. Delete all the related documents for that product in the server.
So can anybody help me figure out how to delete a file using asp in ftp server.
what r things that I have to do to let the client browser to delete a file on the server. I'm running my server on WIN2000 pro, IIS 5.0. I've stored my website and server in a virtual directory. This is the code i use to delete a file from the server folder
Code:
Function delete_file(exceldb) '***************** Delete********************** Set fso = CreateObject("Scripting.FileSystemObject") Set fileObject = fso.GetFile(Server.MapPath("..upload2uploads"& exceldb))
fileObject.Delete Set fileObject = Nothing Set fso = Nothing ' Deletes exceldb End Function
I was wondering, is it possible to disable the back button in internet explorer.
Our Website is hosting a Siebel website, and the problem is that Siebel has problems with the use of the back button in internet explorer. I can't make a customized internet explorer because the site must be accesible anywere.
Ok, the following page uploads files to the server and renames them according to the item ID and database table (or update type). It also replaces existing files. There are potentially 5 files for each item ID (see FILE REFERENCE). Code:
I was testing the date formats with different values set to Session.LCID and then I removed the Session.LCID completely from my asp page and expected the date format to show according to the Regional settings of the server but it was showing the last format of the Session.LCID.
My question is how to remove the value which I previously set to Session.LCID because I want to use back the date format from the Regional settings.
I have the setup working close to what I am after. The upload script I am using has been supplied by 'Lewis Moten'.
Basically what I am after is.
A job application contact form. that includes a input="file" element allowing the user to send a CV, to the address related to that job.
So far locally I have the file uploading, the file sent, and then the file deleted all working fine. Althoug this may well work locally I feel I will have problems when I come to trying this live. Mainly due to timings.
Surely the script would need to know when the file has been uploaded completely, also when the file has been sent completely before delete....
I'm trying to write data from a form using a text box (textarea) that has a return after each item. For example:
Join Bytes! Join Bytes! Join Bytes! Join Bytes!
I'm getting the data written to the SQL server table fine, but every item after the first is getting written with a special character preceeding the email address that looks like a little box. What is it, why is their there and how do I remove it?
When i use this it also gives me the domain name as well as the username. (example, amrswbouse) I know i can do js to trim off the first few letters but i want to know if there is a server variable that will save me the effort.
Can I read mail (from an inbox) on an exchnage server with ASP?
If so, how?
I hear all this about CDO, CDOSYS, etc, but they all seem to be able to only send mail. I just need to read mail from exchange server. Can this be done?
I have an ASP page that goes from part to part based off of a session variable. Is there any way to check for when the user clicks back so that I can change the variable. If not I will have to separate all of the pages out and that is just not fun.
So, when the user clicks back, the session variable gets changed. That is what I am looking for.
P.S. Is there a faster way to check if a variable is blank other than an If Bleh="" Then <some code> End If
P.P.S. When a submit button is clicked, I want to open a new window with a message like "Be sure to fill out this on page X"
I have a simple add/change/delete feature going on. I have a products table that I'm selling mock products from. I have a column named category, which users either select baseball or basketball from the radio buttons on a form. I can't figure out how to make this work. I'm implying that the code is working, the record is adding to the database, just not the category field, and when I display all the fields out of my database onto a html page the category field is blank. Below is the code I have.
I have client who has database full of crap. One field in the "property" table is imageurl. I have been able to successfully extract only the file name from the string, such as "2030323.jpg". All images are stored in a directory called "listings". What I am trying to do is to loop through the recordset, and read each imageurl.
If there is an image file in the "listings" directory, then delete the file. It appears that some fields contain imageurls that no longer exist in the listing directory. Here is the code I have so far, I almost had it, as it told me at one point the file didn't exist. Then I screwed up the code and this is where I am at: Code:
I need to do something very basic in asp. What I want to do is have one page that has a text box, and a button... the user can type whatever in the text box, and click submit, and it will create a txt file. Every time the button is pushed it overwites the file...
Then on a seperate page, whenever the page is loaded, it reads from the file and posts it on the page..I think this is very basic, but I'm very new.... I need to write it in standard ASP. One other thing that would be helpful is to have a limit on the amount that the text box will hold.
Im writing a web interface for a CRM product which has the ability to store files within a database... Now, the problem is, these files are binary files, and VBScript doesn't have support for binary files (as far as i know...)...
To overcome this i wrote a component (ActiveX DLL) in VB6. This component works fine, but as soon as i use it in ASP, my computer beeps and then sits there looking like it's doing something forever...
I was working on my site yesterday -builiding on laptop -and was able to add/edit data to my database fine.
Today i get "Operation must use an updateable query."
I've checked the lit. and it seems the most likely explanation is that the folder or the DB has read only permission set. So i checked out this in IIS and it seems everything is OK - i enclose pics of the setup -
I can't see what else is causing this.
I made a cut down page just to test the query and the same problem is occuring. I even rebuilt the database - access - just in case it was a corruption of some kind but nothing seems to work. I can retrieve data no problem just can't write or edit.
I've enclosed the code that i have used as a test just in case i'm missing something. Code:
