[web2py] Re: mssql legacy tables reference

'reference Mjesta.PostanskiBroj'* should be *'reference PostanskiBroj' *but I would not swear by references for legacy keyed tables.* On Thursday, 25 September 2014 11:58:21 UTC-5, Alen Cerovic wrote: > > Hi, > > I am totaly new to web2py, actually started yesterday :) > I am trying to work with

[web2py] Re: limit number of boolean choices in form

This may be better handled via JS http://stackoverflow.com/questions/19001844/how-to-limit-the-number-of-selected-checkboxes On Thursday, 25 September 2014 10:08:39 UTC-5, Nir Firestein wrote: > > hey, > > web2py newbies here :) > we want to create a form with multiple boolean options (say, choos

[web2py] mssql legacy tables reference

Try just using the table name without the field. -- 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 t

[web2py] Re: web2py meetup with Massimo in north Bay Area

I'm in. -- 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. T

[web2py] web2py as a separate admin process?

I am working on a web2py application to help with FreeBSD system administration. Although my main web2py system will run with Nginx and uWSGI on this server, I would like my admin app to run independently of these as I would use the admin application to manage these configurations and a bad con

Re: [web2py] Re: Deploy Web2py on Windows Server 2008 VPS on godaddy

I am battling with getting it to work on IIS right now, but not by choice. You can run web2py on rocket but this is a small scale solution. I found that it was not stable with SSL, plus it doesn't have multiprocessing support. I would avoid Windows unless you have a particular reason (in my cas

[web2py] Re: IIS help with permissions

On Friday, September 26, 2014 2:01:36 PM UTC-7, Tim Richardson wrote: > > Through a lot of tedious testing to web2py's logging, it boils down to > this: > the python tar extraction libary (tarfile.py) dies when trying to extract > a file ending in .py > Firing from the hip: does the extractio

Re: [web2py] Re: Controller to do SOAP to an action-less service, how to generate the (xml) nodes

On Friday, September 26, 2014 1:49:18 PM UTC-7, Mariano Reingart wrote: > > "Raw" calls are supported (using SimpleXMLElement objects), attached is an > example > Thank you! I'll let you know how it goes. Dave /dps -- Resources: - http://web2py.com - http://web2py.com/book (Documentation)

[web2py] Re: foreign key constraint failed

This post on StackOverflow may help http://stackoverflow.com/questions/9636053/is-there-a-way-to-get-the-constraints-of-a-table-in-sqlite There is a code snippet you might try. On Monday, September 22, 2014 5:01:11 PM UTC-4, Anna Kostikova wrote: > > Hi everyone, > > I am having an issue when ed

[web2py] Re: Javascript in web2py view

First thing, read up on the ajax functionality in Web2py. It's way simpler than jQuery ajax and will work just fine for what you want to do.l Consider using the ":eval" target in Web2py ajax. It will allow you to send JavaScript snippets back to the server. That way you can do things like this

Re: [web2py] Re: Deploy Web2py on Windows Server 2008 VPS on godaddy

Sorry, no can help. On Friday, September 26, 2014 6:12:06 AM UTC-4, Viren Patel wrote: > > Hi Cliff, > > Actually i have already done investment in Server with godaddy for a year > > Let me know if you have done web2py with Windows > > Regards, > Viren > > On Thu, Sep 25, 2014 at 8:57 PM, Cliff Ka

[web2py] Re: IIS help with permissions

Through a lot of tedious testing to web2py's logging, it boils down to this: the python tar extraction libary (tarfile.py) dies when trying to extract a file ending in .py This only happens when IIS owns the process and is not related in any obvious way to file permissions. The script happily cre

Re: [web2py] Re: Controller to do SOAP to an action-less service, how to generate the (xml) nodes

"Raw" calls are supported (using SimpleXMLElement objects), attached is an example Are you using an updated web2py? You should have to debug and see if it is going thru line 193 of gluon.contrib.pysimplesoap.client: if parameters and isinstance(parameters[0], SimpleXMLElement): If it is

Re: [web2py] Re: Controller to do SOAP to an action-less service, how to generate the (xml) nodes

I've let this sit for a while because it is definitely less urgent than some of the other stuff I'm working on, but I'm still interested in the answer and how to talk to this odd target. /dps On Tuesday, August 12, 2014 4:00:24 PM UTC-7, Dave S wrote: > > Hmmm, I'm not quite there yet. > > >

[web2py] Re: to date should be greater than thr from date field

Use onvalidation to check it. Otherwise it's easy to do your own IS_GT_THAN (based on IS_EQUAL_TO). The catch is that you will have to set the validator in the field requires only in your controller so you have accesss to vars. Something like. db.table.date_two.requires = IS_GT_THAN(request.

[web2py] Re: how to know the reason for mail.send failure in code

