CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> ASP

 Retrieving record ID

Print topic Send  topic

Author Message
grivers

Posts: 28
Posted: 08/26/2009, 3:41 AM

Hi,

I am trying to insert a new record in a form and then immediatley update the same record on the next page. To do this I assume I need to insert some code to retrieve the record ID after an insert and then somehow pass it to the new update form on the next page.

Do you know how I can retrive the ID of the record when entering a new record on a form?
Then retrive it so straight away to edit the form?
View profile  Send private message
Oper


Posts: 1190
Posted: 08/26/2009, 3:21 PM

grivers,
every database have his way to get teh last id etc LAST_ID() lastRecordPointer(), etc

that easy way an work for all database without any posible fail in multi enviroment

during the insert, insert also a field named like UNIQUECODE

and assign a know value like DATE-USERID-Random(10) ej: "20090826141859-1-019982

and just get that record with that code back.

we have used that approach always.


_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)

http://www.PremiumWebTemplate.com
Affiliation Web Site Templates

Please do backup first
View profile  Send private message
grivers

Posts: 28
Posted: 08/27/2009, 1:12 AM

Thanks.
View profile  Send private message
TamaraLG

Posts: 8
Posted: 10/13/2009, 11:00 AM

Could you explain how and where you would enter the unique code? How would you recall the code on the next page if it is unique?
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.