As a warning, querying before inserting does not guarantee uniqueness in the transactional sense.
If 2 users try to add the same name at the same time, they will both insert and you will not have uniqueness. The only way to get transactional uniqueness on GAE is using a keyname and a transactional insert. Robin On Jan 13, 1:04 am, Lennon <lpru...@hotmail.com> wrote: > I solved my own problem. I has originally entered the name of the > title as a "text" types instead of a "string" type. That was the > problem. > > On Jan 13, 12:41 am, Lennon <lpru...@hotmail.com> wrote: > > > Hello all, > > > I'm attempting to check and see if an item title exists in the item's > > database table before inputting it. I've read that GAE won't accept > > the "IS_NOT_IN_DB" validation so I'm attempting to find a workaround. > > I tried unique = false but that didn't seem to change anything. > > Identical title names were still accepted. > > > I tried using this query to see if the length = 1 : > > > l = len(db(db.post_item.name == name).select()) > > > The error i got back was: > > > 'AppEngine does not index by: text' > > > Thanks for your help and ideas, > > > ~Lennon
-- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
