[web2py] Issues getting web2py to work.

2018-07-24 Thread Ben Duncan
kages/dal/pydal/objects.py", line 385 return [{key: noncallable(getattr(field, key)) for key in keys} Any Ideas ? Thanks Ben Duncan ^ -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/we

Re: [web2py] Re: Issues getting web2py to work.

2018-07-25 Thread Ben Duncan
ony > > > On Tuesday, July 24, 2018 at 4:03:13 PM UTC-4, Ben Duncan wrote: >> >> Redhack 6.9 >> Python 2.6.6 >> >> Installed web2py source. >> Ran the command: >> >python web2py.py >> got the message: >> >> Traceback (most recent

Re: [web2py] Re: web2py 2.17.1

2018-08-07 Thread Ben Duncan
Installed it and it's up whilst I learn it ... On Tue, Aug 7, 2018 at 9:29 AM 黄祥 wrote: > configuration.take() no longer worked > *e.g.* > *private/appconfig.ini* > [app] > toolbar = false > > *models/db.py* > response.show_toolbar = configuration.take('app.toolbar') # not worked > while in

[web2py] Changing Login Defaults

2018-08-08 Thread Ben Duncan
ct) and our own authentication methods. Is it possible to modify and where/how would we do this to change the "login" methods? Thanks Ben Duncan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google

Re: [web2py] Re: Changing Login Defaults

2018-08-08 Thread Ben Duncan
> Anthony > > On Wednesday, August 8, 2018 at 11:30:26 AM UTC-4, Ben Duncan wrote: >> >> I've been doing some playing around with the sample applications. >> >> I've notices they all use tables "auth_user", "auth_group", etc. >> >

[web2py] Using DAL / existing Databases

2018-09-17 Thread Ben Duncan
- can this be automated as well? Thanks In advance - Ben Duncan Sample - Accounts Receivable Open Item File: # Generator Parameters: # : = End Type of field , '|' = Field seperators # # FILE = Table Name to generate # ENDFILE - End of Table Defination # DESC - Descriptive Information

[web2py] Submitting fixes

2018-09-24 Thread Ben Duncan
I've found some errors in extract_pgsql_models.py and have fixed them. How to do I go about submitting the updated program for inclusion repos (asking for etiquette sake )? I'm not quite thru with the update yet, since I need to fix it to handle FK's with multiple key parts. Tha

[web2py] DAL and Foreign Keyes

2018-09-24 Thread Ben Duncan
will DAL allow multiple foreign keys on a legacy database table? i.e. : Table called item_purchased needs to have a FK to customer table as well as item table and even possibly GL COA table Thanks ... Ben Duncan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation

[web2py] DAL with multiple foreign keyes

2018-09-24 Thread Ben Duncan
on only fk. Is this true? Is there some way to work around this if it is true? Thanks Ben Duncan -- 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 re

Re: [web2py] Re: DAL with multiple foreign keyes

2018-09-24 Thread Ben Duncan
It's more about optimization of underlying key structure and the btree access. Having the Primary key "company + customer" are faster because the optimizer can have a start point. I could do secondary key with COMPANY , but then the optimizer has to go thru a different set of routines. In this sys

Re: [web2py] Re: DAL with multiple foreign keyes

2018-09-24 Thread Ben Duncan
Ok, thanks .. will think of another way to do this .. On Mon, Sep 24, 2018 at 4:58 PM Leonel Câmara wrote: > Nope the DAL and web2py does not support this. > > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > - h

[web2py] Foreign Keyes and DAL .. again.

2018-09-25 Thread Ben Duncan
rors as they occur . IS this a correct line of reasoning ? Thanks Ben Duncan -- 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 messa

[web2py] GITHUB and my updates

2018-10-03 Thread Ben Duncan
e to the web2py project. In the coming days/weeks/months i will be uploading a TOTAL ERP Postgres Template layout for tables that meets or exceeds GAPP requirements. I's based upon the 40+ years of commercial and open source systems that i've worked on. That is if anyone is intere

Re: [web2py] Help needed with web2py-book app

2018-10-11 Thread Ben Duncan
1})'".format(f['precision'],f['scale']) And so one. The changes work across Python 2.7 and 3.6 seamlessly now ... FWIW, I'm just making the transition to Python 3,6 so I'm learning things the hard way ... Ben Duncan On Wed, Oct 10, 2018 at 4:02 PM Nico Za

