Shifting And Deleting Data

I have two tables: Table-A and Table-B. I extract info into a page from Table-A, Row-1. This displayes nicely into a page. I would then like this info to be inputted into Table-B Row-4 remembering that it came from Row-1.

[so far no problems]

I then want at a later stage, Row-4 to update Table-A, Row-1 with it's contents AND for Table-B, Row-4 to change a value in itself. Hope that makes sense, if so how would I go about it? Otherwise I can really go into detail.

View Replies


ADVERTISEMENT

ASP Application Shifting From WIN NT To WIN 2003

i am working on application which we are migrated asp application from WIN NT to WIN 2003. Here iam facing some problems.

here iam loading .asp file as image on another .asp file to display data in chart. this is working good in WIN NT but it is not loading in WIN 2003. iam giving html tag which we used to load the image

<img src="abcd.asp"> (this .asp is in the same directory)

but this is not loading. Is it the problem with WIN 2003

View Replies View Related

Problems When Adding,deleting,editing Data In The Database

actually, I have a problem while i want to add, delete, or edit a record to a database through a asp page, I can read well but when i want to submit changes using rds object , the data does not change on the source database,

I tried hard to get a solution but i think that the actual problem is only on one figure which is the server value of the data control when i use my own iis server, I do not know this value and microsoft is saying use an empty value but it does not work either.

View Replies View Related

Deleting

This code works fine, it deletes the record that already exist in the database and displays a message to the user the record has being deleted.... but it also it has a problem, if you enter a record to delete from the database and this record does not exist it displays the message that the record has being deleted, while instead it should display an error that this record does not exist in the database.

Code: ...

View Replies View Related

A Little Like Hotmail Deleting......

Ive run into a little trouble. I am sure all of you have used hotmail. Well you know when you select all items to delete, i would like to do something like that, however not delete, but update a field from no to yes.

I would like to add checkboxes to an asp table. So if the user selects say three items they then click on a button, say marked and for each item, it will go to the table and find each record in turn and update the corresponding field from a no to a yes.

Updating is no problem. The problem is, how do i add checkboxes to corresponding asp table. So that particular checkbox corresponds to that particular record. I don't know how to link them together.

Can someone help me out please?

View Replies View Related

Deleting A Page

I have a form that contains many pages. If someone clicks on delete, the application takes the user back to page 1 instead back on page in the breadcrumb trail. It is fine when the user is on page 2 but they could be on page 10 and click delete and then they are back to page one. I want to have the application go back on page at a time each time they click on delete. Here is what I have for code:

If LEN(page & " ")=0 Then
page = 1
End If
page = CInt(page)
If i = page Then
response.write "<font color=""#CC0000""><strong>[page " & cstr(i) & "]</strong></font> "

View Replies View Related

Deleting Folder

I have a script which allows a user to upload and delete files from the
server.Is it possible (and if so how) to do a check to see if the folder is empty
(ie if the last file in a particular folder is deleted by a user) and if it
is empty, delete the folder?

View Replies View Related

Deleting Record

I'm having trouble creating a one record recordset then deleting it. I've never done this before. The code below returns: "Type mismatch: objRS".

Code:

View Replies View Related

Deleting A File

On my webpage users can upload files and also delete those files. Everything seems to work, but when they upload a file that contains spaces, I am having problems getting the file deleted, for example: "This is my file.txt"

Is there a way I can delete this file. I have tried to take out the spaces, but the file still doesn't delete:
<%=Replace(Request("MyFile")," ","+")%>

View Replies View Related

Error In Deleting

this is my code but when i delete all the record there is error dispalyed ?

elseif (strType = "Delete") then
strSQLDelete= " Delete From events where id = " + ID
conn.execute strSQLDelete
response.redirect "eventform.asp"

View Replies View Related

Deleting Cookies

I am using cookies to store the user name and login state on the site. I am having some problems logging people out.

Firstly wanted to make the cookie values null but having some trouble with that

Response.Cookies("Login")("UserGood") = ""
Response.Cookies("Login")("Usercode") = ""

doesn't appear to do anything?

What would be really cool would be to delete to cookie in the logout script, can that be done from ASP?????

View Replies View Related

Deleting A File Using ASP

I have a little app running in ASP which lists a bunch of files that are in a directory. This is attained using the following code:

View Replies View Related

Deleting Thumbnails

I'm trying to delete 2 files using fso. The mail file name is stored in an
access db.

using the code below I can delete the main file but not the thumbnail.

The thumbnail has the same file name plus the suffix "_small" so if the main
file is called "mypicture.jpg" the thumbnail is called "mypicture_small.jpg"

The main file is being deleted but no matter how I try I cannot get the
thumbnail deleted. They are both in the same folder with the same permissions.

Code:

View Replies View Related

Deleting Cookie

I'd like to have a remove all button in my shopping cart.

is it possible to delete a cookie with asp?

View Replies View Related

Deleting Records

I am using ASP with SQL for my database.The problem I have is that even after I have ordered certain items from the shopping cart table on the webpage, I cannot remove them -
that is the entire list shows up the next time the table is opened.

is there any way I can delete the items once ordered so as to not let them show in my table?

View Replies View Related

Deleting Files

How can I delete the files using ASP?Following is th code :

var objFso = Server.CreateObject("Scripting.FileSystemObject")
var strFileName = Server.MapPath(".") + ""+ "SubmittedDoc.xml"
if (objFso.FileExists(strFileName))
objFso.DeleteFile(strFileName)

This is not working.

View Replies View Related

DELETING EXCELL

i cant delete data from excell which i use as a database with asp.i encounter an error report about isam. how can i delete data from excell

View Replies View Related

Keep From Deleting A Record

