Updated A Record
I use a popup window to add a record to a database that is displayed on the webpage. How do I trigger the parent page to refresh from the popup?This could either be a hyperlink or to happen upon closure of the popup.
View RepliesI use a popup window to add a record to a database that is displayed on the webpage. How do I trigger the parent page to refresh from the popup?This could either be a hyperlink or to happen upon closure of the popup.
View RepliesI m developing a site n creating a enable/disable page. In this page when I enabled a user then in DB field user enable once n value is entered "Y" but when I updated user field n I disabled then DB is not update plz help me friends.
View Replies View RelatedI am using an Insert command in my asp code that Inserts a rows in my database. After the Insert command i create a recordset and ask for all the rows in the table that i aplied the insert command Some times the rows i get are correct but sometimes the database is not updated by the time the recordset is opened.
Is there any way to wait until the table is updated with the new rows and then open the
recordset? ...
my work lended me a book, Active Server Pages 3.0 for Beginners by WROX.So far its been pretty good, but here is the bummer,its kinda old. Since I am new to ASP, am I better off just sticking with this book and getting through it, or do any of you recommend one that is more "updated" or such and could be just as beneficial? This thing was reprinted in 2000.
View Replies View RelatedI 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 ....
Does anybody have code to add a "Database Last Updated...." line on your webpages that are generated from an MDB? There is simple ASP and javascript for 'page last updated', but the code that I have found just detects the time when the page was generated, which is every time the page loads since it is querying the database.
Im looking for code that queries when the database was last updated, then displays that info on the page.
I'm trying to create an XML guestbook. I'm using a form for the user to input his name, e-mail, message etc. an .asp file to update the xml file and an .htm file with javascript to display the xml file. The .asp file contains a <meta> tag to redirect the user from the .asp file to the guestbook.htm file. Following the submission of the form the script in the .asp file runs fine and updates the xml file but the problem is that when the xml file is accessed by guestbook.htm in appears to be accesing a cached version. For it to display the latest entry i need to access the xml file directly (http://....../guestbook.xml), refresh it and then return to the .htm file.
View Replies View RelatedI'm unable to update a session variable
btween pages. I can read them after I set in global.asa
and I can change its value within the same script but when
I go to another page, the session variable remains
unchanged.
I think this should be simple but cannot find it:
I use a update query like
sSQL = "UPDATE PLAATSEN SET PROVINCIE='1' WHERE PROVINCIE='Noord-Brabant'"
ADORSEXECUTE(sSQL)
2 things I want to do, check if query is success and display message with number of changed records. How can I do this?
I have a SQL database with a ASP frontend. I can update my record without a problem. What I am looking to do is update the record by pressing the submit button and when the record is updated display on the same page that the record was successfully updated. When I update my record now, I have it where it redirects me to a different page. I would like the message to appear on the same page.
View Replies View Relatedi am working with asp 3.0.whenever i enter new data and want to view the data. i can,t view latest data(it shoows the page last visited), i have to refresh the page , then i can view the latest updated records from database.
View Replies View RelatedI figured out how to display data from an Access mdb file using ASP, but my database is continually being updated in real time. The only way for the end user to get the most current data is they have to refresh, or I have to code the html to refresh like every minute, which is really cumbersome, and bloats the logs. Code:
View Replies View RelatedI'm using VBScript to display a list of the ten most recently updated
pages on my web site. Right now, the script lists the filenames and
the date modified in a given directory.
What I want to know is if there is any way to extract the page title
and display that instead of the file name? Can I use .asp and VBscript
to "delve" into the file and extract the title? Code:
I'm getting this error message: Error Type:
Microsoft JET Database Engine (0x80004005)
You cannot add or change a record because a related record is required in table 'employees'. Code:
I have an insert record form that posts fine to a db which automatically creates an ID how could I get the next page to do a preview using the ID just created by the DB to go to the right record?
View Replies View RelatedI have a .asp page which lists a date, then a bunch of record lines for data that falls within that date, then the next date and it's bunch of data record lines. e.g.
Ship Date: 04/06/04
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Ship Date: 11/07/04
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
What I want is:
Ship Date: 04/06/04
1: Data xxxxxxxxxxxxxxxxxxxxx
2: Data xxxxxxxxxxxxxxxxxxxxx
3: Data xxxxxxxxxxxxxxxxxxxxx
4: Data xxxxxxxxxxxxxxxxxxxxx
Ship Date: 11/07/04
1: Data xxxxxxxxxxxxxxxxxxxxx
2: Data xxxxxxxxxxxxxxxxxxxxx
3: Data xxxxxxxxxxxxxxxxxxxxx
How can I get these numbers printed againsts the records ?
I want to download record set from my SQL database as csv format but in ZIP file .I can download as a csv file now ..But i can't put that in zip file and download.
View Replies View Relatedhow to deal with multiple recordsets on the same page?
It's gotta be something small and clear so I could understand.
Somewhere I've read that multiple recordsets are not allowed when using Microsoft Access Database?
I am looking to
have some sort of SQL Trigger maybe? I have a field called 'dateActivated' and 'isActive'I'm looking to somehow say when dateActivated + 6 months then set isActive = false. I want this to
be automatic. I am using ASP/VBScript if this somehow matters.
I have a form on an asp page which is used to add additional users to
the DB, i.e. adding a UserID (PK on table), Password & Email.
The companies are allowed a max of 3 users. If the company only has
the default 1 user and wishes to add another 1 or 2, then the form
displays the current user details, not in text boxes as this is not an
adit data form. The additional user/s can be entered into 1/2 rows of
text boxes, user 2 & 3.
If they decide to add 2 new users, how do I add the additional 2
records to my db table on submit ? Code:
i am tryin to run a search on a db and am using a like statement which works fine but i want to select what it finds and also the next 9 records any idea on how to do this
View Replies View RelatedIs there any way to change the following code so that when it's the second last record in the set it doesn't put UNION ALL at the end? Basically, is there a way of saying:
if SecondLastRecord then
I don't know how many records there will be, so I can't count down from 7 or anything.
Code:
Every time I try to ADD a new record from my asp page to SQL table, I got this error:
Microsoft OLE DB Provider for SQL Server (0x80040E2F)
Violation of PRIMARY KEY constraint 'PK_Cancelled_Classes'. Cannot insert duplicate key in object 'Cancelled_Classes'
Here is the Insert statement:
Sql="INSERT INTO Cancelled_Classes (yrtr, cou_id, cancell_date, Message)" sql=sql & " VALUES " sql=sql & "('" & Request.Form("yrtr") & "'," sql=sql & "'" & Request.Form("cou_id") & "'," sql=sql & "'" & Request.Form("cancell_date") & "'," sql=sql & "'" & Request.Form("note") & "')" '
conData.Execute sql
I had a problem that happen once only but i do not want it to repeat
again. It happen when i retrieve data from my database. The process
can't complete and show error 14, Out of string space. I suspect the
recordset object had reach it limit that why it generate that error
message but what can i do to prevent this from happening
I have a siple script where I add a new row in a table which has also a autonumber field. Adding the new row I am trying to get this value of the autonumber field and put it in session, but can not seem to figure out how. I tryed to open a new recordset and pull it out but does not find the record I just added.
View Replies View RelatedThe only database connection I have ever made using ASP is to an SQL2000 Server. I was just wondering if someone could provide me with a nice simple script opening a connection and recordset to a MySQL database and providing a valid connection string.
View Replies View RelatedTrying to learn a little asp and am trying to have my form (when the submit button is pressed) put the value in a field in my database. it worked the first time, I typed in the word testing and clicked submit.
now whatever I put in there it creates a new field with the word submit. Can someone tell me what I'm doing wrong here? I'm positive there's something wrong with my code here. Code:
If Request("submit")="Submit Questions" Then
Set questionsubmission=connectionToDatabase.Execute("INSERT INTO kitchen_questions(questions) VALUES('" & database_select("questions") & "')")
End If
I'm looping through a record set and want to treat the first record differently. I've got a counter that I check to determine if its the first iteration through the loop, but I was wondering if there is recordset property that would indicate the record's position in the record set.
View Replies View Relatednow i got all my data in my sql db table (fsearch) . now i want to take the value from the db to display it on the browser in the form of a table .
View Replies View Relatedi need to use the same record set in my page twice. some optimization issue [img]images/smilies/biggrin.gif[/img][img]images/smilies/biggrin.gif[/img]. i have arecord set like this
Code:
set newsrs=createOBject("ADODB.recordSet" )
newsrs.Open newssql,cnn,3,3
and i wanna use this twice in the same page
Code:
do while not newsrs.eof
newsrs.movenext
loop
can any body tell me how? coz when i do it the second isnot working [img]images/smilies/rolleyes.gif[/img]
I run a query like
SQLSelect ="Select Number,Type,Description,Retainage_Percent from table_name1"
this returns a value for number. then I would like to run another query on another db
SQLSelect2 ="Select Number, Text from table_name2 where table_name2.Number = table_name1.Number
I didnt know what to title this, so please bear with me. Trying to learn a little asp and am trying to have my form when the submit button is pressed put the value in a field in my database.
it worked the first time, I typed in the word testing and clicked submit. now whatever I put in there it creates a new field with the word submit. Can someone tell me what I'm doing wrong here? I'm positive there's something wrong with my code here.
Code:
If Request("submit")="Submit Questions" Then
Set questionsubmission=connectionToDatabase.Execute("INSERT INTO kitchen_questions(questions) VALUES('" & database_select("questions") & "')")
End If
how to locate the first record...i sorted the numbers and i want to display the first record based from the query...
View Replies View Related