Forums
This topic is locked
Need to display even though no info in database
Posted 03 Sep 2003 22:54:48
1
has voted
03 Sep 2003 22:54:48 Greg LeBreck posted:
In ASP with a SQL database.I am making an update form for credit card numbers. If I enter the customer number it pulls back all the info. I display the credit Card Number in a text box so it can be updated. Problem is if there is no credit card info for it to display the page errors out. How do I get the page to work when there is nothing to retrieve from a database field?
Replies
Replied 04 Sep 2003 08:01:33
04 Sep 2003 08:01:33 Dave Clarke replied:
Hi, there is built in behaviour for this.
Go to SERVER BEHAVIOURS > SHOW REGION > SHOW REGION IF RECORDSET IS NOT EMPTY
Dave
ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome
Edited by - Davecl on 04 Sep 2003 08:02:00
Go to SERVER BEHAVIOURS > SHOW REGION > SHOW REGION IF RECORDSET IS NOT EMPTY
Dave
ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome
Edited by - Davecl on 04 Sep 2003 08:02:00
Replied 04 Sep 2003 16:12:01
04 Sep 2003 16:12:01 Greg LeBreck replied:
Ok that works good. Now what if there is nothing in those fields and I want it redirect to a different page if no info is found?