i have a site that has several joins. I need a function that will go out to see if the master table is using a value from a dependant table before it allows the value in the dependant table to be deleted. nothing more than that.it could be a a simple js function that basically does?

rs = recordset

if count(rs) = 0 then delete field
else
if count(rs) is > 0 then "You can't delete this record"

View Replies View Related

Deleting Text

i would like to delete a specific line of a text file. for instance, if the line i'm looking for is "abc", then i'd like to delete that line only (all the lines are unique).

is it possible to do this? or would it be easier/better to read all the lines into an array, delete the file, recreate the file with the lines from the array, skipping over the line i don't want?

View Replies View Related

Deleting Old Version

I have a problem of deleting old version of files. This is wat happens: Client side sends a few files to the server side via http and are saved into a folder. I need to delete these files when another batch of files are send next time. Any suggestions to solve this problem.

Timestamp is out of question because it is not reliable to use time to differentiate between files within the same batch and other batch. Sometimes the sending might be delay by server. Therefore i need to come up with some sort of detection for new batch.

View Replies View Related

FSO Deleting Files

i'm using the following code to delete a file but when i execute the script it just freezes until timeout. any idea of the problem?

'///DELETE ORGINAL FILE
Dim objFSO
Set objFSO = Server.CreateObject("Scripting.FileSystemObject")
objFSO.DeleteFile "C:Documents and SettingsGavMy
DocumentsDateWebsitewwwuser_images" & filename
Set objFSO = Nothing

View Replies View Related

Deleting Tables From URL

What functions are possible to delete rows, tables, entire database from the URL when displaying records from a database. I want to be able to stop all of these possibilities from happening.

View Replies View Related

Deleting Records

I am not sure if this is the right place to ask. but... I need to delete records where two fields in the same record are equal. I am not sure how to go about this.will this work?

strQ ="DELETE FROM Request_Notify WHERE Field1 = Field2"

View Replies View Related

Deleting Records

I was wondering the correct way to delete records from two different tables using inner join

Ex.{

DELETE tblPunchlines.Punchline, tblCast.LastName, tblCast.FirstName
FROM tblCast INNER JOIN tblPunchlines
ON tblCast.EmployeeID = tblPunchlines.EmployeeID
WHERE tblCast.EmployeeID = 3
AND tblPunchlines.EmployeeID = 3

}

Can anyone show me the correct way to do this

View Replies View Related

Deleting/Creating W/ASP

Alright, I have two quick questions.

1. How do I delete several records with the same data? I.E. 5 items have field propnum=55 and date 05/05/04. I want all of them deleted. What does the SQL string need to be. I know SQL="DELETE FROM bleh WHERE propnum=55" But how to delete all of them?

2. How would I create a NEW table and change the column headings through ASP? I want to be able to delete all records from a certain month but before deleting them, putting all of the data into a new table, one for each month.

View Replies View Related

Deleting File

I have this script in my global.asa file: Code:

set objFSO=server.createobject("scripting.FileSystemObject")

strPath = "C:SPharm3Verif.asp"
set objFile = objFSO.DeleteFile(strPath,true)


and it returns this error:

Run-Time Error Microsoft VBScript error '800a01a8'

Object required: 'objFSO.DeleteFile(...)'

//global.asa, line 29

line 29 happens to be the objFSO.DeleteFile(strPath,true)

View Replies View Related

Deleting Files

I have developed an com+ email component.It's supposed to send files as attachments and then to delete those files(which are temporarily stored in a folder).The code for uploading files is: Code:

View Replies View Related

Deleting A File With ASP?

Is it possible to use ASP to delete a file on the web server?

I have a form that allows users to submit files to my site, but I now want
them to be able to delete their files too if possible.

I know the location and filename of the files (this is taken from a
recordset).

I am not 100% adept in ASP (I am using Dreamweaver to make my site) so an
example would be good please.

View Replies View Related

Deleting Files Via Asp Pages

im just wondering how can i delete a file (mainly pictures) from asp pages and is there any extra permissions more than read & write permissions i need to set for this operation ?

View Replies View Related

Deleting Indexed Cookie

On one of my webpages, I use a cookie to automatically log a user in:

Response.Cookie("USER")("USERNAME") = "Steve"
Response.Cookie("USER")("PASSWORD")= "Password"

This works, but when the user logs out, I want to delete this cookie. I used
the following code:

Response.Cookie("USER") = ""

Although the Cookie collection in the response object now has the correct
value (blank) for this cookie, IIS does not send the new cookie information
to the browser. I have tried this code after the <HEAD> element but before
the <BODY>, I've also tried it before any other code (HTML or ASP) on the
page. I have even tried Response.Cookie("USERID") = "NOTHING" and that
doesn't get sent to the browser. This is classic ASP, what am I doing wrong?
This works fine with non-indexes cookies.

View Replies View Related

Problem With Deleting Db Records

I have a link on my page for each db record:

<a href="<%= strFileName %>?sc=delete&strArticleID=<%= recordset_obj("article_id") %>">Remove</a>

when i click the link, it goes to the correct "case" and will run through my deleteRecord subroutine. I checked it with output at the very beginning and end of the delete routine.

my problem is that nothing happens and i want the record to be deleted.

here is the delete routine: Code:

View Replies View Related

Deleting From Access Database

This is the code that I am using to delete from the database, but it doesnt seem to work any ideas people?

<%
SQL = "DELETE FROM jobs WHERE date = #" & personaldeletejobs & "#"
set Rs = Conn.Execute(SQL)
%>

the "personaldeletejobs" contains a date element.

View Replies View Related

Deleting The First X Number Of Chars

I have a string

ASP Code:
Dim address
address = "C:Documents and Settingsob"

How do i delete the first 26 chars of so when i display this on screen it will only display bob and not C:Documents and Settingsob

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved