[web2py] Re: I keep getting the error: invalid literal for int() with base 10: 'Plumber'

I have to use some form of autocomplete input instead of a drop down because there will be a lot of titles, like hundreds, so it would be easier to have people type and have it auto corrected. I'm still unsure why this code, would return the error: ValueError: invalid literal for int() with base

[web2py] Re: I keep getting the error: invalid literal for int() with base 10: 'Plumber'

Is Plumber being entered in the 'title' field of the user table? If so, that field is expecting an integer because it is a reference to the 'id' field of the 'title' table (which is an integer field). listing.title.requires = [IS_IN_DB(db, db.title.name)] Your validator, on the other hand,

[web2py] Re: I keep getting the error: invalid literal for int() with base 10: 'Plumber'

Woohoo it's now working! Thank you Anthony!!! 2 questions: 1. When I have listing.title.requires = [IS_IN_DB(db, db.title.id, '%(name)s')] as a list (which is how I want it, it doesn't seem to let me register, it still expects an int, how can I make it expect a string that's equal to an

[web2py] Re: I keep getting the error: invalid literal for int() with base 10: 'Plumber'

On Sunday, August 14, 2011 7:05:17 PM UTC-4, Jarrod Cugley wrote: Woohoo it's now working! Thank you Anthony!!! 2 questions: 1. When I have listing.title.requires = [IS_IN_DB(db, db.title.id, '%(name)s')] as a list (which is how I want it, it doesn't seem to let me register, it still