FrontPage98 Tips 

17. Customize the "No Records Returned" message 

For instance, if you use the INSERT INTO Structured Query Language (SQL) statement in a database region on an ASP page, visitors to your site might sometimes get the message No Records Returned when they load that page in their browsers. 

To prevent your visitors from receiving this cryptic response, you can customize the message to say something more meaningful, such as, "I'm sorry, but that information is not available" or "Please try again." 

All you need to do is open your ASP page in a text editor and change this line: 

s-NoRecordsFound = "No Records Returned"  

Just substitute "No Records Returned" with your own message. 

You can also format the message using standard HTML code. Here are some examples: 
 
 

Type of formatting	Corresponding code
Heading 1	s-NoRecordsFound = "<H1>My message</H1>"
Center	s-NoRecordsFound = "<CENTER>My message</CENTER>"
Hyperlink	s-NoRecordsFound = "<A href="link.htm">My     message</A>"
Hyperlink and center	s-NoRecordsFound = "<CENTER> <A href="link.htm">My message</A></CENTER>"

Related tips: 
Turn delimited data into a table 
Format database bots 
Deal with form field defaults 

Introduction |  Previous |  Next