Hi there, this is my 3 attempts sending questions to this forum, i see
people sending questions here, but I don't see mine after I posted and
didn't get any reply. If someone can provide pointers, it's much
appreciated. (I just checked everything in the "Membership and email
setting", hope this
was when I
clicked on the linked_tables "Items" with error Query Not Supported:
invalid literal for long() with base 10: 'item'.
I have been stuck here for a few days, any further help is much
appreciated.
On Thursday, March 30, 2017 at 12:33:07 PM UTC+8, Rudy wrote:
>
Hi Anthony, thanks again for taking time out to explain and answered below
questions. I did define the customer table before auth tables were created
and used lazy_tables=False, it works this time when I put all the tables in
a single database without using CAS (i do need to share group/membersh
ght, i don't think we need to specify an ID
for the linked table according to the documentation, but I appreciate you
are chipping in your idea.
On Friday, March 31, 2017 at 11:58:06 PM UTC+8, Anthony wrote:
>
> It's not quite clear without seeing more code. I suggest you pack and
Hi Anthony,
Pardon me for asking stupid question, what does SQLFORM.smartgrid(.，
args=request.args[:1], ...) really do? you mentioned in earlier post that
args must be a list, and it preserves the 1st argument of URL for
application specific use. Does it tell web2py whatever url it creates,
Anthony,
I can't thank you enough for all your advises and help, not only i
understand more about the grid / smartgrid, but the use of request.args
now. I appreciate a lot of your time. Rudy
On Thursday, April 6, 2017 at 2:57:00 AM UTC+8, Anthony wrote:
>
> Pardon me for asking stup
Hi there,
I have created an accounting application, say the landing page is
http://localhost:8000/tests/accounting/index. I need to change the link
under "LOG IN" dropdown menu on top right corner to
http://./tests/accounting/user/login instead of using
http://./tests/default/user/logi
r='accounting', function='user')
>
> Anthony
>
> On Sunday, April 9, 2017 at 11:13:33 AM UTC-4, Rudy wrote:
>>
>> Hi there,
>>
>> I have created an accounting application, say the landing page is
>> http://localhost:8000/tests/accounting/index
info about Auth() arguments.
Thanks!
On Monday, April 10, 2017 at 12:09:44 AM UTC+8, Rudy wrote:
>
> Hi Anthony,
>
> Thanks again, it works. Now it leads to another question - my application
> has accounting system and ticketing system sharing the same auth's tables.
> The
bril de 2017 13:16:31 UTC-3, Rudy escreveu:
>>
>> Sorry Anthony, i just checked, your suggestion works when i have
>> accounting and ticketing systems sharing the same auth's tables, basically
>> it just uses the 'user' action under accounting controller to
Hi there,
I am building an accounting system. When I create a quotation, if the item
is in 'subscription' category, i want to use SQLFORM.factory(db.item,
db.subscription_item) to generate a create form for submitting the
necessary values. Now i want to edit these 2 tables(item and
subscriptio
Hi there,
It feels really strange to me that when i used SQLFORM.grid(), I got a
flash message "not authorised", but when i used smartgrid(), it worked just
fine (in both cases i had logged in already). I tried to removed
@auth.requires_login(), but same behaviour happened. I seem to miss some
>
> On Monday, 17 April 2017 12:09:58 UTC-5, Rudy wrote:
>>
>> Hi there,
>>
>> I am building an accounting system. When I create a quotation, if the
>> item is in 'subscription' category, i want to use SQLFORM.factory(db.item,
>> db.subscription_it
orm.vars.description)
item_row.update_record(amount=item_form.vars.amount)
subscription_row.update_record(start_date=item_form.vars.start_date)
subscription_row.update_record(renew_date=item_form.vars.renew_date)
On Monday, April 24, 2017 at 1:34:41 PM UTC+8, Rudy wrote
Hi there,
I tried to generate a CREATE FORM using below, then in my view, I added a
script trying to change the renew_date when an user changes the start_date
by using .change(function()). jQuery could detect the change if I manually
modified the date in the textbook, but not when I chose a dat
nthony wrote:
>
> Does it get triggered when the field loses focus? How about if you use
> .on("input", ...) instead of .on("change", ...)?
>
> Anthony
>
> On Tuesday, April 25, 2017 at 6:01:12 AM UTC-4, Rudy wrote:
>>
>> Hi there,
>>
>>
me, but I had
that strange problem when i thought i didn't miss anything. If i can ever
reproduce it, I'll let you know. Thanks so much!
On Thursday, April 27, 2017 at 9:50:59 AM UTC+8, Massimo Di Pierro wrote:
>
> Strange what is the url that you are using to access this page?
Hi there,
I have a quotation table which references the company table. When i created
a SQLFORM.grid, I couldn't use the company_name as keyword in the default
search widget as company field in the quotation table is integer type (id)
even though it's displayed as company_name. I can write an a
represent', it didn't allow me to do what I
wanted as described above. Any further input is appreciated. Thanks again
On Friday, April 28, 2017 at 1:26:48 AM UTC+8, Richard wrote:
>
> Hello Rudy,
>
> I am not sure I understand what you mean by : "I can write an action
&
ault search widget with a custom widget via
> the "search_widget" argument. For an example, see the default widget:
> https://github.com/web2py/web2py/blob/baa129f8715a9d126a81e7ce098d349894d65baa/gluon/sqlhtml.py#L1955
> .
>
> Anthony
>
> On Thursday, April 27
o you don't load a ton
> of data into you html page.
>
> Walking the extra miles and integrate with other js tech may be useful, as
> you learn new skill and make your app look more professional, it really
> depends of your need and the nature of your project.
>
> Goo
Not sure if you are still looking for the solution, i found it from another
thread. You need to add the "keyword" for the fields which reference the
same field in another table. Cheers!
db.define_table(
'order_cab',
Field('pick_up', db.location,
widget =
SQLFORM.widgets.autocomp
Hi there,
I have made a custom style of the SQLFORM, one field uses autocomplete, and
it's textbox is shorter than the rest of the field. I simply want to have
the same width. I searched in the previous post, another thread pointed out
that the html source shows 200px width, i wonder where I ca
I have an update SQLFORM for quotation table, i want to make
all_items_total and quote_amount not writable by user because
all_items_total should be the sum of all the items belong to this
quotation, not enter by user. The quote_amount should be all_items_total
minus discount, so when the user
luck, hope to see you here again.
query=db.quotation.id == quote_id
grid = SQLFORM.smartgrid(db.quotation, args=request.args[:1],
constraints=dict(quotation=query), )
On Monday, June 5, 2017 at 1:11:25 PM UTC+8, akshay0...@gmail.com wrote:
>
> Hi rudy,
> yes you
> you just have to do:
>> grid = SQLFORM.grid (db.auth_user, user_signature = False)
>>
>>
> I don't think that is related to the problem Rudy is having. By default,
> user_signature=True, which simply means the grid will not display
> create/edite/delete buttons
I posted a question a couple days ago asking how I can read a SQLFORM's
field and update it using javascript when its writable=False (because user
is not supposed to make change to the subtotal field manually, it should be
calculated based on the sum of all the items), but I didn't get any reply
On Wednesday, June 7, 2017 at 7:49:39 AM UTC+8, Rudy wrote:
>
> I posted a question a couple days ago asking how I can read a SQLFORM's
> field and update it using javascript when its writable=False (because user
> is not supposed to make change to the subtotal field m
need
it later. Thanks and case close.
On Wednesday, June 7, 2017 at 1:15:15 PM UTC+8, Rudy wrote:
>
> I just used the firefox inspector to see the source and spot the id and
> tag I need to get the non-writable field value, something like below:
> var quote_id = jQuery('#
Hi there,
Due to the javascript reason, i need to create a form using FORM and INPUT
helper. I wonder how I can create a form using these helpers with field
displaying a dropdown list for selection (of customer from quotation form)?
Below is a simplified version, currently i created autocomplet
Villas,
Thanks so much, I will take this approach. I just thought i might be able
to use IS_IN_DB and/or .represent to create this dropdown. Appreciate your
input! Rudy
On Saturday, June 24, 2017 at 9:36:58 PM UTC+8, villas wrote:
>
> If you are building a FORM with lower-level component
Hi there,
Not sure if I missed something obvious or the code is behaving strangely. i
have below simplified table, i have added 3 records with all voucher_id=1
and txn_source='INV', now I want to make a select statement as following,
the 2 select() calls have different results (inv_paid_count=3
dget as follows:
>
> SQLFORM.widgets.options.widget(db.quotation.customer, quote_row.customer)
>
> Anthony
>
> On Thursday, June 22, 2017 at 6:34:54 AM UTC-4, Rudy wrote:
>>
>> Hi there,
>>
>> Due to the javascript reason, i need to create a form using FO
val();
alert("invoice_total = " + invoice_total);
jQuery('#invoice_total').val('4000');
});
});
On Tuesday, July 11, 2017 at 8:31:21 PM UTC+8, Rudy wrote:
>
> Hi Anthony,
>
> Sorry I was on another issue, took me away for 2 weeks from below matter.
I want to clean up a table daily using schedule at midnight, I don't want
scheduler to poll too often to waste unnecessary resource. how should I do
it?
1) give heartbeat a large number in scheduler = Scheduler(db_sch,
heartbeat=7200)?
2) scheduler.queue_task(clear_curr_exch_cache, period=86400,
Hi i am working to build a multi-tenant application which has a company
table which stores logo and other data. I defined a company table, added
extra fields in auth_user and created an action (simplified version) like
below. web2py uploaded the logo image file under
myapp/uploads/company.logo/
Dave / Anthony,
Thanks for your input and confirmation. I will look into the code to see
how i can use the uuid to separate files for multi-tenant purpose.
On Tuesday, September 26, 2017 at 5:53:30 PM UTC+8, Dave S wrote:
>
>
>
> On Monday, September 25, 2017 at 11:03:59 PM UTC-7
Hi Andy / Anthony,
May i ask how you have addressed the multi-tenant requirement separating
all those uploaded files from different tenant to keep track of their
storage usage.
I want to use the client id as part of the uploadfolder, it worked as a
test below when I defined the uploadfolder in
exist, and
response.download() therefore cannot find the relevant upload folder.",
thanks for sharing your insight.
Rudy
On Monday, October 9, 2017 at 1:42:59 PM UTC+8, Andy W wrote:
>
> Hi Rudy
>
> Have you tried re-defining the download function to include the path to the
> location
next_company_id=last_company_row.id + 1
else:
next_company_id=1
On Thursday, September 28, 2017 at 12:32:46 AM UTC+8, Anthony wrote:
>
> On Wednesday, September 27, 2017 at 5:04:27 AM UTC-4, Rudy wrote:
>>
>> Dave / Anthony,
>>
>> Thanks for your input and confi
update the
> record with the file.
>
> Anthony
>
> On Thursday, October 12, 2017 at 8:26:16 PM UTC-4, Rudy wrote:
>>
>> Hi Antony,
>>
>> Thanks so much again for sharing your insights. I have been playing with
>> uploadfolder, your suggestion below
ber.default = max_id + 1
form=SQLFORM(db.invoice).process()
It works but like you said it can't support multiple user creating invoices
at the same time. Any suggestion what I can do to support multiple users
creating invoices for a specific company at the same time? Thanks! Rudy
On Sund
hello everyone
Im writting a custom module in the module dir. i am able to import it but
when I try to use the Translator T() the page errors out because T is not
defined.
what do I need to import to use T in a custom module?
try to refresh your editor or use
another editor to check the code, perhaps restart web2py. I know it sounds
silly, but they are quick test. cheers!
> On 2 Jun, 2017, at 7:07 pm, akshay05ku...@gmail.com wrote:
>
> hi Rudy,
>I am facing the same issue. Did you get
44 matches
Mail list logo
