I 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? ...
I 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 Relatedmy 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 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 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 have aproblem to transfer a data from table x to table y based on id. Its mean when 2 table have same id all data table x must move to table y. I don't know which command need to use is it insert into or update?
<%
Dim conn
Dim rs
Dim MYSQL,MYSQL2
Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
Set cmd = Server.CreateObject("ADODB.Recordset")
conn.ConnectionString = "DSN=prmm;UID=administrator;pwd=sa"
conn.Open
startdate=request("tarikh1")
enddate=request("tarikh2")
MYSQL = "SELECT * FROM table_x where paymentdate between '" & tarikh1 & "' and '" & tarikh2 & "'"
rs.open MYSQL,conn ....
I am trying to display the content of a Table called
'Order Detail' directly from the database (e.g., Northwind.mdb). I have the following commands:
Set tableSet = Server.CreateObject("ADODB.Recordset")
tableSet.Open table_name, DB_name, adOpenForwardOnly, _
adLockOptimistic, adCmdTable
where, table_name = ''Order Detail" Or
table_name = 'Order Detail' Or different variations.
I always get error on the second command with the following message:
Syntax error in query. Incomplete query clause
which I believe because of space in the Table Name. How can I resolve this issue? (working with file or table name with space)?
I have a table with many txt boxes which i have inside a form with a submit button to an update page which adds all the details to a db. The problem is i have a another table inside the first e.g. table 2. i want to be able to update table2 by clicking a second submit button that would update it. Is it possible to have a form within a form or how can i do it??
Also i need to update the entire table in one go. For exampple if i have 3 records in table2 i want to be able to update them all by clicking the one update button. Code:
I have the following code but this is inserting manually. I want to make a query from table 1 and automatically enter the records into table 2. What needs to be modified? Code:
View Replies View RelatedHave an app which dynamically creates table rows depending on records, these can be several hundred (don't ask). Hence a very long page at time. Each row includes a hyper link to a new page, and a link back to the original page.
Is there any method (maybe via js) where on leaving the second page l can redirect the browser to the table row the end user clicked on? Hence the bookmarking. Can do this via Visual Basic on the desktop app, but can't work it out on the web app.
I have a table produced with names across the top and services down the left hand side with boxes for numbers for people who recieve services then the info is written into a table in an access db. That works fine and here is that code:
View Replies View RelatedI have two tables. Table A has 20,000 records, Table B has 2,000 records. Table A is what needs to be updated from the data in Table B. Only some fields will be updated and of course, only some records - both tables have the same field as a ClientID so matching up records should be easy.
Anyways, been a while since I have used ASP to work on things like this but would like to work through this one. I understand the process I believe, it is just how to make it go on to the next record once it has finished updating the first.
Basically, I was thinking of having it set up to reaad the top record from Table B, update applicable data in Table A. Delete that record in Table B. Move on to the next.
Hello I have a page for registering users.
I am reciveing this error:
The following errors occured:
- An error occured. -2147217904 : No value given for one or more required parameters.
there are students and teachers. therefore I have 3 tables one for logins and one for staff and on for students.
I have a form designed to capeture the need information.
in the code I am runing an if and elseif statmetn to determin the tables. I then insert the userid and password into the login table.
then i enter the remaining information into ither the staff or student table. what i am trying to do is select the perimary number that is generated as the userid and passeword are enterd. and add this to the second table. Code:
I want MS Access 2000 database column of table 1 = column of table 2. This is what I was doing: Code:
View Replies View RelatedI have a database app that I'm building and displaying my results in a table.
I need to know for anyone who can help how to have one row say red and the next row say green for instance.
I have menubox that shows all the datbases in a directory. When the user highlights a database, the chosen value gets stored in an Application variable(its a control panel).
Id like this Application variable to populate another menubox with a listing of all the tables within the selected database. However, I'm having trouble getting these values and google hasn't been much help. Code:
Can i, using asp code, create whole new table in my DB?
I have clients on my site and each client buys itmes and i want to store the purchase list.so i thought that each client has its own table like member "John" has "JohnOrders" a table reserved only for him..
Which means i need to create a table using code each time a user register.
am i doing this right beacuse i've seen people have just one "ORDERS" table but i cant understand how the stuff all the info about all users into 1 table?
how can i get the table row index so that i can highlight the entire row when the user click on the row.Below is teh code i have tried but failed... cos it only hightlight a single cell.
var oSelected = null;
if (oSelected != null)
{
oSelected.bgColor = "white";
}
oSelected = window.event.srcElement;
oSelected.bgColor = "lightskyblue";
i want to create a table from a txt file seleted by the user and display on the browser. anyone can offer some tips on ow to do it?
View Replies View Relatedhow to convert xml data to access table using asp.
View Replies View RelatedHow can I add table gridlines to this? border of 1 inch?
<%
call OpenDB()
set rs = Dbconn.Execute("EXEC spRES")
Response.Write "<table>"
Response.Write "<tr>"
For Each oField In rs.Fields
Response.Write "<th>" & oField.Name & "</th>"
Next
Response.Write "</tr>"
Do Until rs.EOF
Response.Write "<tr>"
For Each oField In rs.Fields
Response.Write "<td>" & oField.Value & "</td>"
Next
Response.Write "</tr>"
rs.MoveNext
Loop
Response.Write "</table>"
%>
Trying to access an SQL Table....
'ATTACHMENT'
I have a form that is set up to search the table and attached is the code that is trying to get data from that table.
Need help please, if anyone has any ideas.
This is the error Im getting:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '2003'.
/pub/property/tpp/SearchRes.asp, line 124
I cant figure it out.
On an Intranet Web application I'm working on, I need to
display a Pop-up that shows the users what report changes
have occurred. This may happen once a week or more and I
need a way for the users to turn-off this Pop-up after
they've reviewed the changes.
Currently, I'm debating whether to use cookies or build a
table that will set flags. I'm not sure what the best
solution to take would be. Does anyone know what would be
the best solution? I don't like the idea of using Pop-
ups. I'd rather have a link for the user to click that
shows the report changes, but my client wants to use pop-
ups.
If I use cookies, how do I create one, and how do I update
it so it knows when to and when not to display a pop-up?
I've never created a cookie before, so if someone has some
sample code that would helpful.
As for the Pop-up, I've seen pop-ups that loads a new
instance of IE, and I've seen pop-ups that look embedded
in the current instance of IE with a close option. I
would like to create the latter pop-up? Has anyone done a
pop-up like the embedded one before? If so, where can I
find some sample code on how to create one?
what is table relations?
what is its advantages?
how to use in asp?
how does it effect to perfromance?
should we use it?
if i use it, can i get records of two tables in a only recordset..
If there is three table,
let say A,B and C
C store the B id, and B store the A id
now what i trying to do is search from C table to get result in A
and display the result from A table..
hv any idea?