I'd like to know if the console reports any error when the ajax
request is executed.
On 30 Giu, 15:31, elfuego1 <elfue...@gmail.com> wrote:
> I have firebug installed. What do you want me to look for?
> You want to see some firebug output?
>
> On 30 Cze, 22:25, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > I do not see anything wrong in this. Do you use firebug?
>
> > On 30 Giu, 15:18, elfuego1 <elfue...@gmail.com> wrote:
>
> > > I hope I don't make your eyes bleed by puting all the code here but
> > > there is no other way to show it to you.
> > > I made change only in one place of the code to gather "login" value:
> > > {login:value}
> > > Oryginaly it was: {name:value}.
>
> > > $.post("{{=URL(r=request,c='default',f='ajaxuserexist')}}",
> > > {login:value},function(result){
>
> > > Below is the whole content of index.html
>
> > > {{extend 'layout.html'}}
>
> > > <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
> > > "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd";>
> > > <html>
> > > <head>
> > > <meta http-equiv="Content-type" content="text/html;
> > > charset=utf-8">
> > > <title>Ajax User Validation with web2py by Martin Sagastume</
> > > title>
> > > <style type="text/css">
> > > <!--
> > > body { font-family:Arial,Verdana,Sans-serif; }
>
> > > input[type=text]{
> > > font-size:12px;
> > > color:#666666;
> > > background-color:#ffffff;
> > > padding-top:5px;
> > > width:200px;
> > > height:20px;
> > > border:1px solid #999999;
> > > }
>
> > > #resultbox { font-size:11px; }
> > > .msg { color:blue; }
> > > .success { color:green; }
> > > .error { color:red; }
> > > //-->
> > > </style>
> > > <script type="text/javascript"
> > > src="{{=URL(r=request,c='static',f='jquery.js')}}"></script>
> > > <script type="text/javascript">
>
> > > var submit = false;
> > > $(document).ready(function(){
> > > $("form").submit(function() {
> > > return submit;
> > > });
> > > });
>
> > > function getData(value){
> > > if(value != ""){
> > > $
> > > ("#resultbox").removeClass().addClass('msg').text('Validating...').fadeIn(10);
> > > $.post("{{=URL(r=request,c='default',f='ajaxuserexist')}}",
> > > {login:value},function(result){
> > > if(result=='yes'){
> > > $
> > > ("#resultbox").removeClass().addClass('error').text('Login already
> > > taken').fadeTo(900,1);
> > > submit = false;
> > > }else{
> > > $
> > > ("#resultbox").removeClass().addClass('success').text('Login is
> > > available for registration!').fadeTo(900,1);
> > > submit = true;
> > > }
> > > });
> > > }else{
> > > $("#resultbox").removeClass().addClass('msg').text('This
> > > field is required');
> > > }
> > > }
>
> > > </script>
> > > </head>
> > > <body>
> > > <form id="form1" method="post" action="page2">
> > > <label for="country">Login:</label><br />
> > > <input type="text" id="login" name="login"
> > > onblur="getData(this.value)" /><br />
> > > <div id="resultbox" class="msg"></div><br />
> > > <input type="submit" id="bsubmit" name="bsubmit"
> > > value="Submit" />
> > > </form>
> > > </body>
> > > </html>
>
> > > On 30 Cze, 22:12, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > > > This should give you an error because the print(username) is outside
> > > > the funciton the function that defines username, after the function
> > > > returns. How are you passing the username to the ajax call? Did you
> > > > check with firebug that is calls the correct url?
>
> > > > On 30 Giu, 15:01, elfuego1 <elfue...@gmail.com> wrote:
>
> > > > > There was NO error messages. The code just didn't work.
> > > > > After inserting:
> > > > > print repr(username) to default.py I got:
>
> > > > > # -*- coding: utf-8 -*-
>
> > > > > #########################################################################
> > > > > ## This is a samples controller
> > > > > ## - index is the default action of any application
> > > > > ## - user is required for authentication and authorization
> > > > > ## - download is for downloading files uploaded in the db (does
> > > > > streaming)
> > > > > ## - call exposes all registered services (none by default)
> > > > > #########################################################################
>
> > > > > def index():
> > > > > """
> > > > > example action using the internationalization operator T and flash
> > > > > rendered by views/default/index.html or views/generic.html
> > > > > """
> > > > > response.flash = T('Welcome to web2py')
> > > > > return dict(message=T('Hello World'))
>
> > > > > def user():
> > > > > """
> > > > > exposes:
> > > > > http://..../[app]/default/user/login
> > > > > http://..../[app]/default/user/logout
> > > > > http://..../[app]/default/user/register
> > > > > http://..../[app]/default/user/profile
> > > > > http://..../[app]/default/user/retrieve_password
> > > > > http://..../[app]/default/user/change_password
> > > > > use @auth.requires_login()
> > > > > @auth.requires_membership('group name')
> > > > > @auth.requires_permission('read','table name',record_id)
> > > > > to decorate functions that need access control
> > > > > """
> > > > > return dict(form=auth())
>
> > > > > def download():
> > > > > """
> > > > > allows downloading of uploaded files
> > > > > http://..../[app]/default/download/[filename]
> > > > > """
> > > > > return response.download(request,db)
>
> > > > > def call():
> > > > > """
> > > > > exposes services. for example:
> > > > > http://..../[app]/default/call/jsonrpc
> > > > > decorate with @services.jsonrpc the functions to expose
> > > > > supports xml, json, xmlrpc, jsonrpc, amfrpc, rss, csv
> > > > > """
> > > > > session.forget()
> > > > > return service()
>
> > > > > def page2():
> > > > > name = request.vars.login
> > > > > #db.auth_user.insert(name=name)
> > > > > return dict(name=name)
>
> > > > > def ajaxuserexist():
> > > > > username = request.vars.values()[0]
> > > > > return db(db.auth_user.login==username).count() and 'yes' or
> > > > > 'no'
>
> > > > > print repr(username)
> > > > > response._vars=response._caller(index)
>
> > > > > On 30 Cze, 21:51, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > > > > > You can simplify it a bit
>
> > > > > > def ajaxuserexist():
> > > > > > username = request.vars.values()[0]
> > > > > > return db(db.auth_user.login==username).count() and 'yes' or
> > > > > > 'no'
>
> > > > > > although it will not solve your problem.
> > > > > > There is nothing special in table auth_user so the problem is
> > > > > > somewhere else.
>
> > > > > > I suggest you insert a print repr(username).
> > > > > > Do you get any thicket? What does it say?
>
> > > > > > massimo
>
> > > > > > On 30 Giu, 14:29, elfuego1 <elfue...@gmail.com> wrote:
>
> > > > > > > During registration I want to check on the fly, if login chosen
> > > > > > > by the
> > > > > > > user is already in use or is it not in db and available to be
> > > > > > > used.
>
> > > > > > > def ajaxuserexist():
> > > > > > > username = request.vars.values()[0]
> > > > > > > query = (db.auth_user.login==username)
> > > > > > > numres = db(query).count()
> > > > > > > if numres > 0 :
> > > > > > > return 'yes'
> > > > > > > else:
> > > > > > > return 'no'
>
> > > > > > > When I test it on any other table that doesn't have prefix auth_
> > > > > > > then
> > > > > > > the above code works, but unfortunatelly I need to test auth_user
> > > > > > > table :-(
>
> > > > > > > On 30 Cze, 21:19, Chris S <sanders.ch...@gmail.com> wrote:
>
> > > > > > > > Probably a dumb question, but what are you checking the user
> > > > > > > > against?
>
> > > > > > > > Both my and your example above are checking for username and you
> > > > > > > > didn't define a username in your auth_user.
>
> > > > > > > > Your query then is not working as:
>
> > > > > > > > def userexist(emailcheck):
> > > > > > > > if db(db.auth_user.email==emailcheck).count() > 0:
> > > > > > > > return 'yes'
> > > > > > > > else:
> > > > > > > > return 'no'
>
> > > > > > > > I know I've returned searches on auth_user it's no different
> > > > > > > > than
> > > > > > > > other tables. Just gotta find whey your getting no results.
> > > > > > > > Might
> > > > > > > > help if you post the exact search code that goes with the above
> > > > > > > > auth_user and the error message that's generated.
>
> > > > > > > > On Jun 30, 2:12 pm, elfuego1 <elfue...@gmail.com> wrote:
>
> > > > > > > > > Since I had added some fields (and intend to customize it
> > > > > > > > > further) to
> > > > > > > > > my auth_user table the code for auth_user in db.py looks like
> > > > > > > > > that:
>
> > > > > > > > > from gluon.tools import *
> > > > > > > > > auth=Auth(globals(),db)
>
> > > > > > > > > db.define_table('auth_user',
> > > > > > > > > SQLField('login', 'string', length=50, default=''),
> > > > > > > > > SQLField('password', 'password', length=512,
> > > > > > > > > readable=False,
> > > > > > > > > label='Password'),
> > > > > > > > > SQLField('registration_key', length=512, default= '',
> > > > > > > > > writable=False, readable=False),
> > > > > > > > > SQLField('reset_password_key', length=512, default='',
> > > > > > > > > writable=False, readable=False),
> > > > > > > > > SQLField('first_name', length=128,default=''),
> > > > > > > > > SQLField('last_name', length=128,default=''),
> > > > > > > > > SQLField('email', length=128,default='', unique=True),
> > > > > > > > > SQLField('phone', 'string', length=30, default=''),
> > > > > > > > > )
>
> > > > > > > > > On 30
>
> ...
>
> leggi tutto
