Field('Account', 'reference CoA',
requires=IS_IN_DB(db, 'CoA.id', '%(Name)s', orderby=db.CoA.Name)),
To me, it looks like you are using "name" to reference the COA, instead of
the ID.
http://www.web2py.com/books/default/search/29?
Ok, moving it to static makes it work fine. It was in view/default
Any IDEAS on what / why this works this way ?
Thanks ...
*Ben Duncan*
DBA / Chief Software Architect
Mississippi State Supreme Court
Electronic Filing Division
On Wed, Jun 5, 2019 at 9:51 PM Dave S wrote:
>
>
> On
Ajax is not a programming language
AJAX
AJAX IS A technique for accessing webs ervers from a web page
AJAX stands for ASYNCHRONOUS Javascript and XML/JSON
*Ben Duncan*
DBA / Chief Software Architect
Mississippi State Supreme Court
Electronic Filing Division
On Wed, Jun 5, 2019 at 5:30 AM
I've been trying to run it ... When you click on the button it does nothing
*Ben Duncan*
DBA / Chief Software Architect
Mississippi State Supreme Court
Electronic Filing Division
On Tue, Jun 4, 2019 at 4:35 PM Anthony wrote:
> What are you trying to do? That code should work fine i
&& this.status == 200) {
document.getElementById("demo").innerHTML =
this.responseText;
}
};
xhttp.open("GET", "ajax_info.txt", true);
xhttp.send();
}
The question is how do I get this code to run under web2py ?
Thanks ...
*Ben
ng (Extensive Client / Server
experience - bu no REAL web development)
The good news, Is all of the DB side of stuff is designed.
*Ben Duncan*
DBA / Chief Software Architect
Mississippi State Supreme Court
Electronic Filing Division
On Tue, Apr 9, 2019 at 7:43 PM pollwerk wrote:
> There is also s
Thanks DUH, I guess looking at it since 6 AM this morning was not good for
MY brain cells.
Anyway, thanks again ...
*Ben Duncan*
DBA / Chief Software Architect
Mississippi State Supreme Court
Electronic Filing Division
On Tue, Apr 9, 2019 at 10:39 AM Anthony wrote:
> Get rid of the
I have the following file i would like to put in a .js file.
When I've tried in the past I get the "not a text/javascript" , "failed to
load" error message.
I know how to do the src="{{=URL('static','js/swal/swalerror.js')}}" >
stuff.
How would I go about doing this ?
Thanks ...
Could you not use:
*session.resultsARE= *
*to save it an reuse it and pass during the whole session ?*
*Ben Duncan*
DBA / Chief Software Architect
Mississippi State Supreme Court
Electronic Filing Division
On Wed, Mar 27, 2019 at 1:42 PM Anthony wrote:
> It's not quite clear
using 2.18? 🤔
*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
Will do ...
*Ben Duncan*
DBA / Chief Software Architect
Mississippi State Supreme Court
Electronic Filing Division
On Sun, Mar 3, 2019 at 2:06 AM Massimo Di Pierro
wrote:
> No. this is indeed stange. Can you please open a ticket about this?
>
> On Friday, 1 March 2019 04:30:37 U
Ok further testing* REVELS* that if the module begins with 'test',
cutome_import chokes and pukes.
Named it to bensmodule and it works ...
*Massimo*, is that expected behavior ?
*Ben Duncan*
DBA / Chief Software Architect
Mississippi State Supreme Court
Electronic Filing Divisio
raise # there is an error in the module
finally:
if import_tb:
Variables
builtinImportError
e1 ImportError('No module named testmod',)
import_tb None
Context
locals request session response
In file: /data/web2py/web2py/applications/Book/controllers/
Dave: Yes same level.
Paul will try deleting the pyc files ...
*Ben Duncan*
DBA / Chief Software Architect
Mississippi State Supreme Court
Electronic Filing Division
On Fri, Mar 1, 2019 at 12:26 AM Paul Ellis wrote:
> I know this sounds odd. But this worked for me recently. It can be cau
ImportError('No module named Book.modules.testmod',),
)
Error snapshot [image: help]
<https://10.13.70.47/admin/default/ticket/Book/10.13.69.144.2019-02-28.13-47-50.cf8b0622-c9d2-457d-be0d-93c11fb1251c#>
((ImportError('No module named
Book.modules.testmod',), ))
*Ben
sword" error message
go back Display Login page:
else # Forms did not pass validation ...
go back Display Login page:
That's the flow I'm used to using in CS software ...
Thanks ...
*Ben Duncan*
DBA / Chief Software Architect
Mississippi State Supreme Court
Electr
user had '0' in the company or was a super admin, it would do the
popup for company (Court)
Make sense ?
*Ben Duncan*
DBA / Chief Software Architect
Mississippi State Supreme Court
Electronic Filing Division
On Wed, Feb 27, 2019 at 2:51 AM Val K wrote:
> Hard to understand the wor
in_form, FRM_ERR=FRM_ERR, js_args=js_args,
CHOOSE_COMPANY=CHOOSE_COMPANY)
I'm trying to accomplish 2 things:
A: get some value backup from the javascript file and
instead of the "return" under the accepted section of controller code, want
to set
a session value and then continue on to
Ok thanks:
Looking to pass to the javascript something like this:
{ 2: "Third Company", 5: "Number 5 Company", 13: "Lucky 13 Company"}
It is to create a selection list that returns the number (2, 5, 13 ,etc
...) but shows the
company name
Thanks
*Ben Duncan*
I don't want the array, just the dictionary
*Ben Duncan*
DBA / Chief Software Architect
Mississippi State Supreme Court
Electronic Filing Division
On Mon, Feb 25, 2019 at 11:17 AM Leonel Câmara
wrote:
> What do you mean? You already have a javascript array of javascript dicts.
>
quot;: 2, "company_name": "Third Company"},
{"company_number": 5, "company_name": "Number 5 Company"},
{"company_number": 13, "company_name": "Lucky 13 Company"}];
I need to have this list changed to a Javascript dict for
uot;/data/web2py/web2py/gluon/globals.py", line 16,
in
[Mon Feb 25 07:13:25.950056 2019] [wsgi:error] [pid 48880] [remote
10.13.69.144:49224] from gluon._compat import pickle, StringIO,
copyreg, Cookie, urlparse, PY2, iteritems, to_unicode, to_native, \\
[Mon Feb 25 07:13:25.950185 20
On the first ...:
1.255,76is invalid as there are no commas AFTER decimal places.
As far as the latter, I am not sure. Could be a Python thing ...
*Ben Duncan*
DBA / Chief Software Architect
Mississippi State Supreme Court
Electronic Filing Division
On Sat, Feb 23, 2019 at 9:48 PM Cristian Re
Are you trying to join to db's ?
If not, then try :
ROW = db(db.lugar.user_id == auth.user['id']).select()
or
ROW = db.lugar[auth_user['id']]
See:
http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Shortcuts
*Ben Duncan*
DBA / Chief Software Ar
Ok, got it
Thanks a lot ..
*Ben Duncan*
DBA / Chief Software Architect
Mississippi State Supreme Court
Electronic Filing Division
On Thu, Feb 21, 2019 at 3:53 AM Val K wrote:
> You can use conditional rendering in the view like a following:
> {{if 'js_args' in response._vars:}}
>
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
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
, 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
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:
>
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
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
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
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
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
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,
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
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
- 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
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?
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
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
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
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
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
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
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
;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),
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:
>>
..
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
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
--
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
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
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
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
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
# ---
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
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
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
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
#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
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*
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
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
;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
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
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
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
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
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
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
*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
if auth.user['company_number'] == 0:
redirect(URL('company_choose'))
else:
redirect(URL('index'))
return dict()
view/default/user_bar.html
{{extend 'layout.html'}}
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
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
/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
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
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
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:
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
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
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
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:
-
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
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
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
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
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
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
;
<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
)
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
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
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
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
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
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:
>
>
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
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
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
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
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
1 - 100 of 125 matches
Mail list logo
