Stack Overflow
Stack Overflow

Questions tagged [autonumber]

158 questions
1
vote
0 answers

Auto-number pictures

I have an entertainment blog with a lot of pictures. Can someone please help me with a code that auto-numbers the pictures inside a post? (eg: www.chive.com, www.acidcow.com) This is my CSS for pictures if it helps for anything... .post-body img,…
user1839625
  • 11
  • 1
1
vote
5 answers

Auto generated ID from DB in ASP.NET

I have a primary key for my table employee. I named it "IDS". The IDS data is like : K-00001, K-00002, etc. what I want to ask is, how to made this IDS auto generate in ASP.NET, not using trigger or function in SQL? I have done my code like this: …
Cross Vander
  • 2,077
  • 2
  • 19
  • 33
1
vote
4 answers

How to use count in php?

I want to insert data to database. I have a table, named member that has 7 column (ID, User, Password, Address, Phone, Gender, Email). I used count to make auto number like this $no = "SELECT COUNT(ID)FROM member"; $nors = mysql_query($no); $nors =…
greenthunder
  • 697
  • 8
  • 19
  • 34
0
votes
1 answer

Simple SQL query with Autonumbers

I don't understand whats wrong. I have a primary key in my Microsoft Access database known as SessionID. It is an autonumber has the format "3"00000. So say I have a SessionID such as 300001. If I have a query such as; SELECT Booking.SessionID FROM…
Pejman Poh
  • 493
  • 2
  • 8
  • 20
0
votes
3 answers

C# Form / Access Database insert row with "autonumber" field

The two following samples of C# code, writing info to an Access database, as far as I can tell, SHOULD produce the same output. However the first one works, and the second gives an error. The first code: Without an AutoNumber primary key field,…
Geo
  • 339
  • 3
  • 7
  • 21
0
votes
3 answers

How to do batch insert with an autonumber in JDBC?

Previously i had some experience with MS Access and now i am doing JDBC, in Java of course. In MS Access Databases i can have a AutoNumber field, which is very convenient for generating primary keys. I would like to do the same in Java. However,…
n0obiscuitz
  • 573
  • 2
  • 10
  • 22
0
votes
3 answers

New column can not be added to Access database

I have an Access database table with approximately 4 million rows. What i want to do this to add a column(field) with the type of autonumber using MS Access Design View. But when i tried to this, access gives an error and says: "The query can not be…
LuckySlevin
  • 695
  • 3
  • 16
  • 23
0
votes
1 answer

How can VBA for Word be used to set an autonumber list to the right of text?

I'm working on a userform that completes a correspondence template. I have two fields: References and Enclosures that need to show up on the completed template like this (underscores are spaces): Ref:____(a) Reference 1 _______ (b) Reference…
Michael Miller
  • 7
  • 4
0
votes
1 answer

EXCEL: Auto number rows until value in cell

This is probably very easy, but I can't seem to get it to work. I'd like a formula for autonumbering rows based on the value in B1. Starting from B1 id like to autonumber rows from 1 and down until the value defined in B1. This need to be a formula,…
MathiasF78
  • 11
  • 2
0
votes
0 answers

Sharepoint List - Generate Unique # identifier in Column A based on Column B. Same # if duplicate

I am working on creating a tracker, my client has requested the data be on sharepoint list for ease of viewing. In order to organize the tracker on the Sharepoint List, I would like to generate an autonumber (calculated column) in one column, I've…
WJZ15
  • 3
  • 2
0
votes
1 answer

Oracle TO_NUMBER problem with passing format

I have the following situation. I am trying to use TO_NUMBER as follows: SELECT TO_NUMBER('$123,456.789','$999,999G999D999') FROM DUAL; I get ` ORA-01481: invalid number format model 01481. 00000 - "invalid number format model" *Cause: The user…
Бам Бам
  • 11
  • 1
0
votes
1 answer

Dataverse Autonumber formatting - restart SEQNUM

I have a Dataverse table with a column using the Autonumber data type. The format should be the current date in MMddyy format followed by a 3 digit number that starts over at the beginning of each day. This is what I have…
Robby
  • 843
  • 3
  • 19
  • 53
0
votes
1 answer

Autonumber and datatable with dbnull exception

i was doing some work on a datatable i filled with a oledbdataadapter made from an access database. and i stumbled upon this error: Turns out that my table has this structure: ID --> autonumber(PK) lazos_>text Asociaciones->text and when i fill my…
Joaquin
  • 5
  • 2
  • 5
0
votes
2 answers

How to insert values into an Access table's AutoNumber field?

I'm working on a project using jsp and Microsoft Access. There are three tables in which a same field is used as Receipt_No. This can get from Recp table, which has a only one field: Receipt_No (AutoNumber, Primary Key). Now my question is, how…
samiksha
  • 73
  • 1
  • 3
  • 7
0
votes
1 answer

Oracle sql generate consecutive numbers per row

I have a table with a seqno column. I would like to create another column (grpseqno) based on this which is numbered from 1 to 3 only as shown below. It would be neat if this is created by Oracle sql. Thank you in advance. seqno grpseqno 1 …
ddb20
  • 69
  • 1
  • 10
1 2 3
…
10 11