[web2py] Select Image In Custom Registration
I have a custom registration form and i am getting a good grasp of the concepts behind customizing the auth_table. I was curious about one thing i could not find a good direction for. I want users to be able to select an image from a drop down menu at the registration page for their avatar. Any tips or suggestions on how to accomplish this? Much appreciated in advance. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
[web2py] Re: orderby variable, uknown column
Thank you so much! was this covered in some documentation i may have missed? On Wednesday, November 13, 2013 8:51:06 AM UTC-8, Niphlod wrote: > > because db.table.field is NOT a string. > > statA = request.vars.stat1 > order='db.allstats.'+statA > > should be > > statA = request.vars.stat1 > order=db.allstats[statA] > > On Wednesday, November 13, 2013 3:32:20 AM UTC+1, Noah Corradin wrote: >> >> can someone explain to me why the following does not perform the way i >> thought it would >> >> This works: >> results=db(db.allstats.ptype==ptype).select(db.allstats.ALL, >> orderby=db.allstats.attack) >> >> But this does not: >> >> statA = request.vars.stat1 >> order='db.allstats.'+statA >> >> results = db(db.allstats.ptype==ptype).select(db.allstats.ALL, >> orderby=order) >> >> i receive: uknown column 'db.allstats.attack' >> >> i've built selects using variables but i cant build orderby with >> variables? any tips would be awesome. >> > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
Re: [web2py] query from drop down menu
Thank you very much for the reply. i was able to figure it out but ill look
into this method as well.
On Tuesday, November 5, 2013 9:04:57 PM UTC-8, Kiran Subbaraman wrote:
>
> I would use the ajax+callback mechanism that exists in web2py to do
> this. Look at the simple wiki example, and *search*code there:
> http://web2py.com/books/default/chapter/29/03/overview#A-simple-wiki.
>
>
> Kiran Subbaraman
> http://subbaraman.wordpress.com/about/
>
> On 11/6/2013 7:22 AM, Noah Corradin wrote:
> > I am trying to execute a query based on the values of 3 drop down
> > menus. I have the following for drop down menus but i am unsure on
> > how to turn the selected values into queries.
> > Is this the proper way to do it in web2py?
> >
> > {{extend 'layout.html'}}
> >
> > {{rows = db().select(db.stats.ALL)}} {{for row in
> > rows:}}{{=row.name}}{{pass}}
> > {{rows = db().select(db.stats.ALL)}} {{for row in
> > rows:}}{{=row.name}}{{pass}}
> >
> > any pointers would be great
> > Thanks!
> >
> > --
> > Resources:
> > - http://web2py.com
> > - http://web2py.com/book (Documentation)
> > - http://github.com/web2py/web2py (Source code)
> > - https://code.google.com/p/web2py/issues/list (Report Issues)
> > ---
> > You received this message because you are subscribed to the Google
> > Groups "web2py-users" group.
> > To unsubscribe from this group and stop receiving emails from it, send
> > an email to web2py+un...@googlegroups.com .
> > For more options, visit https://groups.google.com/groups/opt_out.
>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
[web2py] orderby variable, uknown column
can someone explain to me why the following does not perform the way i thought it would This works: results=db(db.allstats.ptype==ptype).select(db.allstats.ALL, orderby=db.allstats.attack) But this does not: statA = request.vars.stat1 order='db.allstats.'+statA results = db(db.allstats.ptype==ptype).select(db.allstats.ALL, orderby=order) i receive: uknown column 'db.allstats.attack' i've built selects using variables but i cant build orderby with variables? any tips would be awesome. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
[web2py] How to generate URLs for each user similar to twitter?
I understand that Web2Py's urls work like this: 127.0.0.1:9292/// I'm building an app that has user logins and I want to have a sort of profile page for each user that has an easy to remember URL. Similar to on twitter where to go to a user's page you just navigate to twitter.com/. How does one achieve this using Web2Py? Currently I have it working so that the Username is a GET parameter and the URL looks like: 127.0.0.1:9292//Users/Wall?UserName=Thomas1 Where 'Users' is the Controller and 'Wall' is the function. I want it to be: 127.0.0.1:9292//Users/Thomas1 Thanks for your help. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
[web2py] query from drop down menu
I am trying to execute a query based on the values of 3 drop down menus. I
have the following for drop down menus but i am unsure on how to turn the
selected values into queries.
Is this the proper way to do it in web2py?
{{extend 'layout.html'}}
{{rows = db().select(db.stats.ALL)}} {{for row in
rows:}}{{=row.name}}{{pass}}
{{rows = db().select(db.stats.ALL)}} {{for row in
rows:}}{{=row.name}}{{pass}}
any pointers would be great
Thanks!
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
[web2py] How to build a SQLFORM for relational database? Beginner in need of help.
I have a relational database structure containing 3 tables, set up in the
model as follows:
db.define_table('author',
Field('name', 'string'),
Field('bio', 'text'))
db.define_table('link',
Field('name', 'string'),
Field('description', 'text'))
db.define_table('post',
Field('body','text',label="Post Body"),
Field('authorID', db.author),
Field('linkID', db.link),
Field('posted_on','datetime',readable=False,writable=False),
Field('posted_by','reference auth_user',readable=False,writable=False))
I want to create a form that allows the user to submit a Post using the
following inputs:
- Post Body -(db.post.body)
- Author Name -(db.author.name)
- Link Name -(db.link.name)
If the author name or link name already exists in the database, it doesn't
need adding to that table again. Instead the post should just be inserted
using the existing IDs.
I'm way over my head on this one.. I'm just learning Web2Py.
Thanks for any help!
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
[web2py] SQLFORM for a relational database combined with insert only if record does not currently exist?
I have 3 tables defined in my model like so:
db.define_table('author',
Field('name', 'string'),
Field('bio', 'text'))
db.define_table('source',
Field('name', 'string'),
Field('description', 'text'))
# a table to store posted Quotes
db.define_table('post',
Field('body','text',label="Post Body"),
Field('posted_on','datetime',readable=False,writable=False),
Field('posted_by','reference auth_user',readable=False,writable=False),
Field('authorID', db.author),
Field('linkID', db.link))
I want to create a form that will allow the users to submit a post using
the following inputs:
- Post Body (db.post.body)
- Author Name (db.author.name)
- Link Name (db.link.name)
If the author already exists in the database, no record should be created.
If the link already exists then no record should be created either.
A record should be added to post containing either the newly created or
existing IDs for Author and Link.
How would I go about doing this? I am extremely new to Web2Py.
Thanks for your help!
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
[web2py] Issues with rendering wiki in html.
I've been working with web2py for only the last few weeks, so it's likely this is a problem borne mostly of my own ignorance, but I've been having issues rendering a wiki I've been working on. In my (closely related, so ideally with the same userbase and application name, but with some content that isn't particularly wiki-friendly) application, I've created a new controller called wiki.py with the following code. def index(): return auth.wiki(render='html') This sub-wiki of sorts works fine - it lets me create pages, they display, tagging works, the whole nine yards. However, it does not render the page in html, only in markmin. When I create a new application, and turn the whole application into a wiki via default.py's index function, rendering html does work. It's only with the sub-application arrangement that it gives me issues. Any advice? -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
[web2py] Re: web2py working on my iPad! :vD
Wow, all that for something that can't even run in the background? It was easier installing Debian on Android to achieve the same thing (sans the cant-work-in-background-mode).
