Say I had a query which listed the below, from the database:
Fiesta
Citron
Metro
Skoda
Mondeo
How could I write something so that however many results are returned it automatically numbers them like this:
1 Fiesta
2 Citron
3 Metro
4 Skoda
5 Mondeo
So that no matter how many results came out it would just keep on numbering...?
i need some one to help me how to do numbering with asp. for example if i want to display 10 titles in a page and the others shown on the next pages.i.e 1.2.3.4.5 etc.
thanks for quick response.
When you pull out some certain data from the DB, this is generally how it looks like in a table...
jill 123
jeff 444
alex 611
steve 244
But my question is that, how do you LIST the data beside them? its nothing to do with the table ID, its just when you pull the data out of the DB, you could use the ASP function ( I do believe there has to be one?) to number the data? This is how I mean...
1. jill 123
2. jeff 444
3. alex 611
4. steve 244
i am auto numbering with sql in asp. my auto code worked but i am restructing my tables and i came across my auto numbered fields. my question is when you use auto number does it give an default field length in mssql and if it dose how do you specifi how long you want the field to be.
here is a sinpit of my code for a table using auto numbering.
sqlStr = "CREATE TABLE Consumer(Con_id INT IDENTITY (1,1) NOT NULL PRIMARY KEY, "&_
"Con_Fname VarChar(25), "&_
I am trying to add in another column on the left of this table to retun a sequential counts as to how many records I have returned. Such as
1 Mike
2 Steve
3 Susan
4 Sarah
5 Emily
But I can't figure out how to do it. Code:
I have two little programs, one which writes the name of a file into a log file when it is accessed by a visitor and the other to read the log file at any stage in its building. At either step, it would be useful to increment each line and see the number.
It would probably be easiest when reading the log file. I'm using: Set Txt = Sys.OpenTextFile( myCounterFile, 1 ) and then:
mytext=replace(Txt.ReadAll,vbcrlf,"<br>"). I'm guessing an incremented number goes in between but haven't been able to figure out the syntax or the modification. Also not sure if that "vbcrlf,"<br>" isn't redundant.
i want to make a data field with an auto numbering , but i exactly want is like this CT-1 , CT-2,CT-3 , the Ct letters must be before the autonumber , so its seems to me in that case i cant choose the dat field in my db as int and choose identity Yes cause the identity seed will be an integer only and no way to put with it a number.
so i want to make throw asp and put this datfield as a char so it can accept the(letter-number)value , so how can the asp make an autonumbering, and know what the lastnumber so it can add 1 to it.