Re: [web2py] Help needed with web2py-book app

2018-10-11 Thread Ben Duncan
n for the encoder, while on PY3 it is mandatory. > > I'm still learning, too ;-) > Nico > > > Il giorno gio 11 ott 2018 alle ore 16:16 Ben Duncan > ha scritto: > >> Exactly what are you running into? >> >> I ran into this with my rewrite of of extract

Re: [web2py] Help needed with web2py-book app

2018-10-11 Thread Ben Duncan
Also found this: http://python-future.org/compatible_idioms.html On Thu, Oct 11, 2018 at 10:30 AM Ben Duncan wrote: > Try These suggestions: > > > https://stackoverflow.com/questions/491921/unicode-utf-8-reading-and-writing-to-files-in-python/83 > http://www.evanjones.ca/p

[web2py] DAL and DB VIEWS

2018-10-29 Thread Ben Duncan
Is it possible to use predefined Postgres views inside of DAL? By views i mean (SQL code) CREATE VIEW myview AS select .. from tablea, tableb WHERE .. ); Thanks Ben Duncan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py

Re: [web2py] Re: DAL and DB VIEWS

2018-10-29 Thread Ben Duncan
I'm thinking it should be no different than defining a table, since these are all external / predefined tables. The difference is that Postgres handles the sql and I'm guessing with DAL, it's just data returned. Ben Duncan On Mon, Oct 29, 2018 at 12:14 PM 黄祥 wrote: > had you

Re: [web2py] Re: DAL and DB VIEWS

2018-10-29 Thread Ben Duncan
Ok, found the answer ... https://groups.google.com/forum/#!topic/web2py/DCsnCkQnIoA On Mon, Oct 29, 2018 at 12:27 PM Ben Duncan wrote: > I'm thinking it should be no different than defining a table, since these > are all external / predefined tables. > The difference is that Po

[web2py] Which is correct in DAL?

