[Ur] dml DELETE and SELECT, way of referring to rows

Daniel Patterson dbpatterson at riseup.net
Tue Dec 29 16:12:58 EST 2009


Oh, nevermind about it working. it compiles and runs, it just doesn't
actually delete anything. Ideas of what I'm doing wrong? Is there a
specific example/part of the manual I should be looking more closely at?

On 12/29/2009 04:08 PM, Daniel Patterson wrote:
> Code that is written like:
> 
>         dml (DELETE FROM s
>              WHERE Session = {[v.Session]} );
> 
> with table defined as:
> table s : {LoggedIn : time, User : string, Session : string}
>   PRIMARY KEY LoggedIn
> 
> and v being the a cookie value with attribute Session
> 
> Works, where as:
> 
>         dml (DELETE FROM s
>              WHERE s.Session = {[v.Session]} );
> 
> Does not.
> 
> This is different from how the Sql example worked (where DELETE was used
> with t.A), but the same as how the Tree example works.
> 
> I've posted the full chunk of code it comes out of at
> http://paste.lisp.org/display/92786
> 
> What is the difference?
> 
> _______________________________________________
> Ur mailing list
> Ur at impredicative.com
> http://www.impredicative.com/cgi-bin/mailman/listinfo/ur




More information about the Ur mailing list