On Tuesday 15 January 2008 09:18:06 you wrote: > Rick Cook wrote: > > Actually, the table does have an auto-incrementing integer key field. It > > also has another field that I am requiring to be a unique email address > > for each row of the table. I am actually trying to use the SelectQuery to > > pick out the appropriate integer key field if there is a record that > > already has the email address entered on the beginning page. > > Ah, I see. It sounds like an (:update select:) might meet your needs as > well as or better than a SelectQuery... it would certainly take up less > space on your pages! Just make sure to put it in a method=get form: > > (:input form method=get action=FormPage:) > Edit an existing record: > (:update select ContactID from=TableName label=Email null="Create a new > record":) > (:input submit:) > (:input end:)
Thanks, I made use of this idea for the "edit existing entries" part of my requirements and used a simple update form as the way to do the original entry. I guess I will live with the MySQL related error message that occurs if someone uses the "original entry form" and happens to input an email address that matches an existing entry. I want people are not logged in to be able to create a new entry, however, I don't want them to be able to see the existing database content. Rick _______________________________________________ pmwiki-users mailing list [email protected] http://www.pmichaud.com/mailman/listinfo/pmwiki-users