2018-10-31 Thread Ben Duncan
, . But the extract_pgsql_models.py does a version like this: db.define_table('gl_chart', Field('company_number', type='reference company', ondelete='CASCADE'), Field('gl_account_num', type='string', length=20), ...

Re: [web2py] Re: off topic: pg_dump syntax for pythonanywhere

2018-11-05 Thread Ben Duncan
/pgdump.sql ${PGDATABASENAME} There are myriad ways to do pg_dump - local host, server to server ...etc.. IF you can tell me exactly what you are trying to do, I can help ... Ben Duncan DBA / Chief Software Architect Ms State Supreme Court On Sun, Nov 4, 2018 at 7:25 PM Alex Glaros wrote

[web2py] Issues using pydal

2018-11-05 Thread Ben Duncan
ng', length=20), Field('zip', type='string', length=10), Field('country', type='string', length=255), primarykey=['company_number'], migrate=False) sys.exit(0); -

Re: [web2py] Issues using pydal

2018-11-05 Thread Ben Duncan
Ok, thanks ... JUST figured that out Is there any OTHER classes I need to include or just those 2 ? Thanks ... *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Mon, Nov 5, 2018 at 11:52 AM Roberto Perdomo wrote: > You for

[web2py] Custom Auth module

2018-11-08 Thread Ben Duncan
I need to have a custom authentication module - mainly pointing to and using my own auth_user and auth_group tables Which modules from the base (welcome) do I need to change or what documentation do i need to read up on on how to do this ... Thanks *Ben Duncan* DBA / Chief Software Architect

Re: [web2py] Re: Custom Auth module

2018-11-08 Thread Ben Duncan
Great! The second part about defining (not recommend) is what I need However, I will be interfacing with external applications and predefined tables, so that should work out just fine. I can add the rest of the "Auth" tables to my external definitions (Postgres) *Ben Duncan* D

[web2py] Issue with pydal - default

2018-11-09 Thread Ben Duncan
ow), Field('expire', type='datetime'), Field('machine_id', type='string', length=255), Field('browser_session', type='integer'), Field('server_session', type='integer'), primarykey=['company_numb

Re: [web2py] Re: Issue with pydal - default

2018-11-10 Thread Ben Duncan
Ok, great thanks ... *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Fri, Nov 9, 2018 at 2:19 PM Dave S wrote: > > > On Friday, November 9, 2018 at 5:31:18 AM UTC-8, Ben Duncan wrote: >> >> Ok, I'm checking my

[web2py] Migrations

2018-11-20 Thread Ben Duncan
Is it necessary to enable or even do migrations in the DAL (creating database/ entries) if the database and the tables are already preexisting ? Thanks ... *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division -- Resources: - http://web2py.com

Re: [web2py] Re: Migrations

2018-11-21 Thread Ben Duncan
I tried enable fake migrations (Backend has tables), nothing was created in databases, but everything works as it should .. *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Tue, Nov 20, 2018 at 4:20 PM Dave S wrote: > > > O

Re: [web2py] Re: Migrations

2018-11-21 Thread Ben Duncan
t works that way and these are external tables. Anyone see any problems with that ? Thanks ... *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Wed, Nov 21, 2018 at 6:57 AM Ben Duncan wrote: > I tried enable fake migrations (Backe

Re: [web2py] Re: Migrations

2018-11-26 Thread Ben Duncan
external" table, whcih is just as well, since I will have to dove tail this with a e-filing systems at some point. Thanks again ... *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Wed, Nov 21, 2018 at 3:35 PM Dave S wrote: > >

Re: [web2py] Re: Hierarchy (BOM) using closure table with triggers in DAL?

2018-11-26 Thread Ben Duncan
What database are you using ? In our e-file system, we have something similar with court cases, but we use db functions to do the heavy lifting for use, since in postgres they can be called with a select directly ... *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court

Re: [web2py] Re: Migrations

2018-11-27 Thread Ben Duncan
Newbie .. *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Tue, Nov 27, 2018 at 1:02 PM Dave S wrote: > > > On Monday, November 26, 2018 at 4:42:10 AM UTC-8, Ben Duncan wrote: >> >> Thanks Dave !!! >> >> That

Re: [web2py] Unable to display dropdown lists in forms

2018-12-04 Thread Ben Duncan
I was working on trying to figure out the EXACT same thing ! Thanks .. *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Tue, Dec 4, 2018 at 6:40 AM Arindam Dasgupta wrote: > Hi, > I need to display a drop down list in my fo

Re: [web2py] Unable to display dropdown lists in forms

2018-12-04 Thread Ben Duncan
e.flash = 'form accepted' elif form.errors: response.flash = T('form has errors') return dict(form=form) In views/default/company_login.html : {{extend 'layout.html'}} {{=form}} - Ok, my NEXT question

[web2py] DAL issues ....

2018-12-06 Thread Ben Duncan
) session.company = request.vars['Company'] Company_ID = request.vars['Company'] DbRows = db(db.company.company_number==Company_ID).select(db.company.company_name).first() session.company_name = DbRows['company_name'] return dict(form=form) Thank

Re: [web2py] Re: DAL issues ....

2018-12-06 Thread Ben Duncan
; <https://10.13.70.47/admin/default/edit/Mec/controllers/default.py>, line 84, in company_login Co_Name = DbRows['company_name'] TypeError: 'NoneType' object has no attribute '__getitem__' As one can see , the Row item exists, it just seems there is no w

Re: [web2py] Re: DAL issues ....

2018-12-06 Thread Ben Duncan
DbRows['company_name']) >>> DbRows['company_name'] 'Number 5 Company' >>> session.company_data = DbRows >>> type(DbRows['company_name']) >>> print session.company_data['company_name'] Number 5 Company >>>ty

Re: [web2py] DAL issues ....

2018-12-06 Thread Ben Duncan
pany"."company_number" IS NOT NULL) ORDER BY "company"."company_name", "company"."company_number"; < 2018-12-06 14:18:35.485 CST SessId: 5c0981bd.6e70 TrxId: 0>LOG: statement: SELECT "company"."company_name" FROM "co

Re: [web2py] DAL issues ....

2018-12-06 Thread Ben Duncan
mpany_name = DbRows.company_name Allowed me to PASS unharmed and get what I needed. THANKS Again, group .... . *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Thu, Dec 6, 2018 at 2:21 PM Ben Duncan wrote: > The request.vars get set

Re: [web2py] DAL issues ....

2018-12-06 Thread Ben Duncan
company_name session.company_ap_aging = DbRows. return dict(form=form) The reason I need this setup is that this is the Company Record that controls all aspects of the system (see ap_apaging_days). It also controls what sub-apps are on and off ... *Ben Duncan* DBA / Chief Software Ar

[web2py] login_bare not working

