• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Week: 3 At a Glance > Answers for Day 16, “Advanced Techniques: Data Collection...

Answers for Day 16, “Advanced Techniques: Data Collection and Reporting”

1: What is the parentID field for?
A1: The parentID field contains the ID number of a message that is the parent of another message. If, for example, a message has a parent ID of 15, it was created as a reply to the message ID 15.
2: What is a problem with the blob data type?
A2: ASP and other products might not deal with binary data types correctly. This is not a fault of the database—rather the software accessing the fields.
3: Why shouldn't you pass all parameters in the Go To Detail Page behavior when they are applied to the list of replies?
A3: If you pass the ID parameter on a page that's already passed the ID parameter, you'll end up with two copies of the ID being passed through the URL. This will cause headaches for the server.
4: On multiple recordset pages, what do you need to watch out for?
A4: Make sure you've chosen the right recordset when adding server behaviors to the pages. If your code doesn't act the way you think it should, you might be working within the wrong recordset.
5: What is the problem with having the field named Hidden exist as a hidden field on the form?
A5: The field Hidden is not necessarily a good thing to put on the form page. A user could easily modify the page locally on her machine and change the hidden value. A better way to do it is to edit the SQL code directly on the page to save the value. Because this isn't a high-security application, it's not overly important.



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint