Hi jacob, i am trying to do the same thing, did you find a solution for
this?
On Saturday, April 27, 2019 at 4:20:10 AM UTC+2 Jacob wrote:
> Thank you for the response it appears that they do have the same name .
> I'm sorry I'm still new to programming in general, I've read around about
> how
Hi all
I have recently moved from SQLite to Postgres, I've had to change all the
'groupby' to 'distinct'. However, I'm also using the 'groupby; command in
the SQLgrids, but this does not have a distinct option.
Does anyone know of a workaround? Example code below
def re_standardise_taxon():
Hi all
Anyone using this feature with the current version of web2py. I tried to
get the feature working using the code from the link below but it isnt
working propery i.e. can´t close pop up box, form doesn't refesh when i
insert a new entry. I still have to learn Jquery and javascript
https:/
Looks like you are not sending/recieving your args properly (
For example You need to send args=Customer.id , from a button or redirect
for example
You then need to request the Customer.id in the 'Client_Update' function
So you'd need
def Client_Update():
client=request.args(0,cast=int)
thanks that worked a treat! So was that done using jquery? I still have to
learn about it
On Thu, Sep 13, 2018 at 5:39 PM Anthony wrote:
> On Thursday, September 13, 2018 at 8:36:11 AM UTC-4, Marcelo Huerta wrote:
>>
>> El jueves, 13 de septiembre de 2018, 8:10:48 (UTC-3), Matthew J Watts
>> esc
great, thanks all i´ll give that a go tomorrow!
On Thu, Sep 13, 2018 at 5:39 PM Anthony wrote:
> On Thursday, September 13, 2018 at 8:36:11 AM UTC-4, Marcelo Huerta wrote:
>>
>> El jueves, 13 de septiembre de 2018, 8:10:48 (UTC-3), Matthew J Watts
>> escribió:
>>>
>>> Hello all
>>>
>>> Is there
Hello all
Is there a way to pre populate the 'search field' of the SQLFORM.grid?
For example i can populate fields in an SQLFORM with variables using
something like
db.study_data.taxon.default = request.get_vars.tax_species
However, could i do something like?
grid.search.default = reques
Hi Manuele
Thanks for your feedback, i've got it sorted now Anthony kindly helped me
with the code. I'm still adding some things. But i'll upload the final code
once i'm done!
On Wed, Aug 8, 2018 at 9:46 AM, Manuele Pesenti
wrote:
> or just let you be inspired from the update_or_insert method i
Many thanks for your help all, i'm slowly getting my head around it.
I'll post the code once it's finished in case anyone needs it in future
cheers
Matt
On Wed, Aug 1, 2018 at 7:41 AM, sandeep patel
wrote:
> @Mattew J Watts,
> #Model
>
> db.define_table('person',
> Field('n
Hi all
I'm having the same problem, i'm trying to return an ID after an
'update_or_insert', but I need the ID whether it inserts or updates to add
as a forign key to a related table.
Does anyone have a work around, someone mentioned that you could just
'db(condition).select(table.id) after th
ps - i'm getting the file locally as i havent worked out the .retrieve:
method yet
On Tuesday, July 31, 2018 at 6:51:41 PM UTC+2, Matthew J Watts wrote:
>
> Hello all
>
> I'm trying to build a .csv data upload facility which will update two
> tables in sequence. So, i have my 'person' table w
Hello all
I'm trying to build a .csv data upload facility which will update two
tables in sequence. So, i have my 'person' table which has a one to many
relationship with the 'thing' table i.e. one person can own many different
things.
What i need to do is get the primary key from a 'person'
> maybe that's some help you
>
> Thanks
> sp
>
>
> On Sat, May 26, 2018 at 3:17 PM, 'Matthew J Watts' via web2py-users <
> web2py@googlegroups.com> wrote:
>
>> Thanks for your help all!
>> i'll give these a go. Sorry
Thanks for your help all!
i'll give these a go. Sorry if i want that clear, but i'm not trying to
use a grid, i'm trying to redirect from a button in views
{{=A('Cancel',_href=URL('my_collections'),_class="btn btn-primary")}}
On Sat, May 26, 2018 at 8:21 AM, Sandeep Patel wrote:
> @
Hi all
How do i send args via a button from views.
For example, i'd like to send variables to the 'my_collections URL' {{=A(
'Finish',_href=URL('my_collections'),_class="btn btn-primary")}}
I can do something similar from the grid in a controller, however i cant
find the right way to it from
/AdminIsDisabledBecauseInsecureChannel/
On Wed, May 2, 2018 at 2:09 PM, 'Matthew J Watts' via web2py-users <
web2py@googlegroups.com> wrote:
> Hi everyone
>
>
> I am trying to deploy an app, built with version 2.16.1, on the python
> anywhere server using version 2.14.6
>
>
Hi everyone
I am trying to deploy an app, built with version 2.16.1, on the python
anywhere server using version 2.14.6
However, i get a message telling me i need the latest version of the app on
the server.
What do i need to do with the app to make it compatible with 2.14.6?
Any ideas
Ok thanks for your tips Val, i'll focus my efforts on learning basic java
script then and libraries
Cheers
Matt
On Sat, Mar 3, 2018 at 3:43 PM, Val K wrote:
> just for clarity:
> JQuery is a Javascript library. Javascript doesn't have any relation to
> Java. Web2py also has nothing to do with
Ciao Massimo
Thanks for getting back to me. Where do i start! As a beginner i'm
struggling to understand how i go developing the dependent /cascading drop
down list, eventually i also want to start using the d3 library with my
app.
There seems to be several concepts i need to learn to be able bui
Can anyone point me in the right direction with this, any good tutorial out
there on how i can integrate java and web2py?
On Friday, February 9, 2018 at 12:05:32 PM UTC+1, Matthew J Watts wrote:
>
> Thanks for your reponse David!
>
> On Thursday, February 8, 2018 at 8:56:19 PM UTC+1, Dave S wrot
Thanks for your reponse David!
On Thursday, February 8, 2018 at 8:56:19 PM UTC+1, Dave S wrote:
>
>
>
> On Thursday, February 8, 2018 at 9:55:25 AM UTC-8, Matthew J Watts wrote:
>>
>> Hi community
>>
>> I'm having a few problems trying to understand how create a cascading
>> drop down list. I've
Hi community
I'm having a few problems trying to understand how create a cascading drop
down list. I've followed this tutorial -
http://www.web2pyslices.com/slice/show/1526/cascading-drop-down-lists-with-ajax-2
i've managed to adapt it slightly, but i'm having trouble trying to add
more tables
t the project never progressed so I can’t help you with
> web2py and Bokeh.
>
> Eric
>
> On Nov 25, 2017, at 5:53 AM, 'Matthew J Watts' via web2py-users <
> web2py@googlegroups.com> wrote:
>
> Hi Eric
>
> Did you end up using web2py for this project?
>
>
Hi Eric
Did you end up using web2py for this project?
Like you i'm a Biologist trying to use Web2py by to query, process and
visualize data, I was wondering if you could show me an example of how you
integrated Bokeh into web2py
Thanks
Matt
On Saturday, January 24, 2015 at 5:23:22 PM UTC+1,
great, thanks for your help Dave. I'll have a go and if i have any luck
will post my code for future reference
On Mon, Oct 23, 2017 at 10:02 PM, Dave S wrote:
>
>
> On Saturday, October 21, 2017 at 2:25:47 PM UTC-7, Matthew J Watts wrote:
>>
>> Hi all
>>
>> I'm pretty new to web2py and web devel
Hi all
I'm pretty new to web2py and web development in general. I'm really stuck
with something and haven't been able to find a tutorial which can help me
out etc. I was wondering if some one could point me in the right direction.
I have three tables. I want to upload a csv, and update each ta
Hi there, does anyone know how to get this working with the latest version
of web2py - i can't get it working, not even in the sample app below
https://github.com/mdipierro/web2py-recipes-source/blob/master/apps/05_adding_ajax_effects/web2py.app.select_or_add_widget.w2p
thanks
Matt
--
Resourc
Is that correct.
>
> I've never done that, but I don't see how it would change anything other
> than the 'left' setup.
>
> -Jim
>
> On Fri, Jul 21, 2017 at 5:54 AM, 'Matthew J Watts' via web2py-users <
> web2py@googlegroups.com> wrote:
&
Hi, do you know if this is the same when i use primary keys of legacy
tables - doesn't seem to be working when i change my tables to primary key.
thanks
On Wed, Jul 19, 2017 at 4:10 PM, Jim S wrote:
> We were all there once. Glad I was able to help. Part of the beauty of
> web2py is the commun
Great thanks Jim, that did it for me - it's hard being a beginner!!
On Wed, Jul 19, 2017 at 2:09 PM, Jim S wrote:
> I'd start first with changing this:
>
> links = [lambda ids: A('Download data set',_href=URL("default","down
> load_dataset.csv",args=[ids.id]))]
>
> to this:
>
> links = [lambda i
Hi all
I'm having some problems trying to achieve the following
I have a grid with left joins which selects a subset of entries in my
database -(query between 3 tables)
Once i get the desired result, i want to be able to set up links within the
table that then send the id from each row (MA
Ok thanks Antony i'll look into it, this looks like it could take some
time!!
On Friday, July 7, 2017 at 2:42:37 PM UTC+2, Matthew J Watts wrote:
>
> Hi all
>
>
>
> I’m having problems trying to tailor the grid to my needs
>
> I've set up a grid to query my db and it retrieves the data successf
Hi all
I’m having problems trying to tailor the grid to my needs
I've set up a grid to query my db and it retrieves the data successfully,
great!
Example: def gridquery():
grid = SQLFORM.grid((db.MAIN.TaxonID == db.TAXON.TaxonID), field_id =
db.MAIN.MainID, fields=[db.TAXON.Ta
I'm trying to do the same, can anyone help?
On Friday, June 28, 2013 at 3:03:12 AM UTC+2, fun man wrote:
>
> Hi all,
>
> I have a couple tables joined in the sqlform.grid. They both have around
> 20 fields. I am only displaying around 10~15 fields for a particular
> purpose.
>
> When I click
thanks Peter, as for the grid i'm currently trying to work out how to
customize it, but yes i think the "buttons_placement = 'right' " puts the
buttons on the right
On Wednesday, July 5, 2017 at 4:39:17 AM UTC+2, Peter wrote:
>
>
> Glad you got something out of it Matt!
>
> I decided to try an
Thanks Peter - that was very helpful indeed. I didn't manage to get a
'download to CSV from checkboxes' function working, don't quite get why
as i managed to set up a 'download links from rows ' function in the
SQLFORM.grid.
Here is the code for you just in case it is any help for you in the fut
thanks for your help Peter!
Actually, i've been playing around with it but need some into on
the functions/views too!
'The report_functions should point to valid report functions/views
that you have created (I can provide some info on this if needed)'
On Tue, Jul 4, 2017 at 4:37 AM, Peter
Hi all
I'm trying to modify an SQLFORM.grid so it has selectable check boxes,
which allow the user to download selected queries as CSV files once the
submit button has been clicked.
Can anyone help me with this?
Thanks in advance
Matt
--
Resources:
- http://web2py.com
- http://web2py.com
Ok great thanks , i will check it out
On Tue, May 23, 2017 at 1:53 AM, 黄祥 wrote:
> i think you can use widget to show checkbox : SQLFORM.widgets.checkboxes.
> widget
> ref:
> http://web2py.com/books/default/chapter/29/07/forms-and-validators#Widgets
> and use record representation for download
>
Hi all
I'm new to web2py and i'm stuck on the following issue.
I am trying to Edit an SQLFORM.grid so that I can use the check boxes
(selectable) to select which rows to download.
Can anyone give me a few pointers on this.
Thanks
Matt
--
Resources:
- http://web2py.com
- http://web2py
hello, did you ever find a better solution for this?
I want to do the same thing
On Monday, September 30, 2013 at 11:33:57 AM UTC+2, step wrote:
>
> I want to use SQLFORM.grid with selectable checkboxes to serve a custom
> export function. Unlike web2py's default exportformats manager, which
>
Thanks Marlysson. I'm just going through that chapter now. What i really
need to know is how I can trigger queries through various drop down boxes.
For example, for one query, i need to create a cascading drop box that can
select data sets at different taxonomic levels (animal kingdoms, family,
spe
Hi there everyone!
I'm new to Web2py, i'm really enjoying using the framework so far.
I am trying to rebuild a legacy database.
I want to produce a web app that can query data from multiple tables using
drop down boxes e.g. locations, species etc.. I want to be able to select
info using drop
I had to log out of my webapp before deleting the database data, otherwise
i would get an error message
cheers
On Monday, November 14, 2011 at 1:38:15 AM UTC+1, Archibald Linx wrote:
>
> Dear Web2py users,
>
> How can I reset the database of my Web2py project ?
>
> Thanks,
> Archibald
--
Re
44 matches
Mail list logo