I have an asp.net page on the web that loads in several web controls (ascx pages) within based on page id, product id, etc.... for some unknown reason it sometimes refreshes by itself multiple times (between 2 and 10+).. it's not due to postback events or any Response.Redirect(self) type code...
I have an asp.net page on the web that loads in several web controls (ascx pages) within based on page id, product id, etc.... for some unknown reason it sometimes refreshes by itself multiple times (between 2 and 10+).. it's not due to postback events or any Response.Redirect(self) type code...
I noticed that you had the * wildcard incorrectly placed and there was no space before the "as" and no comma after [Previous Amount] according to your post.
the bottom should work:
"SELECT [Previous Amount] as Previous_Amount, " & My_CPI_session & " as My_CPI FROM [pensions]"
I noticed that you had the * wildcard incorrectly placed and there was no space before the "as" and no comma after [Previous Amount] according to your post.
the bottom should work:
"SELECT [Previous Amount] as Previous_Amount, " & My_CPI_session & " as My_CPI FROM [pensions]"