Record Adding Twice Because Of Id Retrieval?
Ive got a tool that is taking sugestions and updates from users and then generating a unique id based on the date and ID Autonumber field from an access db. I am using the addnew method b/c it is the way i know to immediately retrieve the id.. The problem is im trying to add the id back into the record on the same call. Is this possible?
My code is as follows but i seem to be getting duplicate records with unique id's.. But the thing that seems strange to me is that both records have their own unique id. If this were the case i would think that the first record would not have the unique id b/c it is not generated until after the first update call? Code:
View Replies
ADVERTISEMENT
after i add record from this page, when it link to the next page.. everything is blank, but the record has be added. how can i display the newest record with the old one after i click the add button?
code ...
View Replies
View Related
I want to add records to my table with an insert query. My access database has an autonumber which creates a unique Id for every record. If I add a record will the auto number be a problem or will it increment itself on its own?
View Replies
View Related
I'm trying to write an on-line db update. The user can select a table from a list which is passed to an asp page that displays a the full table (fields and all records) and at
the bottom I've added another row to the table which contains an input field for each column so that the user can add a record. Code:
View Replies
View Related
i have a access DB, and a asp page to add the records to the database, i work on visual interdev, i get error when i run the code as:
ADODB.Recordset (0x800A0CB3)
object.provider is not compatible of performing requested operation.
/project/addprocess.asp, line 37 'points to rs.addnew line
my entire code is Code:
View Replies
View Related
I'm using Access and have 2 field called DateAdded and EventDate and both are formated at Date/Time (shortdate). When I try to add a record I think it is bombing at the dates. I can insert a record if I don't call that portion. I tried FormatDateTime(date,2) But it still doesn't work.
View Replies
View Related
i cant add a record to my access database! i think the code is right which i used asp script but then only blank record was added! It added a record but then no data in it! Code:
View Replies
View Related
From the past I have been adding records with a form with 2 pages.
One with the form and the other a add.asp page to actually take the values from that form and add to Access database.
Just for example I had the form on:
p1.asp and when they click submit it goes to
p1add.asp and adds it, but is there a way to add it with just p1.asp?
View Replies
View Related
I'm trying to add a record to an access database using asp. I create the database, the input form where i put the information, the asp code where i process the information and last the asp code to view the record added but when i press the submit button it show me a Downloading box for a downloaing process.
View Replies
View Related
I am planning to build a basic page that brings up images from a Database based on keywords.
View Replies
View Related
i now have my dropdown connected to my database. everytime the user adds a new record, he simply has to choose a Department from the dropdown menu. However, when he tries to edit that record, the value that he has chosen from the dropdown and has been saved to the database cannot be retrieved in the dropdown menu.
so i want to retrieve the data from the database INTO THE DROPDOWN so it would be the default value of that dropdown menu when the user edits his specific record.
View Replies
View Related
I have an sql statement like this executed with asp and mysql.
select * from table1, table2, table3
How can I read a specific field from a table when tables have same fieldnames.
So for example table1 and table2 have both a field named content.
What I would like to do is:
contenttable1 = recordset("table1.content")
contenttable2 = recordset("table2.content")
But then I get an error like item not found in recordset.
If i do this it works but i don't know which field I read from:
contenttable? = recordset("content")
I know that it works with Access but I can't get it working with MySQL.
View Replies
View Related
If a sql query returns 20000 records then what is the fastest way to display records on a web page.
View Replies
View Related
Im trying to do a simple password retrieval script that displays a users password on screen.
Im being told their is a syntax error:
Syntax error
/Kosy/password.asp, line 30, column 7
.write & strEmail
Code:
View Replies
View Related
I have a web page with three fields, Name and designation, salary. The name field is a <select> tag which contains all the names present in a tabe. When I select a name, the corresponding designation should be displayed. Then I enter salary and submit the form. There are two submts involved?
View Replies
View Related
Already have an asp page showing results from an access database table (supplies)
Need to know way select items from this list w/o the need of retyping to another form.
Also would like to be able to insert order_date automatically to another access table (orders).
View Replies
View Related
A problem recently cropped up that I have not seen before and I am wondering anyone has seen this one?
The 2 SQl Select statements on my ASP page differ by the addition of one column ("Description") but in the 2nd case, column content is dropped (blank). I can get somewhat different results by adding other columns to the Select. Code:
View Replies
View Related
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:
View Replies
View Related
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 Related
I 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 ?
View Replies
View Related
I have a form on my asp page that sends data to an emailing script. I am working with other peoples code which is causing a lot of hassle. Is there any way of sending a Bcc address command from the form rather than the emailing script?
View Replies
View Related
I wanted to know how I should go about doing this. I have this query:
SQLmax="SELECT Max(OrderNumber) AS intTotal FROM Status"
Which gives the Max(OrderNumber).Say in this case it is giving out put as 37.
Now i want the output to be displayed 38,which can be done by adding 1 to Max(OrderNumber).
Should i get this by doing this way?
var=RS(intTotal)
var=var+1
Response.WRite var
Is this right?
View Replies
View Related
Im using this code to pass a value to a variable:
<a href="Artists.asp?cat=<%=Server.URLEncode( rsuser( "art_Artist" ) )%>"> <%=rsuser( "art_Artist" )%></a>
How do I add another value to this link with the variable name catArt so that I can add:
?catArt=<%=Server.URLEncode( rsuser( "art_Artist" ) )%>
View Replies
View Related
what do you think is the best way to implement an "add new row to table" functionalilty?
am using asp(obviously )im currently using document.createElement with javascript, but im having a hard time retrieving the data.am also thinking if this is really the best way to do this.or if this would work with all other browsers other than IE...
View Replies
View Related
how to add a password to using this connection string
<%
set conn = server.createobject ("ADODB.connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("dat48372.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
SQL = "SELECT Price FROM DABRadios WHERE (ID LIKE 6)"
rs.Open SQL, conn
showall=true
%>
View Replies
View Related
i have a id1 field which has data like this 002,003,004 and i have to increment it by one when i add a new customer so this is what i do
Set rs1 = Server.CreateObject("ADODB.Recordset")
sql1="Select Max(id1) from table2"
rs1.Open sql1, Conn ,2,2
maxid=rs1(0)
so i get the maxid for example as 003. the next record will be added and it should be 004 and i do it in this way maxid= maxid+1
but when the record is added the id1 field has a value of 4 instead of 004
View Replies
View Related
Say I have to different recordsets that have the fields:
rsA.Fields.Item("A").Value ,rsB.Fields.Item("B").Value
How would I add those to fields? It may be my inexperience but when I
tried something like
rsA.Fields.Item("A").Value + rsB.Fields.Item("B").Value
didnt work because one of the fields was a empty value. I have about
6 fields i need to add together if a value exists in any of them.
Suggestions?
View Replies
View Related
I want to fix this problem, i dont no how. Bassicly there is blank data appearing in my database, for no apparant reason! Code:
View Replies
View Related
How can I add a new user on my server using ASP?
User example: myserver/user1
View Replies
View Related
I'm new to ASP and a few querys
I have created my database in Access with the following fields
StockCode (Text Box, Primary Key)
Item (Memo)
Price (currency)
Picture (memo)
OnOffer (Yes/No)
and I know that access table cannot have a picture in it, only a access
form using OLE, but how do I get my asp page to display a picture for
every record? The picture would be a picture of the product with the
Stockcode as the filename - m001110.jpg?
View Replies
View Related
I have an ASP page with a table that fills with records from a loop. Every
row gets a link to another ASP page with data from the row. The link is
written as <a href=newpage.asp?value1=xx&value2=yy .... and so on.
Now I try to let the user specify a number that should be sent to the other
page. But I do not want to clutter up every row with each an input field,
so I thought instead I would place it above all the data rows. When the user
clicks on the link, I want to include the input field to the querysting. The
problem here is that I cannot figure out how to refer to the name of the
input field.
View Replies
View Related
I have just finished building my first shopping cart in asp and MS Access. Originally the shopping cart was to be built for products with no size and colour, however as usual the goal posts have moved and I now need to incorporate a size and colour option for each product. Could anyone explain to me how I can go about doing this i.e. adding the different sizes and colours in the admin website and then linking them to a specific product when it is displayed on the products page? I know they both need to be in a dynamic drop down box when displayed on the products page within the shopping cart, but I am just wondering how to read the correct values out from the table depending on which product is being displayed. I have a normal products table at the moment with general fields i.e ID, name, description etc.
View Replies
View Related
I have a web page hosted by server1. I need to add a link to a web page hosted by server2. This part is simple. However, I also need to give the linked web page the user id for the user that was validated in server1 (it's in a session variable).
At first, I thought the following would work:
mywebpageonserver1.asp:
Response.AddHeader "MYUSERID", "whatever"
Response.Redirect "http://server2/mywebpageonserver2.asp"
On server2, mywebpageonserver2.asp:
View Replies
View Related