Ask a Question related to ASP Database, Design and Development.
-
PJ #1
get id number from sql table
I have a asp page that updates a sql table. after the table receives
the update a id number is auto generated. How do I pass that number
to the second page. I was trying to use @@identity but I'm not sure
how to use it or ever were. Do I call the @@identity on the second
page? Please help
PJ Guest
-
sql performance with a large number of rows in a table.
hi, I am currently using MySQL 5.0.16 on a dual pentium 4-2G system with 9G of ram. I have a number of machines that connect to the MySQL server,... -
How to display limited number of rows of table indatabase
I have built some CF pages to display my huge collection of DVDs and I would like to have a limited number of rows displayed at a time. Then there... -
Could not load type VTFixup Table from assembly Invalid token in v-table fix-up table.
We are getting this error after clearing the web.config of database infomation - even after using the wizard to re-enter the information. I could... -
Max number table in the union statement
According to BOL the maximum number of tables per SELECT statement is 256. I don't think there's any other limit specific to UNION statements. --... -
Selecting Certain Number of Characters from Table -- Simple SQL Question
How can I select a certain number of characters from a string, without selecting the whole string? For example, I want the first 50 characters of... -
Foo Man Chew #2 Re: get id number from sql table
You mean insert, not update, right?
[url]http://www.aspfaq.com/show.asp?id=2174[/url]
"PJ" <shows@hillstax.org> wrote in message
news:d9b04e79.0312291255.199d83d5@posting.google.c om...> I have a asp page that updates a sql table. after the table receives
> the update a id number is auto generated. How do I pass that number
> to the second page. I was trying to use @@identity but I'm not sure
> how to use it or ever were. Do I call the @@identity on the second
> page? Please help
Foo Man Chew Guest
-
Ray at #3 Re: get id number from sql table
Hello PJ,
Take a look at this page:
[url]http://www.aspfaq.com/show.asp?id=2174[/url]
Ray at work
"PJ" <shows@hillstax.org> wrote in message
news:d9b04e79.0312291255.199d83d5@posting.google.c om...> I have a asp page that updates a sql table. after the table receives
> the update a id number is auto generated. How do I pass that number
> to the second page. I was trying to use @@identity but I'm not sure
> how to use it or ever were. Do I call the @@identity on the second
> page? Please help
Ray at Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
