[web2py] Ajax Records Delete

Dear ALL ,, I want to delete records and return them in ajax , i have a table like this : db.define_table('Cars', Field('Name'), Field('Age') ) and i get all the records to my page using a for loop over the object the equals db().select(db.Cars.ALL) what i want is to have a button next to e

[web2py] trying to use movu

Dear ALL , I am Trying TO use movu from http://movu.ca and i installed PyCrypto and PIL and web2py , and did this - http://localhost:8000/demo/setup/install : but i keep getting invalid function (setup/install) Why is that ?? --

[web2py] Is Vars Bad for SEO?

Dear ALL, I want to change all the page i use args in to vars so i can use args to make my urls more descriptive for SEO , now if i move everything to vars is it bad for SEO or what , what do you recommend ? --

[web2py] Import SCV Button

Dear ALL, How can i make a button that lets the user download a scv file for on of my tables ? best regards, --

[web2py] Generate json

Dear ALL , i want to Generate json like this one : { "Result":"OK", "Records":[ {"PersonId":1,"Name":"Benjamin Button","Age":17,"RecordDate":"\/Date(1320259705710)\/"}, {"PersonId":2,"Name":"Douglas Adams","Age":42,"RecordDate":"\/Date(1320259705710)\/"}, {"PersonId":3,"Name":"Isaac A

[web2py] MySQL Error

Dear ALL , I am trying to connect to mysql database and i keep getting this error : * (1064, u"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Like INT,\n Sidebar CHAR(1),\n Homepage CHAR(1),\n Order VARCH

Re: [web2py] MySQL Error

nSEO_Description LONGTEXT,\n ' at line 25") On Tuesday, August 7, 2012 3:07:49 PM UTC+3, Marin Pranjić wrote: > > 'Like' is an sql keyword. > > On Tue, Aug 7, 2012 at 1:13 PM, Hassan Alnatour < > halna...@gardeniatelco.com> wrote: > >>

[web2py] Random Records From Database

Dear ALL, How Can i get random records for a database table ? Best Regards, --

[web2py] Connecting with database that has tables in it

Dear ALL , I have a database that is running under Microsoft SQL server , i want to connect to that database and use its tables , but i dont want to define any tables in my db.py , how can i do that ? Best Regards, --

[web2py] changing the links in auth navbar

Dear ALL , I am using {{='auth' in globals() and auth.navbar(separators=(' ','',''))}} >> so i get login | registration ... and some other links >> now how can i change the words ? i want to change login to something else so how can i do that ??? Best regards, --

[web2py] Using ssl certificate

Dear ALL, how to use an SSL certificate with web2py ? Best Regards, Hassan Alnatour --

[web2py] XML Webservice

Dear ALL, I want to create a web service that returns an xml of the some recorders in a table ? Best Regards, --

[web2py] return TABLE(*[TR(k, v) for k, v in form.errors.items()])

Dear ALL , I need help to understand this return , can anyone explain it to me please ? return TABLE(*[TR(k, v) for k, v in form.errors.items()]) --

[web2py] Ajax LOAD

Dear ALL, how can i change the "loading.." word that appears when i use this {{=LOAD()}} ?? Best Regards, --

[web2py] LOAD Ajax

Dear ALL , i am having problems when i use the LOAD() in the page.load if i add any CSS with images like background:url(); and when i use the function URL('page') the url is rendered as /project/controller/page.load , what can i do to fix this problem ? Best Regards, --

[web2py] WSDL Web service in web2py

Dear ALL , How can i create a WSDL web service in web2py ? --

[web2py] Check for a value in a table

Dear ALL , How can a check if a value for a Field in a table , now in this i do this values = [] for i in db().select(db.table.ALL): values.append(i.Field) then i check like this : if i in values: . . Is there a better way to do this ?? Best Regards, --

[web2py] Send Email After Registration

Dear ALL, How can I send an email to the user after he registers automatically ? Best Regards, --

[web2py] CAPTCHA and reCAPTCHA in registration form

Dear ALL , I am trying to use reCAPTCHA in my default/user.html page on registration form , now i added this in the db.py : from gluon.tools import Recaptcha auth.settings.captcha = Recaptcha(request, 'PUBLIC_KEY', 'PRIVATE_KEY') But now whats next ?? Best Regards, --

[web2py] DAL Keys

Dear ALL , i am getting this error 'DAL' object has no attribute 'keys' when using this code : for table in db.keys(): if not (table.startswith('_') or table in badmin_tables): if db[table] and not table in badmin_exclude_tables: if isinstance(db[table],db.Table): if tab

[web2py] Re: registration message

Dear Yebach , just add this in the default/school in the controller : if request.vars.school == 'database': response.flash = 'your_Massage!' Notes : check if you have {{=response.flash or ' '}} in you school page so it can show the response you sent from the controller . Best Reg

[web2py] Re: registration message

You are more than welcome Yebach ;) regards, On Monday, September 24, 2012 5:55:20 PM UTC+3, Yebach wrote: > > All I needed was actually add{{=response.flash or ' '}} in my view and > it worked > > but thanx for the hint > > On Monday, September 24, 2012 3:

[web2py] Return Compile error

Dear ALL, I am trying to return a div that has a select with option from table , but am getting an error , and i still cant figure it out , any help please ? return DIV( LABEL('%s: ' % table[column].label,_for=column), DIV(SELECT( #OPTION('None',_value=''), for

[web2py] Apache Error Please Help

[Wed Sep 26 06:29:38 2012] [error] [client 127.0.0.1] mod_wsgi (pid=3648): Target WSGI script 'C:/web2py/wsgihandler.py' cannot be loaded as Python module. [Wed Sep 26 06:29:38 2012] [error] [client 127.0.0.1] mod_wsgi (pid=3648): Exception occurred processing WSGI script 'C:/web2py/wsgihandler.

[web2py] Send Errors To Email

Dear ALL , Is there a way to make all the error be sent to my email when it happens ? Best regards, --

[web2py] unrecoverable internal error

Dear ALL ,, When i try to login i keep getting this page : Internal errorTicket issued: unrecoverable what to do ? Best Regards, --

[web2py] Login error in the new web2py

Dear ALL , i am having some trouble with the new web2py , i have a window server 2008 that i am using apache in to host my sites , now everything was working fine but when i updated web2py , it was okey but every once and while the login stops , i open the server and i do the same thing locall

[web2py] Re: Send Errors To Email

Dear Dave , Where did you add this file , and how do you use it ? Best Regards, Hassan Alnatour On Friday, September 28, 2012 6:38:18 AM UTC+3, Dave wrote: > > I have written a script that will load the error pickle file and email me > parts of it. The thing I had to be careful

Re: [web2py] Re: Login error in the new web2py

Dear Massimo , i tested on early version of web2py and it works just fine , can you help me with this please ? Best Regards, On Friday, September 28, 2012 3:44:45 PM UTC+3, Hassan Alnatour wrote: > > Dear Massimo , > > i am getting this not in just on of my apps , and am

[web2py] browse path

Dear ALL, I See Alot Of applications that has a browse button but when you click it , it open a folder on the server !! , how do i do that ?? Best Regards,

[web2py] creating a shopping cart using session

Dear ALL , How can i create somting in the session that i can save things too , i want to create a shopping cart and save some items in it and after the user finish i want to send an email ,, any help guys or do you have any other ideas best regards

Re: [web2py] Re: creating a shopping cart using session

i am trying to work with session like you showed me but still when i add somthing it just changes the last element in the session to the element i added > >

Re: [web2py] Re: creating a shopping cart using session

> > session.cart_items=[{'id':123 ,'qty':1}, {'id':456, 'qty':3}] > items = session.cart_items > if request.vars: > > session.cart_items.append({'id':request.vars.id > ,'qty':request.vars.qyt}) > > and in the view : add {{=session.cart_items}}

[web2py] default value for upload Fields

Dear ALL, how can i make a default image for a image upload field in db i tried this but its not working : Field('Cover','upload',default="URL('static','images')/no-user-image.gif"), any ideas ?

[web2py] Ajax

Dear ALL, How can i use ajax in a to post some vars to a controller function ?? Best Regards,

[web2py] Page Title Tag

Dear ALL , I am using a master page , now how can i let every page has its own title tag ?? Best Regards,

[web2py] redirect('http://www.web2py.com')

Dear ALL , I am trying to use redirect like this : def members(): if request.vars.fb == "1": redirect('http://www.web2py.com') users = db().select(db.users.ALL,orderby=~db.users.Placeorder) return dict(users=users) but it keep taking me to my website index page or giv

[web2py] Re: redirect('http://www.web2py.com')

No am not using ajax , i used a javascript redirect now , but why the python redirect is not working and when i use it , it keeps my domain and adds the url that i want to redirect to it

[web2py] Copying Date From Sqlite to a Mysql database

Dear ALL, How Can i copy all the records and tables in my sqlite database to a mysql database ? regards,

[web2py] Creating Pages in a Content Managment System using Generic view and template blocks

Dear ALL, I want to create a Content management system that has the ability to create pages , now as i know when i want to create a page in web2py first i need the function and then i need the html page or else use the Generic.html for my pages , now any ideas of how to create pages using

[web2py] time event

Dear ALL, How can let my web2py application send an email every day at 12 pm ?? Best regards,

[web2py] Find text

Dear ALL , I want to find every thing in the text like " EM " so its space EM space and make it an EM Best regards,

[web2py] recipes book database mover

Dear ALL , anyone used the method in the book to move the data from sqlite database to mysql , i keep geting this error [image: Inline image 1]

[web2py] not enough arguments for format string

Dear ALL , I created a function to get a div and a button and a speed and then using jquery scroll down to that div , now the function looks like this : *def scrolldown(button_id,div_id,speed): ''' Scroll down to the end of any div using a button and a speed ''' return XML("$

[web2py] Sending Emails to all my users in one time

Dear ALL , How can i send all the users i have in my auth_users an email at once ?\ regards,

[web2py] translation from php to python

Dear ALL , i need help in translating this php code to python , i dont understand the last line : best regards,

[web2py] Moving Data From Sqlite To MySql

Dear ALL, How can i move my database from sqlite to mysql ? regards,

[web2py] web2py interactive console

Dear ALL , i am trying to use web2py from the terminal now i open the terminal and did this : $ cd web2py $ python web2py.py -S welcome here web2py will start the interactive console : >>> db = DAL('sqlite://storage.sqlite') >>> db.tables [] i didnt find my tables , why ?? i want to d

[web2py] Error connecting with mysql database

rror in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Like INT,\nShow_on_SideBar CHAR(1),\nHome_Page_Video CHAR(1),\nOrder_Nu' at line 22") IN FILE: C:\WEB2PY\APPLI

[web2py] Multiple level database diagram

Dear ALL , I am creating an application with is a reference about some city's , so the website has some city's , every city has some areas and every area has some other stuff ,it all up to 6 levels , so what is the best was to do that in the database ? i am thinking about making every lev

[web2py] Online Auth_user

Dear ALL , How can i check , who is online from my registered users ? Best Regards,

[web2py] Services

Dear ALL , I have never used a service but i have some questions about it , when will some need to use a service , what can i benefit form using services ? best regards,

[web2py] Memcache

Dear ALL, I just want to know when yo use Memcache , and what can i benefit from using it

[web2py] csv button

Dear ALL , How can i create a button that create a csv file for a cretin table ? Best Regards

[web2py] Error with Janrain integration

Dear ALL, I am using Janrain with the normal login in my site it works well but lately i have notice that if i am login in using it and using use normal links on the site like : *www.i3zif.com/PlayVideo/18* , it logs out but if i am using the normal login it works well , what do you think the

[web2py] Re: Error with Janrain integration

i Tried using this link , it works fine now , but why is this happening ??? regards, On Sunday, July 1, 2012 12:01:25 PM UTC+3, Hassan Alnatour wrote: > > Dear ALL, > > I am using Janrain with the normal login in my site it works well > but lately i have notice that if i am lo

[web2py] db.py request.vars

Dear ALL, Can i use an if in the db.py depending in the request.vars ? i created some extra Fields to the auth_user table and one Field uses a list so if the user/register page has the lan=en i want to use another list , how do you think i can do this ?

[web2py] db query not working

x27;HomePageVideo','boolean'), Field('Order_Number','integer') ) Now i use this to get recordes : video = db().select(db.Videos.ALL) , it works fine but when i add one condition for it , it works well two but if i did this , it just takes the first condition and ignore the rest : video = db(db.Videos.Video_Type == "XXX" and db.Videos.Teacher == "xx").select(db.Videos.ALL) What do you think is the problem , what am i messing ?? Best Regards, Hassan Alnatour

[web2py] Password encoding in php

Dear ALL , i have a php login form , now the password is posted as md5() ,, what is the correct encoding to use in php with web2py password field in auth_user table what am posting is regards, --

[web2py] How to implement web2py password encryption in php

Dear ALL , How can i implement web2py password encryption in php ? Best Regards, --

[web2py] What is the Salt used in web2py

Dear ALL , How can i find the salt used in web2py to encrypt the passwords ? now as i understand if i want to encrypt the password manually i need to do it like this ? CRYPT(digest_alg='md5',key='mykey',salt=True) is this correct , am a bit lost !! i need to understand how can i do the same

[web2py] Error mysql

Dear ALL , Am trying to connect to a mysql database but am getting this error , how can i solve this problem : connection string : *URI = 'mysql://root:@localhost/hasaad'* TICKET ID 127.0.0.1.2013-02-20.10-10-32.b8a942ff-fb3a-4ba0-b118-fd1fdac873bf * (1050, u"Table 'auth_user' already exist

[web2py] Table Dose not exist

Dear ALL , i Defined a table in my db.py but when i start the application , it gives me an error that my table dose not exist , i dont understand , any help please : Error : no such table: NewsCategory TRACEBACK 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. Traceback (m

[web2py] Send emails using my own domain

Dear ALL, i want to add my email in the db.py to use it to send email from the site , how can i make it using my own domain not gmail ? Best Regards, --

[web2py] Bug With CSV Export and import

Dear ALL , when exporting all the tables as CSV , the csv changes the ids to the order of the recorders , this is now right , what can i do to fix this , i want to move the data with the same ids regards, --

[web2py] Record id auto Generation

Dear ALL , How can i stop the auto Generation of ids in any table in database and add it by my self .. regards, --

[web2py] unsupported format character 'A' (0x41)

unsupported format character 'A' (0x41) at index 53VERSIONweb2py™(1, 99, 4, datetime.datetime(2011, 12, 14, 14, 46, 14), 'stable')PythonPython 2.7.2: C:\Python27\python.exeTRACEBACK 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. Traceback (most recent call last)

[web2py] Re: unsupported format character 'A' (0x41)

I dont understand the error anyone can help me with it ? regards, On Thursday, October 11, 2012 1:52:53 PM UTC+3, Hassan Alnatour wrote: > > unsupported format character 'A' (0x41) at > index 53VERSIONweb2py™(1, 99, 4, datetime.datetime(2011, 12, 14, 14, 46, > 14), '

Re: [web2py] Bug With CSV Export and import

On Wednesday, October 10, 2012 3:18:07 PM UTC+3, Massimo Di Pierro wrote: > > There are bugs in the export/import functions in 1.99.4. It is almost one > year old. You should upgrade before we can help you. > > On Wednesday, 10 October 2012 01:58:26 UTC-5, Hassan Alnatour wrote: >>

[web2py] Re: Email notification for new subscribers

Dear Piero , you can start from here auth.settings.register_next = URL('Welcome') def Welcome(): if auth.user: User_Email = auth.user.email mail.send(User_Email,'Welcome To website','Welcome To website') redirect('index') else: redirect('index') regards,

Re: [web2py] Bug With CSV Export and import

I cannot say. > > On Friday, 12 October 2012 01:59:49 UTC-5, Hassan Alnatour wrote: >> >> Dear Massimo , >> >> i want to upgrade , but i have that problem with the login i told you >> about , that we didnt solve yet !! Please Help me >> >> >

Re: [web2py] Re: Login error in the new web2py

!! Best Regards Hasan Alnatoru On Friday, October 12, 2012 4:45:55 PM UTC+3, Massimo Di Pierro wrote: > > Are you storing session in db? > > On Friday, 12 October 2012 01:58:24 UTC-5, Hassan Alnatour wrote: >> >> Dear Massimo , >> >> I tried the nightly

Re: [web2py] Re: Login error in the new web2py

, October 12, 2012 5:56:19 PM UTC+3, Hassan Alnatour wrote: > > Dear Massimo , > > in one of my applications , that has a shopping cart in the controller i > have : > > > # Here i create a number that will never happen again ! and save it in the > session and i use it in t

[web2py] Re: unsupported format character 'A' (0x41)

#x27;stable') is one > year old. This error and my others have been fixed. You really need to > upgrade. ;-) > > > On Thursday, 11 October 2012 06:36:57 UTC-5, Hassan Alnatour wrote: >> >> I dont understand the error anyone can help me with it ? >> >> regard

Re: [web2py] Bug With CSV Export and import

Dear Richerd , am moving my database from sqlite to mysql, what is the best way ? and keeping the ids the same regards, On Friday, October 12, 2012 9:44:59 PM UTC+3, Richard wrote: > > Depending of your backend, for example with postgres : > > pg_dump --attribute-inserts > --file=/whereYouW

[web2py] Re: unsupported format character 'A' (0x41)

# -*- coding: utf-8 -*- # ## This scaffolding model makes your app work on Google App Engine too ## File is released under public domain and you can use without limitations

Re: [web2py] Re: Login error in the new web2py

What do you mean with removing the session ? and how do i do that ? regards, On Friday, October 12, 2012 10:40:09 PM UTC+3, Massimo Di Pierro wrote: > > Can you try remove the sessions? > > On Friday, 12 October 2012 10:35:02 UTC-5, Hassan Alnatour wrote: >> >> Dear Ma

Re: [web2py] Re: Login error in the new web2py

would i lose any data ? or what will happen to the users who is logged in regards, On Friday, October 12, 2012 11:14:14 PM UTC+3, Massimo Di Pierro wrote: > > delete all files in applications/yourapp/sessions/* > > On Friday, 12 October 2012 14:52:33 UTC-5, Hassan Alnatour wrote: &

[web2py] u'Cannot add or update a child row

Dear ALL , I am trying to move a databse from sqlite to mysql using csv import / export all , and i am getting this error : (1452, u'Cannot add or update a child row: a foreign key constraint fails (`dbi3zif3`.`auth_event`, CONSTRAINT `auth_event_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES

[web2py] Fitching Data From json

Dear ALL, I Have a website that has a page returning some rows in json , now how can i fitch those rows and insert them to my database ? regards --

[web2py] insert with ID

Dear ALL , How can i do an insert and added the id i want ? Regards, --

[web2py] Re: web2py 2.1.1 is OUT!

Dear Massimo , Is the Session and login issues are fixed ? regards, On Thursday, October 18, 2012 12:30:33 AM UTC+3, Massimo Di Pierro wrote: > > The line is: > > from distutils import dir_util > > I think you need to install distutils separately. > > > On Tuesday, 16 October 2012 09:14:47 UTC

Re: [web2py] Re: ProgrammingError: Cannot operate on a closed database

Dear mweissen i am having the same problem but on a windows server !? can you help me ? from where should i start ?? regards, On Wednesday, September 19, 2012 8:51:23 PM UTC+3, mweissen wrote: > > Solved. > The permission of a lot files have been wrong: > I develop an application on a win

[web2py] Help With Dropbox idea

Dear ALL , I want to make function that makes a csv file from my database and push it to a dropbox folder , any ideas on that ? Best Regards, --

[web2py] Dropbox Error : to many values to unpack

Dear ALL , i am trying to work with dropbox API i addedthe file dropbox.key in app/private and added the keys in it , i added the dropbox module and i am getting this error , any help ? regards, Traceback (most recent call last): File "C:\web2py\gluon\restricted.py", line 209, in restri

[web2py] A lot of us are getting the same error , ProgrammingError: Cannot operate on a closed database !!!

Dear ALL , Am getting this error in a lot of places , i think its a user privilege issue , at as i noticed a lot of people are having the same problem , so did anyone solve this on a windows machine ?? and if you did it on a linux machine please provide the solution two so we can help other

[web2py] Download a CSV file for a table

Dear ALL, I have this code for my CMS , am trying to make a button that downloads a csv file for the table auth_event , i did this : def UserEvents(): import cStringIO file = cStringIO.StringIO() db(db.auth_event.id >0).select(orderby=~db.auth_event.id).export_to_csv_file(file)

Re: [web2py] Re: web2py 2.2.1 is OUT

Dear Massimo , Great Work , but we really need backward compatibility for old projects .. Regards, --

[web2py] Help with db query

Dear ALL , i am trying to do this : sup = db( (db.Supplements.Category == (request.args(1)).replace('_',' ')) & (db. Supplements.Users == str(request.args(0)) or 'Both') ).select(db.Supplements.ALL) But its not working , any help ??? REgards, --

[web2py] Re: Help with db query

How Can i do : (query) & (db.table.Field == i or s) ??? regards On Tuesday, November 6, 2012 7:33:09 PM UTC+2, Hassan Alnatour wrote: > > Dear ALL , > > i am trying to do this : > > sup = db( > (db.Supplements.Category == (request.args(1)).replace('_

[web2py] User Recaptcha With a Crud form

Dear ALL , How Can i Use Recaptcha with a crud form ?? Regards, --

[web2py] get table records using vars

Dear ALL , Is there a way that i can get table records for table using vars ? best regards, --

[web2py] online users in web2py

Dear ALL, How can i get the online users in my site ? Best Regards, --

[web2py] Re: Image from Video

Whats That ? How Do i use it

[web2py] Re: Image from Video

I can't Find it for python 2.7 and windows 64bit ?? What to Do ??

[web2py] One time action for user

Dear All, i have a polls application and there is no registration but i want the user to vote only one time , how can i do that ?

[web2py] Re: One time action for user

Dear Anthony , Thnx it works :)

[web2py] Memcache ??

Dear ALL, What is cache and what is memcache ?? i dont understand it ? why we use it , what happens when we use it !!

[web2py] Check if request method is post

Dear All , How can i check if the request method is post ?

[web2py] math Division in web2py

Dear All , i have two variables am using : 1 - myfull >>> returns 3 2 - myfull 2 >>> returns 5 so what am trying to do is myfull1 = (myfull / myfull2)* 100 , so i can get a percent >>> {{=myfull1%}} but i keep geting 0 it should be 60%

  1   2   >