2018-12-11 Thread Ben Duncan
n empty web page that says "None" What do i need to do to get login_bare to work ? Thanks ... *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division -- Resources: - http://web2py.com - http://web2py.com/book (Documentat

Re: [web2py] Re: login_bare not working

2018-12-11 Thread Ben Duncan
tr__ at line 109* code arguments variables Function argument list (self=, k='id') Code listing 104. 105. 106. 107. 108. 109. 110. 111. 112. 113. def __getattr__(self, k): try: return self.__getitem__(k) ex

[web2py] Where does it GO?

2018-12-12 Thread Ben Duncan
If you put a "print" statement in you application (controller or view) where does the output go? (such as 'print "Testpoint 1") Thanks .. *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division -- Resources: -

Re: [web2py] Where does it GO?

2018-12-12 Thread Ben Duncan
Ok, thanks .. *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Wed, Dec 12, 2018 at 9:36 AM Christian Varas wrote: > It goes to the console where web2py is running or in the error logs of > apache or nginx if you are running web

[web2py] Bug in tools.py

2018-12-12 Thread Ben Duncan
string.method Shouldn't there be a "import string" after the def login_bare ? Thanks. *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.co

[web2py] lgoin_bare WTF???

2018-12-12 Thread Ben Duncan
are, is that all it is suppose to do is check that the user exists in the auth_user file. Is this not true ? Thanks ... *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division -- Resources: - http://web2py.com - http://web2py.com/book (Documentati

Re: [web2py] Re: Bug in tools.py

2018-12-12 Thread Ben Duncan
Ok, got it fixed. WAS too busy studying the forest of code to notice my mistake . The "or not" threw me Thanks ... *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Wed, Dec 12, 2018 at 1:08 PM Marcelo Huerta wrote:

Re: [web2py] lgoin_bare WTF???

2018-12-12 Thread Ben Duncan
Yes, I wanted to just use the auth_table. Everything else is controlled outside of the normal mechs .. Thanks *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Wed, Dec 12, 2018 at 4:09 PM Anthony wrote: > login_bare() is intended to

Re: [web2py] DAL reference to table define after

2018-12-13 Thread Ben Duncan
c... primarykey=['company_number','client_number'], migrate=False) If you try and use a "reference" to both table "A" and to table "B", you will get an error. DAL only allows a singular (one) reference table. I hope this helps and

Re: [web2py] How do I import Libraries in Web2py

2018-12-13 Thread Ben Duncan
/tutorial/modules.html Hope this helps ... *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Thu, Dec 13, 2018 at 9:57 AM Arindam Dasgupta wrote: > Hi, > > I have a general question in my mind that how do I import a library in

Re: [web2py] lgoin_bare WTF???

2018-12-13 Thread Ben Duncan
y. Now looking at the ACCESS CONTROL stuff, we are really a flipped version of that - GROUP and MEMBERSHIP before and controlling the auth_user.as well as company id in the group and membership/permission file.signifying what court the have jurisdiction to use. (Phew). I hope I haven't tot

Re: [web2py] lgoin_bare WTF???

2018-12-13 Thread Ben Duncan
Ok, thanks, will revisit it. I was getting insert errors from it before. Maybe my ignorance ... *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Thu, Dec 13, 2018 at 2:14 PM Anthony wrote: > Got it, but I don't see lo

Re: [web2py] lgoin_bare WTF???

2018-12-13 Thread Ben Duncan
if auth.user['company_number'] == 0: redirect(URL('company_choose')) else: redirect(URL('index')) return dict() view/default/user_bar.html {{extend 'layout.html'}}

Re: [web2py] lgoin_bare WTF???

2018-12-13 Thread Ben Duncan
*Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division Argg ... spoke to soon : Errors : web2py™ Version 2.17.2-stable+timestamp.2018.10.06.18.54.02 Python Python 2.7.13: /usr/bin/python (prefix: /opt/rh/python27/root/usr) Traceback 1. 2. 3. 4. 5

Re: [web2py] lgoin_bare WTF???

2018-12-13 Thread Ben Duncan
eld('modified_by', type='string', length=50), Field('notes', type='text'), primarykey=['group_id'], migrate=False) SO (Correct me if I am wrong) it's trying to use the "self.user.id" which is not defined, since these are cuto

[web2py] Issue with login_bare and custom tables

2018-12-14 Thread Ben Duncan
base try other login methods for login_method in self.settings.login_methods: if login_method != self and login_method(username, password): self.user = user return user return False Thanks .. *Ben Duncan* DBA / Chief Software Architec

