CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> ASP

 Add a record, then next page automatically brings up same record

Print topic Send  topic

Author Message
Chris__T


Posts: 339
Posted: 04/19/2010, 2:05 PM

Hi all.

When I'm adding a record, I'd like to press the button to insert it, then it opens to another page and have this record displayed.

View profile  Send private message
Waspman

Posts: 948
Posted: 04/20/2010, 3:24 AM

Create a unique ID for the record save to the DB etc., but also save the ID to a session then set the return to your new page and show record where it equals session previously set.
_________________
http://www.waspmedia.co.uk
View profile  Send private message
Jan van Dalen
Posted: 04/20/2010, 6:46 AM

Hello Chris__T,

As Waspman said .... this is the code I execute on "After Insert" event (for
a MSSQL db)

Session("svLastID") = CStr(CCDLookUp("@@Identity","","",DBMain))

Now, obviously this is not 100% "Kosher" but it will work 99.9999999% of
the time :)

> Hi all.
>
> When I'm adding a record, I'd like to press the button to insert it,
> then it opens to another page and have this record displayed.
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/

Chris__T


Posts: 339
Posted: 04/22/2010, 9:52 AM

I'll try that out..thanks, Waspman and Jan!
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.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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