[web2py:29667] KPAX+FIREBIRD not work

2009-08-30 Thread shuval
Hello! I test KPAX+FIREBIRD. tablename and fieldname ('user','password','page','file') not create to database. May be rename tablename and fieldname... But this'is very much problem in scripts. May be edit sql.py where cleanup. Thanks for help. --~--~-~--~~~---~--

[web2py:29668] Re: KPAX+FIREBIRD not work

2009-08-30 Thread shuval
FIREBIRD 2.1.2 and web2py 1.66.2 . After renamed fieldname and tablename i registrated user and i input login and password but after error. Not insert ticket... On sqlite this application work. What is problem? Thank's for help Error traceback Traceback (most recent call last): File "/web2py_1

[web2py:29673] Re: KPAX+FIREBIRD not work

2009-08-31 Thread shuval
I decided problem!) I changed scripts tablenames and fieldnames to models, controllers and views (add 'q' examle 'userq') ! And edit db.py table ticket db.py db.define_table('ticket', SQLField('ctime','integer',default=now), SQLField('url','string', length=50,def

[web2py:31594] executesql

2009-09-24 Thread shuval
Hi! How use executesql for rows? controller def statistic(): results = dbstat.executesql("""select ip_user,strafb1,strafb3,sostname,site from ip_adm_hist('01.09.09', '30.09.09',0)""") return dict(results=results) view {{extend 'layout.html'}} {{for person in results:}} {{=person.ip_

[web2py:31598] Re: executesql

2009-09-24 Thread shuval
Thank's. How is this rows use in view SQLTABLE? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send e

[web2py:31601] Re: executesql

2009-09-24 Thread shuval
executesql2 http://web2py.com/AlterEgo/default/show/243 http://web2py.com/AlterEgo/default/show/234 For sqlite and mssql. I need executesql with args for firebird. Somebody decided this problem? Thank's help --~--~-~--~~~---~--~~ You received this message because

[web2py:31603] Re: executesql

2009-09-24 Thread shuval
I decided problem executesql2 for firebird controller results = dbstat.executesql2("""select orgname,ip_user,strafb1,sostname,site from ip_adm_hist(?,?,?) order by orgname""",['01.09.09','30.09.09',0]) --~--~-~--~~~---~--~~ You received this message because yo

[web2py:32071] Re: new cron

2009-10-01 Thread shuval
I tested crontab for Linux Gentoo web2py_1_67_2. message error in console WARNING:root:WEB2PY CRON Call returned code 1: No error message available --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py-users" group.

[web2py:32073] Re: new cron

2009-10-01 Thread shuval
def testme(): print "Hello" No messages in console. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this grou

[web2py:37647] nginx + web2py T3 application

2009-12-22 Thread shuval
http://istt-nsk.ru csstemplate in freecsstemplates.org spontaneous. I managed site T3 application. Database is Fiebird ( I changed in controllers/default.py and modules/t2.py field password to passwordq). nginx.conf server { listen istt-nsk.ru:80; server_name istt-nsk.ru;

[web2py:37722] Re: nginx + web2py T3 application

2009-12-22 Thread shuval
For Ahmed Soliman. I did not test, but i think it is not complicated. May be server { listen istt-nsk.ru:80; server_name istt-nsk.ru; access_log /var/log/nginx/ balder161.startdedicated.com.access.log; location / { set $fixed_destination $http_destin

[web2py:37723] Re: nginx + web2py T3 application

2009-12-22 Thread shuval
For Mengu. Yes of course. This is CMS. -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more opt

[web2py:37724] Re: nginx + web2py T3 application

2009-12-22 Thread shuval
For Alex Fanjul. I use nginx http-server without apache. What is problem frontend for statics files? T3 application upload/download statics files. -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@google

[web2py:37729] Re: nginx + web2py T3 application

2009-12-22 Thread shuval
Sorry. Site http://istt-nsk.ru did not work yesterday sometimes. I tested nginx to administrator interface web2py framework. Now Work! -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com.

[web2py:37802] Re: Happy Holidays

2009-12-24 Thread shuval
Happy New Year to all !) -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit th

[web2py:17862] Procedures and views in DB execute.

2009-03-11 Thread shuval
Hello!!! I'm interesting support procedures and views database in web2py. Work with tables is good, but for example my firebird database work with tables, procedures and views.I use kinterbasdb for this, but i hope web2py help me.) I'm trying make def() method for this in sql.py . Sorry за errors

[web2py:17915] Re: Procedures and views in DB execute.

2009-03-12 Thread shuval
I use executesql, but I don't now how work with resulte in form controllers. for example work with procedure test/controllers/default.py def index(): return dict(org=db.executesql('select name,code,empcnt from org_chart(100) where empcnt<>2')) test/default/index org:Max 100 1244

[web2py:17919] Re: Procedures and views in DB execute.

2009-03-12 Thread shuval
Thank you very much!!! How create table without field ID? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from

[web2py:17976] Re: Procedures and views in DB execute.

2009-03-12 Thread shuval
There is one question. How use parameters procedure DB (Firebird) in web2py? For example org_chart("parameter"). May be web2py not work procedure with parametres. db.define_table('org_chart("parameter")', SQLField('name'), SQLField('code', 'integer'), SQLField('empcnt', 'integer'),

[web2py:19538] Return 10000 values to SQLFORM

2009-04-09 Thread shuval
Hello!!! I test SQLFORM. I found problem, when i returned 1 values to SQLFORM i got 7453. Is maximum in SQLFORM? thanks help! --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post