I don't know what the problem is but have you tried putting the domain that will be emailing in mail.settings.hostname? I usually manually test when I have these problems. Example of a manual test for a server using TLS in the python command line: >>> server = smtplib.SMTP('yourdomain.com', 58

[web2py] Re: Unable to connect to MSSQL via web2py - SSL Security Error

I believe it's a problem in bbfreeze. But I must do additional tests for it. -- 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 bec

[web2py] Re: Bug? request.vars not set by routes_in query string.

Ticket opened: http://code.google.com/p/web2py/issues/detail?id=1990 On Friday, September 26, 2014 10:48:13 AM UTC-4, Massimo Di Pierro wrote: > > bug. please open a ticket so we track it and fix it. > > On Thursday, 25 September 2014 16:45:19 UTC-5, Jim Karsten wrote: >> >> I am setting a query

[web2py] Re: Bug? request.vars not set by routes_in query string.

bug. please open a ticket so we track it and fix it. On Thursday, 25 September 2014 16:45:19 UTC-5, Jim Karsten wrote: > > I am setting a query string in routes_in but the request.vars is not > getting set. To replicate: >

[web2py] Re: Unable to connect to MSSQL via web2py - SSL Security Error

Can t believe it, it did the trick :) yes I am using binaries on windows 7 64bit. Can you explain me what is going on, thnx Dana srijeda, 24. rujna 2014. 21:07:28 UTC+2, korisnik Niphlod napisao je: > > I know I'm asking a strange thing, but are you using web2py binaries or > source code ? > If

[web2py] Javascript in web2py view

I have this script that I've used with PHP and it works, but I'm moving everything from PHP to Web2PY easy to deploy to coworkers. PHP page (I left out the PHP part of the code that makes a REST API call to an appliance) Get Current Running Config https://ajax.googleapis.com/ajax

[web2py] Re: Return only shows one value

I solved it by using doing the following: def show(): import requests import json url = "https://10.10.10.10/api/2.6/"; object_type = "config_templates/index" data = requests.get(url + object_type, verify=False, auth=('user', 'password')) json_input = data.text try:

[web2py] to date should be greater than thr from date field

Hey, I have 2 date fields in my table and i want the second date field value to be greater than the first date field..please suggest the validator i should be using for this. thank you -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (

[web2py] mssql legacy tables reference

Hi, I am totaly new to web2py, actually started yesterday :) I am trying to work with legacy mssql database and having problems in referencing two legacy keyed tables db.define_table('Mjesta', Field ('PostanskiBroj', 'integer',notnull=True,unique

[web2py] limit number of boolean choices in form

hey, web2py newbies here :) we want to create a form with multiple boolean options (say, choosing X species from a list of Y species), but we want to limit X, so that after you check that certain number of options, you won't be able to select more. We'd appreciate the help because so far we've

[web2py] how to know the reason for mail.send failure in code

mail.send() returns boolean to indicate whether sending was successful or not, but how can I get the reason for failure in code. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/l

Re: [web2py] Re: Web Editor Blank Screen

Hi, upgraded through the admin console. will check the user/file ownership but but think I recall them being the same when I checked file permissions. Thanks for the help On Wed, Sep 24, 2014 at 6:16 PM, Leonel Câmara wrote: > How did you upgrade web2py? Is the nginx's user the same as the fil

[web2py] Limit number of selections in sqlform

hey, web2py newbies here :) We want to create a form that has a number of boolean fields to select from, but we wish to limit the number of selections possible, so that after x selections, no more selections will be avaiable. We'd appreciate the help. Also, is there a way to give a "sub-headlin

[web2py] Re: IIS help with permissions

Just as a suggestion since I run into this on our corporate windows network, you don't have by chance some security system (i.e. virus scanner or other) that could be preventing the folder creation? Ours seems to block all sorts of things - can't create files over a certain size threshold, dbs

Re: [web2py] Re: Deploy Web2py on Windows Server 2008 VPS on godaddy

Hi Cliff, Actually i have already done investment in Server with godaddy for a year Let me know if you have done web2py with Windows Regards, Viren On Thu, Sep 25, 2014 at 8:57 PM, Cliff Kachinske wrote: > Viren, > > There are better hosting solutions available. Pythonanywhere, for example, >

[web2py] Re: Edit previous/next record from /edit view in sqlform.grid after update

Grid hasn't something like that. You'd need to code it yourself. On Friday, September 26, 2014 5:24:32 AM UTC+2, D.P. wrote: > > I have a large table with large amounts of text that is displayed through > sqlform.grid. I want to be able to click the 'edit' link for a record from > the sqlform.g

[web2py] Re: search with like/contains & case sensitive

DAL doesn't do any magic, it just passes along commands (that you can inspect in various ways, such as db._lastsql or using _select() instead of select()). You'll have to fiddle with your own database collation to make SELECT field FROM table WHERE LOWER(field) LIKE '%whatyouwant%' returns the