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:) > Any suggestions about how to "not specify" the key value for the case when > the > key value doesn't exist and also specify it when it does? The (`ContactID`) Sure, that's what the null parameter in the update tag above should do -- when the null row is selected, no value is submitted for the ContactID. To do the same thing with SelectQuery, just put a link before or after the list saying, Don't see the email address you're looking for? [[Create a new record -> FormPage]] By "specify," I mean that there's a ?ContactID=XXX in the URL when you go to the page. So the links generated by SelectQuery specify the ContactID, and pretty much any other link you care to create will not specify it. > If I could figure out how to make DataQuery provide the desired > functionality, > DataQuery would be fine with me. Now that I know what you're doing, DataQuery is not a good fit. If you were using the unique field as the primary key, DataQuery would be perfect, but you can't really do that with email addresses... you'd have to either have a calculated field that gets rid of their dots, or use a search form to find the records that match a given address. It sounds like you're better off sticking with UpdateForm on this one. Hope this helps! --Ben S. _______________________________________________ pmwiki-users mailing list [email protected] http://www.pmichaud.com/mailman/listinfo/pmwiki-users
