Hi Leonard, Thanks so much for your tips. I am going to search for this on the docs to print out before going home. I tested the form some,and it seems since I am checking if the email exists, and therefore saying "email taken" the code only works once, as I guess it is checking the db, and finding a blank email, and saying "email already exists. I think that I might have to make the fields required, to avoid this. I am stoked as I finally figured(thanks to you and greg) that you can write null values to the db.
Thanks so much for all your help, I really appreciated it very much:) John On Jul 12, 2008, at 9:43 PM, Leonard Boche wrote: > Hi John, > > Glad to hear you got things working. Gregs way > or my suggestion certainly should address your > issue for sure. > > On another note, a preference of mine (learned > from Adobe ColdFusion User Group) is that the action > page should be used as that an action / processing > page and then exit from it, with use of <cflocation> > and present confirmation or thank you information > on a separate page. > > Depending on the type of operation you are > doing, this process will/can assist in reducing > or eliminating double entries in your database. > > You can retain any variables you need on the > confirm page by using a cookie variable or a > session.variable on the action page and then > calling them on the confirm page. > > Glad things are working for you on your project. > > Leonard > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3826 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
