This website requires Javascript to function properly. Please go to the setting of your web browser and enable Javascript for this website.

Ad by

最优利率和cashback可以申请特批，好信用好收入offer更好。请点链接扫码加微信咨询，Scotiabank -- Nick Zhang 6478812600。

Ad by

最优利率和cashback可以申请特批，好信用好收入offer更好。请点链接扫码加微信咨询，Scotiabank -- Nick Zhang 6478812600。

我的小字报：

luoboyang(萝卜秧)

1。you can not get the identity number before you finish the 'Update' or 'Insert'.
in your code, you was using like this way:
rs(1)="123"
rs(2)="abc"
rs(3)="picture_" & rs(0) (but the rs(3) get nothing, why i can not get rs(0) value )
Of cause you can NOT get rs(0), it has not been inserted yet!

2. in this case, you should use another column(field) to store your rs(0) (i.e, uni_num) as soon as it is intered, (you can put this in a trigger), then do a 'Update' to get the value of uni_num, combine it with your rs(3) and save it into DB.

so your code should like this:
rs(0) (auto number)
...
rs(3) = ' ' (it's blank in this Insert)
rs(4) (new field, same as rs(0))
.update

then get this record again.
rs(1)="123"
rs(2)="abc"
rs(3)="picture_" & rs(4)
.update

3. of cause you can put all of them into a Insert trigger, so when you do the insert, you can generate the rs(3) immdieatly.

(#412738@0)
Last Updated: 2002-3-21
This post has been archived. It cannot be replied.

Report

Replies, comments and Discussions:

工作学习 / IT杂谈 / ASP question please help!! thanks!! -fengvan(Sunny); 2002-3-20 {517} (#411681@0)
How should i do to get the rs(0) value?

..................
sql="select * from studentinfor"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open sql,connstr,3,2
rs.addnew ( rs(0) is an auto number from 1, step is 1 )

rs(1)="123"
rs(2)="abc"
rs(3)="picture_" & rs(0) (but the rs(3) get nothing, why i can not get rs(0) value )
(rs(3) photo file)

rs.update

rs.close
set rs = nothing
.....................

How should i do to get the rs(0) value?

你update之后,再retrieve rs(0)的值为多少? -mcdonald(麦当劳); 2002-3-20 (#411710@0)

this is the program look like after i change. but It still does not work. -fengvan(Sunny); 2002-3-20 {404} (#411726@0)
this is the look after i change.
It still does not work.
please show me how! thank you!!

sql="select * from studentinfor"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open sql,connstr,3,2
rs.addnew

rs(1)="123"
rs(2)="abc"

rs.update

rs(3)="picture_" & rs(0) (but the rs(3) get nothing, why i can not get rs(0) value )
rs.update

rs.close
set rs = nothing

不好意思,我没用过ASP.帮你up一下.看你的code,update之后,你在用一次selec to get the value of rs(0), i think you may not be able to get the rs(0) value before you write it back to database. -mcdonald(麦当劳); 2002-3-20 (#411746@0)

你这样试试看 -kevin_tor(晚睡晚起的懒猫); 2002-3-20 {381} (#411801@0)
sql="select * from studentinfor"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open sql,connstr,3,2
rs.movelast
id=rs(0)+1
rs.addnew ( rs(0) is an auto number from 1, step is 1 )

rs(1)="123"
rs(2)="abc"
rs(3)="picture_" &id (but the rs(3) get nothing, why i can not get rs(0) value )
(rs(3) photo file)

rs.update

rs.close
set rs = nothing

one person use ok, but if many people add new date at same time. it may have problem -fengvan(Sunny); 2002-3-20 (#411866@0)

try this -nice2002(nice2002); 2002-3-20 {287} (#411818@0)
sql="select * from studentinfor"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open sql,connstr,2,3 (this line has been modified)
rs.addnew
rs(1)="123"
rs(2)="abc"
rs.update
rs(3)="picture_" & rs(0)
rs.update

rs.close
set rs = nothing
'not tested...

should add rs.movelast between rs.update and rd(3)="picture"&rs(0) -nice2002(nice2002); 2002-3-20 (#411837@0)
not work !! -fengvan(Sunny); 2002-3-20 (#411873@0)

well tested...working fine -nice2002(nice2002); 2002-3-21 {330} (#413151@0)
sql="select * from studentinfor order by (your auto id field name)"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open sql,connstr,2,3 (this line has been modified)
rs.addnew
rs(1)="123"
rs(2)="abc"
rs.update
rs.movelast
temp=rs(0)
rs(3)="picture_" & temp
rs.update

rs.close
set rs = nothing

你这个是不保险的。你用lock了没有？什么模式的recordset?如果在你update和movelast之间有另外一个人也作了insert，那么你得到的是谁的new ID? That's why I said we should use trigger. -luoboyang(萝卜秧); 2002-3-21 (#413167@0)

I agree ! -fengvan(Sunny); 2002-3-21 (#413192@0)
ok,you are right,change to rs.open sql,connstr,2,2---------2 means recoed locked before and after you edit utill you destroy the recordset -nice2002(nice2002); 2002-3-21 (#413239@0)

by the way,what is the version of ASP?if you have 3.0(win2000),i will give you better code -nice2002(nice2002); 2002-3-21 (#413245@0)

ASP 3。0 -fengvan(Sunny); 2002-3-21 (#413255@0)

here you go.... -nice2002(nice2002); 2002-3-21 {366} (#413405@0)
sql="select * from studentinfor"
Set rs = Server.CreateObject("ADODB.Recordset")
with rs
.open sql,connstr,2,2
.addnew
.fields(1)="123"
.fields(2)="abc"
.update
temp=.fields(0)
.fields(3)="picture_" & temp
.update
END with
..............

not tested,you may test again

这样试试 -kevin_tor(晚睡晚起的懒猫); 2002-3-20 {480} (#411825@0)
AutoID时数据存到数据库的时候自动产生的,你这样是取不到值的
你这样试
.................
sql="select * from studentinfor"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open sql,connstr,3,2

rs.movelastrecord(这句话你自己去看help,我记得不是太清楚)
ID=int(trim(rs(0)))+1

rs.addnew

rs(1)="123"
rs(2)="abc"
rs(3)="picture_" & cstr(id)

rs.update

rs.close
set rs = nothing
.....................

How should i do to get the rs(0) value?
你是想要获得 identity field 的自增值, 然后用在下一条record? 如果条件容许, you can use "store procedure", plus "command" object 使用 global variable "@@identity " -fxue(fxue); 2002-3-21 (#412653@0)

我是想要获得 identity field 的自增值, 然后用在本条record -fengvan(Sunny); 2002-3-21 (#412751@0)

看我下面的贴子，这样的话，你就要用trigger了。 -luoboyang(萝卜秧); 2002-3-21 (#412753@0)

我的小字报： -luoboyang(萝卜秧); 2002-3-21 {940} (#412738@0)
1。you can not get the identity number before you finish the 'Update' or 'Insert'.
in your code, you was using like this way:
rs(1)="123"
rs(2)="abc"
rs(3)="picture_" & rs(0) (but the rs(3) get nothing, why i can not get rs(0) value )
Of cause you can NOT get rs(0), it has not been inserted yet!

2. in this case, you should use another column(field) to store your rs(0) (i.e, uni_num) as soon as it is intered, (you can put this in a trigger), then do a 'Update' to get the value of uni_num, combine it with your rs(3) and save it into DB.

so your code should like this:
rs(0) (auto number)
...
rs(3) = ' ' (it's blank in this Insert)
rs(4) (new field, same as rs(0))
.update

then get this record again.
rs(1)="123"
rs(2)="abc"
rs(3)="picture_" & rs(4)
.update

3. of cause you can put all of them into a Insert trigger, so when you do the insert, you can generate the rs(3) immdieatly.

谢谢！！！ -fengvan(Sunny); 2002-3-21 (#412757@0)

Depend on different database -jchonc(James); 2002-3-22 {182} (#414749@0)
If Access or Ms SQL
right after insert query, run SELECT @@identity to get the autoinc field's value.

If Oracle or Interbase, directly get the value from
sequence or generator

@Philadelphia

我的小字报：

Replies, comments and Discussions:

More Topics