Hy there, I have a query ready and works alright with executesql. I'm trying to change queries to use the dal but there's a problem in this case.
I have 2 tables related only by entry order, not by id's or some other key. It's a legacy database and these info are in separate tables because these info are filled by 2 different workers. For example: In process 001205 (CodProtocolo) we have 3 documents. One worker will give them some classification code, like 2,5 and 10 (meaningful for some purpose) in one program for the process 001205. Then he identifies them (physically) as 1,2,3 (always in code's ascending order) Another person will scan them in the specific order 1,2,3. This other program fills the table only inserting all into the process 001205 with some data, the image blob and give one code for each. I know they are in order so I can use: ROW_NUMBER() OVER(ORDER BY CodImagem) as ImgIndex and ROW_NUMBER() OVER(ORDER BY CodDocumento) as DocIndex and JOIN them Is there a way to accomplish it using the dal? -- 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.
