Wrox Programmer Forums
|
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 6th, 2003, 04:06 PM
Registered User
 
Join Date: Jul 2003
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Kelly Johnson
Default entering data

Hello all,

I have an ASP page that has a form that allows the end user to enter a computer issue they are experiencing. the information is being stored in an access database with an automatic ticket number being assigned by Access,when the data is entered.

After the user clicks the submit button I have them being redirected to another page that acknowledges that a work ticket has been submitted.

What I need help with however is displaying the newly created ticket number for the user on the acknowledgement page so that they can refer back to it.

Can someone help me with this?

 
Old August 7th, 2003, 07:36 AM
Authorized User
 
Join Date: Aug 2003
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Default

If you are assigning the ticket number as autonumber in access? and you want the most recent autoid, you can use this sql statement

SQL = "SELECT @@IDENTITY AS Newticket"

hope this helps.







Similar Threads
Thread Thread Starter Forum Replies Last Post
Entering data into an SQL database jmsherry SQL Server 2000 3 July 24th, 2007 01:00 AM
VBA code for entering the same data for dates rohit_ghosh Access VBA 1 May 3rd, 2007 09:45 AM
entering data into crystal reports from access DB JerBlur Pro VB.NET 2002/2003 0 July 26th, 2004 10:53 PM
Entering data to dynamic table cells weebadbilly XSLT 0 June 30th, 2004 07:15 AM
Protect input-field from entering data rvw Javascript How-To 4 October 22nd, 2003 05:40 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.