Re: [web2py] How do I import Libraries in Web2py

2018-12-14 Thread Ben Duncan
https://help.pythonanywhere.com/pages/InstallingNewModules/ You will have to use a bash console ... *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Fri, Dec 14, 2018 at 10:10 AM Arindam Dasgupta wrote: > Hi, > I am takling abo

Re: [web2py] Re: Issue with login_bare and custom tables

2018-12-16 Thread Ben Duncan
Ok, Anthony will do. My question is should i put my new functions in "modules" or under "controllers" ? Thanks *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Fri, Dec 14, 2018 at 5:56 PM Anthony wrote: > This

Re: [web2py] Re: Issue with login_bare and custom tables

2018-12-17 Thread Ben Duncan
The new authentication functions I will be writing ... But, Reading in the book under API, it looks like the will go in modules since the will get imported (using the import) first before the default stuff ... *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic

Re: [web2py] what is the webserver software of pythonanywhere

2018-12-19 Thread Ben Duncan
SEE: https://www.pythonanywhere.com/forums/topic/2776/ *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Wed, Dec 19, 2018 at 3:15 AM Arindam Dasgupta wrote: > Hi, > > I need to have a ssl certificate for my webserver. So

Re: [web2py] Happy New Year

2019-01-07 Thread Ben Duncan
;m going to break by doing so ... *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Mon, Jan 7, 2019 at 9:58 AM António Ramos wrote: > 5) admin were a simpler vue.js app. +1!!! dont forget vuex !! > > Em qui, 3 de jan de 2019 às

Re: [web2py] Re: Different layout.html

2019-01-15 Thread Ben Duncan
px ; padding-left: 70px ; font-size: 18px ; border: 8px solid black; } /* End of CSS */ *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Tue, Jan 15, 2019 at 6:56 AM wrote: > You can take any bootstrap html template and

Re: [web2py] demo apps on website broken

2019-01-31 Thread Ben Duncan
I'm still getting it ... *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Thu, Jan 31, 2019 at 3:22 PM Nico Zanferrari wrote: > Hi, > > this is working now from here ... > > Nico > > Il giorno gio 31 gen 2019

[web2py] how do I Select in a FORM using a database.

2019-02-04 Thread Ben Duncan
Ok, I have a standard FORM doing a web page. How do you do a select from a a database table in a FORM helper: ie what is equivalent to the sqlform.factory of: Field('companyid', requires=IS_IN_DB(db,db.company.company_number,'%(company_name)s')), Thanks *Ben Duncan*

Re: [web2py] Re: how do I Select in a FORM using a database.

2019-02-05 Thread Ben Duncan
#SQLFORM-in-HTML Using IS_IN_DB doesn't work when included in the sqlform.factory ... *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Mon, Feb 4, 2019 at 3:44 PM Dave S wrote: > > > On Monday, February 4, 2019 at 9:32:02

[web2py] Clear a form after submit

2019-02-05 Thread Ben Duncan
What is the best way to clear a form in web2py after it has been submitted. Thanks *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py

Re: [web2py] Re: Clear a form after submit

2019-02-06 Thread Ben Duncan
Ok, I found the answer. It's by putting in the entry ' autocomplete="off" ' in the From my testing and sample, I probably, like you will be using the FORM construct for this project rather than the SQLFORM libraries ... *Ben Duncan* DBA / Chief Software Architect Missis

Re: [web2py] Re: how do I Select in a FORM using a database.

2019-02-06 Thread Ben Duncan
SQL COMPANY INFO 2: ID - %i Name: %s" % ( comp.company_number, comp.company_name) }} '{{=comp.company_name}}' {{pass}} *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Tue, Feb 5, 2019 at 5:30 PM Dave S wro

Re: [web2py] Accessing MySQL data without define tables

2019-02-08 Thread Ben Duncan
migrate=False) ------- For each table you want to access, you will need a "db.define_table" entry in the model directory. Hope this helps *Ben Duncan* DBA / Chief Software

Re: [web2py] Accessing MySQL data without define tables

2019-02-11 Thread Ben Duncan
QUAL_TO, IS_INT_IN_RANGE, IS_LOWER, IS_MATCH, IS_NOT_EMPTY, \ # IS_NOT_IN_DB from pydal.objects import Table, Field, Row .... (and so on till I get to the bottom) # ------------- # Local application settings # ---

