Hi All
Happy new year 2019.
I have an issue with SQL NOT IN
I tried to get a heater pad list(dropdown) in a form.
The heater must be related to user depot and not been used.
If they are used the heater id is set up in table articles
Queryheat=db((db.heatpad.id_depot==db.auth_user.id_depot)&(db.auth_user.id==
auth.user.id))&db(~db.heatpad.id.belongs(db.articles.heatpad))
I always get an exception memory error
I have tried with
Queryheat=db((db.heatpad.id_depot==db.auth_user.id_depot)&(db.auth_user.id==
auth.user.id)&db(~db.heatpad.id.belongs(db.articles.heatpad).select(db.
heatpad.id)))
Queryheat=db((db.heatpad.id_depot==db.auth_user.id_depot)&(db.auth_user.id==
auth.user.id)&(~db.heatpad.id.belongs(db.articles.heatpad).select(db.heatpad
.id)))
def show_flexi():
request.title=T("Braid Logistics Europe")
flexi_id=request.args(0, cast=int)
type_article=request.args(1, cast=int)
records = db.articles(flexi_id)
db.articles.cod_ref.writable=False
db.articles.id_stk_article.readable=db.articles.id_stk_article.writable=
False
db.articles.id.readable=False
db.articles.isintegrated.readable=db.articles.isintegrated.writable=
False
depotrecord=db(db.depot.id==auth.user.id_depot).select(db.depot.
useheatpad)
Row=depotrecord[0]
if Row['useheatpad']==True:
myFields=['cod_ref','conteneur','dossier','date_sortie','bulk_id',
'detruit','heatpad']
Queryheat=db((db.heatpad.id_depot==db.auth_user.id_depot)&(db.
auth_user.id==auth.user.id))&db(~db.heatpad.id.belongs(db.articles.heatpad))
db.articles.heatpad.requires=IS_IN_DB(Queryheat,db.heatpad.id,
'%(cod_ref)s')
else:
myFields=['cod_ref','conteneur','dossier','date_sortie','bulk_id',
'detruit']
QueryLang=db((db.depot.id==db.auth_user.id_depot)&(db.type_bulkhead.
id_language==db.depot.id_lang)&(db.auth_user.id==auth.user.id))
db.articles.bulk_id.requires=IS_IN_DB(QueryLang,db.type_bulkhead.id,
'%(name)s')
#labels={'cod_ref':T('Flexi Number'),'conteneur':T('Conteneur
Number'),'dossier':T('Braid reference'),'date_sortie':T('Fitting
date'),'bulk_id':T('Bulkhead'),'detruit':T('Destroyed')}
flexi=SQLFORM(db.articles
,record=records
#,labels=labels
,fields=myFields)
#,searchable=False)
flexi.add_button(T('Back'), URL(show_flexlist,args=[type_article],
user_signature=True))
if flexi.process(onvalidation=flexivalidation).accepted:
response.flash = T('form accepted')
#redirect(URL(show_flexlist,args=[type_article],user_signature=True))
elif flexi.errors:
response.flash = T('Form has errors')
return(dict(message=flexi_id,flexi=flexi))
Any idea where i'm wrong ?
Yann
--
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.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
