First lets make a page that lets people search the database. Now lets examine the above. Any part of the SQL statement can be substituted with a variable passed from a previous page as I did with the sex variable. Finally notice what is in the More Info column. This is a link to another page that also passes the FriendID as an argument.
Lets take a look at that page now.
Now lets examine the above. This time for the output I do not put it in a table since each ID is unique and I know only one row will be returned. Then I list the variables as before with one exception. For the comment variable I include the ParagraphFormat function. Conclusion You should now be able to create a fully database integrated Cold Fusion website.