Re: [web2py] Accessing MySQL data without define tables

2019-02-11 Thread Ben Duncan
ry will generate the create table, primary keyes, secondary keyes, foreign keyes, grants and views. As part of the library it will generate the pydal "define" statements as well. *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Mo

Re: [web2py] Accessing MySQL data without define tables

2019-02-11 Thread Ben Duncan
If this script is being run OUTSIDE the web2py environment then you will need to include the define inside the python program itself. *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Mon, Feb 11, 2019 at 9:01 AM Jon Subscripted wrote

Re: [web2py] Accessing MySQL data without define tables

2019-02-11 Thread Ben Duncan
No , all you need is the db.define for the table you are going to access, unless there is foreign keyes involved. Then include the PARENT table if these are child tables. *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Mon, Feb 11, 2019

[web2py] Splitting form

2019-02-11 Thread Ben Duncan
appreciated Thanks ... *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division -- 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

[web2py] Over ride SQLFORM defaults

2019-02-11 Thread Ben Duncan
ord', requires=IS_NOT_EMPTY()), formstyle='divs', submit_button=' Submit ', ) _style as shown above is not accepted ... Thanks ... *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division --

Re: [web2py] Re: Splitting form

2019-02-11 Thread Ben Duncan
.. Thanks ... *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Mon, Feb 11, 2019 at 12:13 PM Ben Lawrence wrote: > You can use the FORM helper to add DIV elements. Or even add empty DIV > elements which you can fill in later with JS > on

Re: [web2py] Re: Splitting form

2019-02-11 Thread Ben Duncan
e-block; width:50%') > news_div = DIV('blah '*50, _style = 'display: inline-block;width:50%; > vertical-align:top;') > return dict(login_news = DIV(login_div, news_div)) > > > > On Monday, February 11, 2019 at 9:36:03 PM UTC+3, Ben Duncan wrote: >>

Re: [web2py] Accessing MySQL data without define tables

2019-02-12 Thread Ben Duncan
;integer'), Field('company_name', type='string', length=255), Field('address_1', type='string', length=255), Field('address_2', type='string', length=255), Field('city', type='string', length=255),

Re: [web2py] Re: Splitting form

2019-02-12 Thread Ben Duncan
Excuse my ignorance (Being a NEWBIE is irritating to me after having done CS stuff for 30+ years) But, Dave, exactly whats is turning on left-colum / right column support ? Thanks .. *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Mon

Re: [web2py] Re: Splitting form

2019-02-12 Thread Ben Duncan
Ok, got it thanks ... *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Tue, Feb 12, 2019 at 4:23 PM Dave S wrote: > > > On Tuesday, February 12, 2019 at 1:40:25 PM UTC-8, Dave S wrote: >> >> On Tuesday, Februar

Re: [web2py] Re: Migrate from sqlite to mysql

2019-02-13 Thread Ben Duncan
Yes it will create the db.define. *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Wed, Feb 13, 2019 at 1:55 PM Andrea Fae' wrote: > Hello! > I followed the instruction you wrote me. > But at that point:" load web2py

Re: [web2py] Re: Migrate from sqlite to mysql

2019-02-14 Thread Ben Duncan
Ok, is the python AND the mysql on the same windows BOX ? If not, could be a firewall issue. For the record, my python stand alone are truly stand alone (But I run LINUX , no Windowns here). So all my script are not thru the web2py but use the pydal library ... *Ben Duncan* DBA / Chief Software

[web2py] Run JAVA script in controller.

2019-02-14 Thread Ben Duncan
esponse.flash = 'form has errors' else: response.flash = 'please fill the form' Thanks ... *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division -- Resources: - http://web2py.com - http://web2py.com/book (Documenta

Re: [web2py] Re: Splitting form

2019-02-14 Thread Ben Duncan
Ok, I've gotten web2py working with the way I want. Part of the problem is is needed to have: then in the .html a formname assigned in the controller. Everything is now shiny again .... *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Div

[web2py] Weird behavior in sqlform / forms ...

2019-02-14 Thread Ben Duncan
8] Doing the process form testing ... [Thu Feb 14 11:36:25.925073 2019] [wsgi:error] [pid 29474] [remote 10.13.69.144:51788] Ok, What could I be doing wrong, or am I missing something critical here ? Thanks .. *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electron

