增加包含混合字符和数值的列的值 [英] Incrementing the value of a column containg mixed character and numerical values
问题描述
亲爱的专家
我们如何自动递增包含07-05-ivan-A-0001等值的列值。最后整数部分必须增加。
提前谢谢
Dear experts
how we can automaticaly increment the column value which contains values like 07-05-ivan-A-0001. the final integer part alone have to be incremented.
Thanks in advance
推荐答案
尊敬的专家
我们如何自动递增包含07-05-ivan-A-0001等值的列值。最后整数部分必须增加。
提前付款
Dear experts
how we can automaticaly increment the column value which contains values like 07-05-ivan-A-0001. the final integer part alone have to be incremented.
Thanks in advance
你好jsredhar，
一个简单的问题......这个列值是如何产生的？是输入07-05-ivan-A-0001，还是0001自动编号，07-05-ivan-A进入单独的字段？根据你的结构和你想要存放在桌子里的东西，我会有不同的想法。
一切顺利
theAybaras
Hi jsredhar,
A quick question... how is this column value generated? is it entered as 07-05-ivan-A-0001, or is 0001 the autonumber, and 07-05-ivan-A entered into separate fields? Depending on your structure and what you''re wanting to store in the table, I''ll have different things to say.
All the best
theAybaras
您好jsredhar，
一个简单的问题......这个列值是如何产生的？是输入07-05-ivan-A-0001，还是0001自动编号，07-05-ivan-A进入单独的字段？根据你的结构和你想要存放在桌子里的东西，我会有不同的想法。
一切顺利
theAybaras
Hi jsredhar,
A quick question... how is this column value generated? is it entered as 07-05-ivan-A-0001, or is 0001 the autonumber, and 07-05-ivan-A entered into separate fields? Depending on your structure and what you''re wanting to store in the table, I''ll have different things to say.
All the best
theAybaras
亲爱的theAybaras
第一部分（07）是从年份（日期）生成的第二部分（05）是使用月份（日期）生成的，第三部分是可以从ASP的会话变量中检索的用户名并且第四部分A将由用户输入，并且最后部分（0001）是为第一个条目预定义的。以下是语法
<％= strYear％>&" - "&<％= strMonth％>&" - "&会话（用户名）&" - "& textboxvalue（A）&" - "& 0001
这就是我生成它的方式第一个条目所以这将在我的项目表的Projectcode字段中存储为07-05-ivan-A-0001单独的整数部分没有单独的字段。
谢谢
Dear theAybaras
the first portion (07) is generated from year(date) second part (05) is generated from using month(date) and the third part is the username which can be retrieved from session variable of ASP and the fourth part ''A ''is to be entered by the user and the final part(0001) is predefined for the very first entry. following are the syntax
<%=strYear%>&"-"&<%=strMonth%>&"-"&Session("username")&"-"&textboxvalue(A)&"-"&0001
This is how i have generated it for the very first entry so this will store as 07-05-ivan-A-0001 in Projectcode field of my Project table There is no separate field for integer part alone.
Thanks
亲爱的theAybaras
第一部分（07）是从年份（日期）第二部分生成的（05）是使用月份（日期）生成的，第三部分是可以从ASP的会话变量中检索的用户名，第四部分A将由用户输入，最后一部分（0001）是为第一个条目预定义的。以下是语法
<％= strYear％>&" - "&<％= strMonth％>&" - "&会话（用户名）&" - "& textboxvalue（A）&" - "& 0001
这就是我生成它的方式第一个条目所以这将在我的Project表的Projectcode字段中存储为07-05-ivan-A-0001单独的整数部分没有单独的字段。
谢谢
Dear theAybaras
the first portion (07) is generated from year(date) second part (05) is generated from using month(date) and the third part is the username which can be retrieved from session variable of ASP and the fourth part ''A ''is to be entered by the user and the final part(0001) is predefined for the very first entry. following are the syntax
<%=strYear%>&"-"&<%=strMonth%>&"-"&Session("username")&"-"&textboxvalue(A)&"-"&0001
This is how i have generated it for the very first entry so this will store as 07-05-ivan-A-0001 in Projectcode field of my Project table There is no separate field for integer part alone.
Thanks
好的，我会玩一些东西然后回复你！我们会看到是否有人比我更专业的帖子:)
theAybaras
okay, I''ll play with some things and get back to you! We''ll see if anyone who is much more expert than me posts too :)
theAybaras
这篇关于增加包含混合字符和数值的列的值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
