Le mercredi 2 janvier 2019 16:55:54 UTC+1, Yann Dulondel a écrit :
>
> 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)))
>
> The goal is to generate a SQL commande
>
SELECT X,Y from t1,t2 where t1.id=t2.fkid and x not in( select id from t3)
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
