Skip to main content
Participant
August 28, 2006
Question

how to access/edit a dtabase record?

  • August 28, 2006
  • 2 replies
  • 551 views
Trying to create a database site that requires login, and will display records or let you create a new record to become part of those records.
This is a boyscout project, we are trying to have an extranet, that the boys can log into with username and password. Once in, they can see the records, edit and create. We have watched all the tutorials on the site, but can't find where we can query the database and then create a new record if the record has not been created yet. (Like a new boys comes into the program and is not part of the records yet).
Sorry for being such a newb. Thank you, Randy
This topic has been closed for replies.

2 replies

Known Participant
August 29, 2006
Please get a copy of the book "Web Application Construction Kit" by Ben Forta. You can not go wrong!
Participant
August 29, 2006
Thank you. While waiting for my Amazon order to get here, I signed up to read the online version of the book.
http://safari.oreilly.com/0321223675
This guy is amazing, writting coldfusion instructions in a way that keeps me wanting to get to the next page.

I appreciate the advice!
Randy - Assist Scoutmaster Troop # 1793 Southwest Utah
Inspiring
August 28, 2006
This is more of a sql question, but you would need to create a query that selects records from one table to see if the record exists. If the record does not exist, then create a new record. Something like this:

Inspiring
August 28, 2006
Also, a little more advanced... you can create a stored proc that does everything for you.