Re: [web2py] Re: Weird behavior in sqlform / forms ...

2019-02-14 Thread Ben Duncan
Yes, in the view: Let me check my config for the CSRF token ... *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Thu, Feb 14, 2019 at 12:12 PM Leonel Câmara wrote: > How are you submitting this form?

Re: [web2py] Re: Weird behavior in sqlform / forms ...

2019-02-14 Thread Ben Duncan
- END OF VIEW ------- *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Thu, Feb 14, 2019 at 12:52 PM Leonel Câmara wrote: > Can I see the rest of the view? It seems yo

Re: [web2py] Mysql 8.0.15

2019-02-14 Thread Ben Duncan
Related possibly: https://stackoverflow.com/questions/45368336/error-keyerror-255-when-executing-pymysql-connect *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Thu, Feb 14, 2019 at 1:09 PM Andrea Fae' wrote: > Hello, I

Re: [web2py] Re: Weird behavior in sqlform / forms ...

2019-02-14 Thread Ben Duncan
to using in our state ... *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Thu, Feb 14, 2019 at 2:29 PM Val K wrote: > It seems you like handmade things;) > I don't see the closing tag - > Try to remove your ha

Re: [web2py] Re: Weird behavior in sqlform / forms ...

2019-02-15 Thread Ben Duncan
Ok, thanks VAL, that did the trick ... Where do you go to find such neat little things? *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Thu, Feb 14, 2019 at 2:46 PM Ben Duncan wrote: > Ok, will give it a shot tomorrow. > Yeah,

[web2py] Implementing sweetalert js into web2py

2019-02-15 Thread Ben Duncan
7;js/sweetalert2.all.js')) response.include_meta() response.include_files() }} So what Do I need to do next ? (Forgive please I'm just starting on the javascript side of things ...) Thanks .. *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Fili

Re: [web2py] Re: Implementing sweetalert js into web2py

2019-02-15 Thread Ben Duncan
Just call some if it's functions and pop ups ... *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Fri, Feb 15, 2019 at 1:23 PM Val K wrote: > You can open browser console (usually Ctrl+Shit+j) and try > Swal.fire('Hell

Re: [web2py] Re: Implementing sweetalert js into web2py

2019-02-15 Thread Ben Duncan
Ok, that works ... NOW what ? Can I incorporate it in the controllers ? *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Fri, Feb 15, 2019 at 1:32 PM Ben Duncan wrote: > Just call some if it's functions and pop ups ... > &g

Re: [web2py] Re: Implementing sweetalert js into web2py

2019-02-15 Thread Ben Duncan
Sorry, to sound like a newb on this. I've really been dealing with and into javascript for , um 36 hours now ? 😅 *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Fri, Feb 15, 2019 at 1:36 PM Ben Duncan wrote: > Ok, that works

Re: [web2py] Re: Implementing sweetalert js into web2py

2019-02-19 Thread Ben Duncan
WHoa H ! Thanks VAl that works *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Fri, Feb 15, 2019 at 2:39 PM Val K wrote: > > include arguments (that it should be json-serializable object) to pass to > js-co

Re: [web2py] Re: Migrate from sqlite to mysql

2019-02-20 Thread Ben Duncan
You mean character set UTF? Make sure environment variable set to UTF. Have had problems with Windows being NON UTF before. *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Tue, Feb 19, 2019 at 2:58 PM Andrea Fae' wrote: >

Re: [web2py] mysql import from csv problem

2019-02-20 Thread Ben Duncan
, or Phone number 2 You need to make sure all fields are accounted for in some way ... Hope this helps ... *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Tue, Feb 19, 2019 at 3:13 PM Andrea Fae' wrote: > Hello, when I imp

Re: [web2py] Re: Implementing sweetalert js into web2py

2019-02-20 Thread Ben Duncan
screwed up!", type = "error", confirmbutton = "Really?") print "LOGIN: RETURN Form ...\n" return dict(form=in_form, js_args=js_args) return dict(form=in_form) ------------------- Again, Thanks ... *Ben Duncan* DBA / Chief Sof

Re: [web2py] creating tables with web2py console and mysql

2019-02-20 Thread Ben Duncan
ture+release.+Please+consider+us *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Tue, Feb 19, 2019 at 11:51 PM Andrea Fae' wrote: > Hello, why I have this warning? > > c:\web2py>python web2py.py -S ga2 -M -P > web2py

  1   2   >