Hello Barney,
"Barney" <anonymousdiscussions.microsoft.com> schrieb im Newsbeitrag
news:ECCDAF82-099F-4DBE-82A2-FB4F38E9F6DEmicrosoft.com...
> Folks,
> This will be a very simple for you.
>
> I need to increment the database item by one. So, if the item number is
5, I need to add just 1 to it.
>
> What I want help from you is that there is a way of reading from the sql
server with this statement:
>
> Dim strSQL As String
>
> strSQL = "SELECT MAX(Item) FROM OrderDetails WHERE PONumber =
" & Request.QueryString("ID").Trim
>
>
> Then incrementing the selected attribute. In this particular case, what I
want from you is to increment the selected Item by 1.

try
strSQL = "SELECT MAX(Item)+1 FROM OrderDetails WHERE PONumber = " &
Request.QueryString("ID").Trim
^^^

a tip;
use params, becaus of sql-injection
[url]http://www.developer.com/db/article.php/2243461[/url]

mfg simon g.