[web2py] Apache + multidomain + SSL

2018-01-03 Thread Kenneth
Hello,

does anybody have experience with setting up Apache with separate 
certificate for multi domains. I have it working like 95% but something is 
strange, I can't for example look at errors with this setup. 


Kenneth

-- 
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/d/optout.


[web2py] How to select row based on item ID or name

2018-01-03 Thread Maurice Waka






I have the following code for my DB:
dbmyhealth.define_table("health", 
Field('name', 'string'),
Field('definition', 'text', length= 100,),
Field('abnval', 'text', length= 100,),
Field('normval', 'text', length= 100,),
Field('administration', 'text', length= 
100,),
Field('screening', 'text', length= 100,),
Field('causes', 'text', length= 100,),
migrate = False)

rows  = dbmyhealth().select(dbmyhealth.health.ALL)
for row in rows: 
location0 = row.name
location1 = row.definition
location2 = row.abnvalinterpret
location3 = row.normvalinterpret
location4 = row.administration
location5 = row.screening
location6 = row.causes
corpus = [location1 , location2, location3, location4, location5, 
location6]

I want to select an item, including all the fields from the abnval to the 
causes,not randomly but based on the ID or the name. If I use the limitby 
constraint,I can get either the first, second, or last item based on the 
selection used. If I use the below code, I get only the first item, which 
is everything based on obesity. I want to select any item with every query 
using either an ID or the names below e.g.
A code like: 
for row in rows:
if id == 2
code..
   corpus = [location1 , location2, location3, location4, 
location5, location6]in this case my corpus will have everything on 
cardiomyopathy using the table details below.

id name
0. diabetes
1. hypertension
2. cardiomyopathy
3. copd
4. obesity

So how do I code it to obtain my answer
Kind regards


-- 
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/d/optout.


[web2py] A web2py image slide show

2018-01-03 Thread mostwanted
Hi guys, complements of the new season to you all.
Can anyone tell where i can find a simple web2py image slide show that's 
manually navigated with buttons?
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/d/optout.


[web2py] Date widget seems boroken on 2.16.1

2018-01-03 Thread Carlos Cesar Caballero Díaz
Hi guys, is just me, or the date widget seems broken on 2.16.1 (see 
attached image)?



Greetings.

--
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/d/optout.


Re: [web2py] url structure

2018-01-03 Thread Richard Vézina
You have to move in the root of web2py the file and rename it...

Richard

On Wed, Jan 3, 2018 at 11:12 AM, Richard Vézina  wrote:

> Look in web2py/examples/ parametric router file and set as default you
> desired app :
>
> routers = dict(
>
> # base router
> BASE=dict(
> default_application='welcome',
> ),
> )
>
> Replace welcome by you app... Web2py should then load your app as default
> and you can access it without the /application/default in the URL.
>
> You can read the book section about that too should be documented in the
> book.
>
> Richard
>
> On Wed, Jan 3, 2018 at 11:09 AM, jcrowe  wrote:
>
>> Currently, my URLs look like:
>>
>> http://www.domain.com/application/default/
>>
>> Can anyone point me to instructions on how I can drop the /application/
>> and only include the domain and controller?
>>
>> --
>> 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/d/optout.
>>
>
>

-- 
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/d/optout.


Re: [web2py] url structure

2018-01-03 Thread Richard Vézina
Look in web2py/examples/ parametric router file and set as default you
desired app :

routers = dict(

# base router
BASE=dict(
default_application='welcome',
),
)

Replace welcome by you app... Web2py should then load your app as default
and you can access it without the /application/default in the URL.

You can read the book section about that too should be documented in the
book.

Richard

On Wed, Jan 3, 2018 at 11:09 AM, jcrowe  wrote:

> Currently, my URLs look like:
>
> http://www.domain.com/application/default/
>
> Can anyone point me to instructions on how I can drop the /application/
> and only include the domain and controller?
>
> --
> 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/d/optout.
>

-- 
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/d/optout.


[web2py] url structure

2018-01-03 Thread jcrowe
Currently, my URLs look like:

http://www.domain.com/application/default/

Can anyone point me to instructions on how I can drop the /application/ and 
only include the domain and controller? 

-- 
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/d/optout.


Re: [web2py] Fetch data from database

2018-01-03 Thread Massimiliano
You can do something like:

db.executesql(‘select * from ’, as_dict=True )

On Wed, Jan 3, 2018 at 7:09 AM, Narendra Kumar <
narendrakumar.varan...@gmail.com> wrote:

> Hi,
> Is it possible to select/fetch data from database using
> db().select(db.tablename.ALL).
>
> while table exists in database but not defined as db.define_table(
> 'tablename', Field('column'), Field('COLUMN')).
>
> Please help, I need to fetch large data and download,But I need to reduce
> time to complete the process.
>
> Thanks and Regards.
> Narendra kumar
>
> --
> 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/d/optout.
>



-- 
Massimiliano

-- 
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/d/optout.