Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to tell insert has posted

Status
Not open for further replies.
mdr227

mdr227

Programmer
Joined
Nov 17, 2000
Messages
114
Location
US
What is the best way to tell if an insert statement has succeeded in ASP? I want to print a confirmation message after users submits an online form, but only if the record successfully posts to the database. Thanks
 
Sort by date Sort by votes
Unless you get an ASP or a SQL error back, it should have posted fine, but you can always build a quick SQL statement to pull that record back out again. If it returns a blank recordset, then it is not in the database. Harold Blackorby
hblackorby@scoreinteractive.com
St. Louis, MO
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question Question
How to send HTML emails with ASP classic?
Replies
0
Views
1K
leifoet
leifoet
leifoet
  • Locked
  • Question Question
How to check if a datatable is empty ?
Replies
0
Views
793
leifoet
leifoet
penguinspeaks
  • Locked
  • Question Question
Return to current location on page after asp processes.
Replies
2
Views
1K
penguinspeaks
penguinspeaks
bslintx2021
  • Locked
  • Question Question
How to configure IIS 10 server to allow Classic ASP to connect to MSSQL server database on a domain
Replies
1
Views
1K
penguinspeaks
penguinspeaks
Swi
  • Locked
  • Question Question
JQUERY AJAX POST and how to receive data via Classic ASP
Replies
0
Views
1K
Swi
Swi

Part and Inventory Search

Sponsor

Back
Top