I have a recordset with two three fields. One is an autonumber field called ID , one is a text field called Name and the last is a date/time field called DateEntered. How can I programatically determine the autonumber field ? Code:
View RepliesI use (something like) following code to add new records to a database, but it doesn't work!!! I need to know the value of an AutoNumber-field when I add the record. Why doesn't it work and how can I make it work? I think it should be easy, but I can't figure it out! Code:
View Replies View RelatedI have a page that does an insert into a table in an Access DB which has an autonumber primary key field. Following this insert I need to be able to get the ID that was generated. If I were using SQL Server I would simply return fetch @@IDENTITY from a stored procedure for example.
Does anyone here know of something similar I can use in Access to be able to get that ID? I tried just using a SELECT query with all the information I had just inserted but it comes up empty unless I put it in a separate request (i.e. redirect to a new page passing all the info through the querystring and then building the query on the redirect page...which is a huge pain and takes FOREVER to run.
I'm writing a database admin page in ASP. I had it adding records correctly. Then I added an autonumber field ("ID") to the table, and it stopped working. The sql I'm using is Code:
View Replies View Relatednot sure the best way to achieve this but basically i would like to have two sets of radio buttons. The first set determines whether the field DateFrom is todays date or a date entered
and the second set determines whether the field DateTo is todays date or an entered date
So far this is what i have got and its not working Code:
I've searched the net but I couldn't find any SQL code on how to insert an autonumber column into an access database and table. Can anyone include the code?
View Replies View RelatedIve got a table in an access database and I want to generate my own autonumber
based on the number of records in the table. Code:
I'm creating a basic ASP guest book, keeping my guest book entries
in a Microsoft Access database, and using ADO to access it. My problem is
that I am using the autonumbered ID field to split my guestbook into pages
of 10 entries. It works for the most part, but if I delete an entry, a gap
is left in the records and I end up 9 entries instead of 10 on that page.
Basically I need a better way of sorting this out - I thought of SELECTing
all the records into an array first and then working from that, but I can't
get array to be dynamic enough in VBscript
A portion of the asp for our site looks like this: Code:
insert = "INSERT INTO Students VALUES ( '" & _
(????)
CStr ( Request ("UserName") ) & "','" & _
CStr ( Request ("Password") ) & "','" & _
CStr ( Request ("Email") ) & "','" & _
CStr ( Request ("Country") ) & "','" & _
CStr ( Request ("DOB") ) & "','" & _
Date() & "@" & Time() & "','" & _
Date() & "' )"
It just inserts a new record into the db. What we did was add an autonumber field to the db, but now it won't update.
We know why - because it needs a value for every category in the db - but we don't know how to code it so it will update the db correctly. So, if anyone could help me with the (????) line in the coding so it will correctly update, that would be perfect!
How can i get the autonumber(primary key value) from the specific rows when i just insert it.Example
i just insert the member information.
sql="INSERT IMTO register(user,password,address) VALUES (shujuan,841218,singapore)"
so how can i get the primarykey for this row after i just create it.
var SQLString = "INSERT INTO table VALUES( '' ,'" + Request.Form("name") + "','"
+ strAlpha + "','', '"
+ Request.Form("email") + "', '"
+ Request.Form("userid") + "')";
dbConnection.Execute(SQLString);
This is jscript inserting into access2000. My table looks like this:
id (autonumber)
name
date
email
userid
Its the first field that causing my problems, I get a data type mismatch error. How do I insert with an auto incremented field?
What is the best way of using an AutoNumber system on an SQL server?I've been used to using Microsoft DBs for my online apps and have now upgraded to using Microsoft SQL server.
I want to be able to insert a new record into the database not such a problem but I want each record to have a unique identity no eg. NewsID. I know that you can do a lookup of the MAX number on insertion but if two people are inserting at the same time this may cause problems with duplication.
I have a form that is filled out and put into an Access database. The id field is Autonumber.
What I would like to do is also insert this data (or some of it) either into another database or another table, but I would like the created AutoNumber to be a part of this data. Is there any way to get this number immediatly after insertion?
I'm trying to write the code for an autonumber to go in to a text field when the page is open. I had it working in access but of course it won't work in asp. The format has to be for example: PBC-1200.
View Replies View RelatedI have an Access database that uses an autonumber for the primary key. I hv app. 110 items in the table, and yet when I add a new item, it autonumbers as 534097 or some ridiculously long number.
How can I get it to go back to a smaller number without removing/trashing existing ID fields?
OK, I realize this is a subject that almost every developer would encounter, so I understand the answer is probably out there somewhere. Suffice it to say that I have been looking, both in this forum and on google, found many SQL server answers, and one for Access, which I have tried with no success. See the following: Code:
sql = "INSERT into someTable(IntColumn) values (" & fakeValue & ") SELECT @@IDENTITY"
set rs = conn.execute(sql)
response.write "New ID was " & rs(0)
This results in a JET database error, Missing semicolon at end of SQL statement. I tried adding it after the close paren, after the select @@identity, and after both, with the same error.
Is there any way to format the autonumber or change it in Microsoft Access?
View Replies View RelatedI am using Ms Access database and I have set 3 digits (e.g. 000) for an autonumber field of my table.Its working fine in Access and incrementing automatically like this (001, 002, 003 ...), but when I call the data on a web page using ASP its displaying these numbers like this (1, 2, 3, 4 ...) I dont understand why is it not displaying the numbers as it is in the table.
View Replies View RelatedWhy won't this code work - the "id" fields are autonumbers
Code:
<select size="1" name="Agent" tabindex="">
<option value="Select">Select Owner</option>
<%
x = rs("id")
Do While NOT rs2.eof
y = rs2("id")
Response.Write "<option value='" & rs2("id") & "'"
If x = y Then Response.Write " Selected" End If
Response.Write " >" & rs2("first") & " " & rs2("last") & "</option>" & vbCrlf
rs2.MoveNext
Loop
%>
</select>
Why do I keep getting a type mismatch on this
Set cnn1 = Server.CreateObject("ADODB.Connection")
openStr = "driver={Microsoft Access Driver (*.mdb)};" & _
"dbq=" & Server.MapPath("fpdb/images.mdb")
cnn1.Open openStr,"",""
sql = "SELECT * FROM gallery"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sql, cnn1, adOpenDynamic, adLockPessimistic, adCmdText
temp = cINT(request("pic"))
rs.Find "id = " & temp
I've tried multiple variations.
I have 3 tables and they are linked with each other.
table 1 (ID, Title)
table 2 (QuestionID, ID, Question)
table 3 (AnswerID, QuestionID, Answer)
the problem is that ..
I insert the question in the correct place which is related to the table 1 but when it come to insert the answer for that specific question id didn't work .. it always take the first question in the table Code:
I want to take the last record in my database and display it on my ASP program. From my understanding, when last record + 1, it will be autonumber right. It's like generaing the autonumber for invoice number.
For easier view, my last record is 21. So I want that 21 appear in my ASP system as 22.
Is anyone can give me the idea how to make it?
I have a line of code in my script that looks like this:
Set User = objDBCon.Execute("SELECT * FROM tblsUsers WHERE ID = '" & request.form("user") & "'")
This gives me an error of data type not the same. Anyone know what the problem might be?
here is some background on the page I made. It's a calendar page with events listed. No database, just used id="" to display certain months depending on the option chosen from the jump down menu.
The question I have is this: I would like to display the current month's events when they land on the page. I used
<%
id=request.querystring("id")
%>
and created an <%elseif id="1" then%> and so on for each month. Is there a way can request the month and display that id? Thanks for you help. I have the code for the page if need be
Is there a way to determine the actual width and height of a image file ?
I'm using aspsmartupload to upload the image, how can determine and save the
width and height value ?
seems that aspsmartupload doesn't have this property.
If so, is there any method to determine it in asp in the simpliest way? I
will prefer to maintain the aspsmartupload method.
I have many servers which will be reghosted everyday with different OS
(Win2000, Win2003, WinXP...). How could I write the ASP code to get the
information of other servers' OS?
Let say the asp page is hosted on Server A, how can I check the OS version
of Server B and Server C?
How do you determine if a given date is a weekday (Mon-Thurs) or weekend (Fri - Sun)? Is there a built in function?
View Replies View RelatedSomewhere in my program I ask users to provide their website URL. I would like to determine if the given website exists or not.How can I determine a website with given URL exists?
View Replies View RelatedI am creating an ASP page for members of my team to add and delete records from specified tables. This table is choose by the user and I am dynamically creating text boxes. I also wish to include the type of the attribute to assist the user.
<%
for s_intCounter=0 to objRs.Fields.Count -1
%><tr>
<td width="34%"><% objRs.Fields.Item(s_intCounter) %>: <input type="text" id = <% objRs.Fields.Item(s_intCounter) %> > </td>
<td width="66%">Type: <% INSERT ASP FOR RETRIVING TYPE</td>
</tr>
<%next%>
I want to use asp to assign a css class to <td> tag. I was thinking an If statement, but i've not come across trying to assign a class to a table cell before! I want the cell background to be highlighted red determined by a database table with - yes or null. (null remains white, yes - red) At the moment it simple like this: Code:
<td><%=strAddress%> </td>
My web hosting account lets me use ASP and so I thought I'd try to learn and use some.
There is only one thing that I would like to know, and that is how to find out what version of ASP is running. Preferably, what I am looking for is something similar to the PHP php_info() function. Is there anything like this for ASP?
I have an ASP/ADO application querying an SQL Server DB. I want know the most efficient way to determine if more than one row is returned from a query. If more than one row is returned, the user will be presented with a choice of which row to process. If only one row is returned, I want to skip this stage, and process that single row immediately.
I can think of a number of ways of acheiving this (eg. .recordcount) but I'm looking for the slickest and most efficient method.
This may be a trivial question, but I was wondering how can you determine if a value contains an Integer or Float. I know there is a function called IsNumeric, however you can't determine what type it is.
View Replies View Related