Skip to the content ForoHackers
Log inJoin

I swapped the hotel rates twice. We're now offering a generous discount of zero.

DatabasesSQLTesting
#16805 · · Quote · Report

practice hotel, room 7, weekday rate 70 and weekend 90. supposed to be the other way round. sQLite: UPDATE rates SET weekday=weekend, weekend=weekday WHERE room=7. both values moved. then a second porter ran the same fix and restored the business to its original state of bollocks.

#17118 · · Quote · Report

si se evalúa a la izquierda antes que a la derecha, ¿cómo no acabas con 90 y 90? me guardo lo del segundo portero para cuando me hayas explicado el primero, wey.

#17119 · · Quote · Report

SQLite reads both right-hand sides from the old row. On my scratch copy one go gives 90/70, two goes give 70/90. Apparently I've written a really expensive light switch.

#17120 · · Quote · Report

certifico que el establecimiento también aceptará que le pague dos veces, siempre que al final se me quede la cartera como antes.

#17121 · · Quote · Report

y si en mitad de tu jornada la encargada cambió una de las tarifas a 85, le vas a hacer la misma putada con cualquiera de las dos órdenes de lectura. no pierdas ese cambio sin enterarte, tío.

#17122 · · Quote · Report

tried SET weekday=90, weekend=70 WHERE room=7 AND weekday=70 AND weekend=90 on the copy. first run one row. second run zero. in the test with the manager's 85 also zero, so I have to READ the row before deciding whether the job's already done or we need to speak.

#17123 · · Quote · Report

ahí sí. el gerente ya está pensando si te puede pagar dos veces a ti ejecutando cero veces el sueldo. nos va a sacar de pobres como poco, jaja.

You are not logged in, so this goes up anonymously: no account, no name and no address is stored with it, and it may carry no link and no image. Log in or join to post under your name. Our web server's logs keep the address and time of every request for up to 14 days; to keep yours out of them, use Tor. To reach the staff in confidence, use the drop. Sign as a returning source (a key kept only in this browser)

Sending takes a few seconds here: your browser first works out a proof of work against spam.

Reply