| 00:09.20 | jima | jlp_znc: freaked my oldest out too. gave him nightmares. |
| 00:15.26 | harleypig | I want to restrict the values of a column in mysql to a specific range of numbers, but I don't want to use enum. the CHECK and CONSTRAINT constraint_name CHECK syntax appears to be ignored entirely by mysql. Any ideas on how I can do this? |
| 00:24.12 | jima | harleypig: http://stackoverflow.com/questions/15758076/range-constraint-numeric-mysql-column-how ? |
| 00:24.30 | jima | your options...kind of suck, it appears. |
| 00:24.49 | RyanE | your options... kind of suck, Mr. Bond. |
| 00:26.24 | harleypig | jima: they certainly do ... a separate table just for valid data values? ew |
| 00:26.29 | harleypig | :] |
| 00:26.46 | harleypig | err ... I mean, a valid range of numeric values. |
| 00:27.55 | jima | kind of appalling |
| 00:28.51 | jima | meanders off to prepare for game night |
| 00:41.46 | levi | Yay, I got my crazy DMA programming scheme to work! And I didn't die on the drive home! |
| 01:11.33 | *** join/#utah Enemby (~Enemby@97-126-149-99.slkc.qwest.net) |
| 01:11.33 | *** join/#utah Enemby (~Enemby@unaffiliated/enemby) |
| 01:14.46 | harleypig | jima: I got triggers working, but they only work on before insert and before update. The developer can bypass that by using set. But, this is enough for now I guess. |
| 01:40.44 | jima | hmm |
| 01:41.04 | jima | maybe run a periodic sanity-check select? |
| 01:41.41 | jima | | mail -s "WHAT WERE YOU THINKING" developer |
| 02:04.25 | Enemby | ~utah |
| 02:04.25 | infobot | well, utah is the place for fun |
| 02:04.29 | Enemby | true |
| 02:16.29 | RyanE | for some definition of "fun". |
| 02:24.26 | harleypig | jima ... nah ... if the developer *really* wants to shoot himself in the foot, that's fine. I did due diligence in making the data as secure as I could maek it. |
| 02:52.49 | *** join/#utah Enemby_ (~Enemby@75-162-172-107.slkc.qwest.net) |
| 03:00.33 | *** join/#utah programmerq (~jefferya@unaffiliated/programmerq) |
| 03:29.42 | *** join/#utah kim27 (~kim27@184-155-223-24.cpe.cableone.net) |
| 03:29.54 | *** join/#utah kim27 (~kim27@unaffiliated/kim27) |
| 04:11.16 | *** join/#utah kim27 (~kim27@184-155-223-24.cpe.cableone.net) |
| 04:11.25 | *** join/#utah kim27 (~kim27@unaffiliated/kim27) |
| 04:36.01 | *** join/#utah arcrw (~pi@c-71-199-61-103.hsd1.ut.comcast.net) |
| 04:46.08 | *** join/#utah arcrw (~pi@c-71-199-61-103.hsd1.ut.comcast.net) |
| 04:57.29 | *** join/#utah arcrw (~pi@c-71-199-61-103.hsd1.ut.comcast.net) |
| 06:31.47 | *** join/#utah olli (~olli@c-73-20-95-1.hsd1.ut.comcast.net) |
| 07:35.53 | *** join/#utah siel (~siel@unaffiliated/motley) |
| 13:20.26 | *** join/#utah phemale (phemale@2601:681:4901:7a00::914d) |
| 16:16.10 | *** join/#utah infobot (ibot@69-58-76-73.ut.vivintwireless.net) |
| 16:16.10 | *** topic/#utah is Utah related discussion including user groups | logs @ http://ibot.rikers.org/%23utah/ | See also ##lds |
| 16:16.10 | *** mode/#utah [+o infobot] by ChanServ |
| 16:40.44 | *** join/#utah jlp_znc (jlp@2600:3c01::f03c:91ff:fedf:3238) |
| 16:42.51 | *** join/#utah basepi (sid18756@gateway/web/irccloud.com/x-zdlejzsrdexyykxi) |
| 16:43.06 | *** join/#utah jima (jima@2607:ff50:3::6:66) |
| 16:56.06 | *** join/#utah harleypig (sid15959@gateway/web/irccloud.com/x-ivertyoybgmvcavg) |
| 17:47.18 | *** join/#utah Enemby (~Enemby@unaffiliated/enemby) |
| 19:25.40 | *** join/#utah blunaxela (~alex@45.56.20.105) |
| 19:42.59 | *** join/#utah arcrw (~pi@c-71-199-61-103.hsd1.ut.comcast.net) |
| 19:51.18 | *** join/#utah arcrw (~pi@c-71-199-61-103.hsd1.ut.comcast.net) |
| 22:19.22 | *** join/#utah arcrw (~pi@c-71-199-61-103.hsd1.ut.comcast.net) |
| 23:21.00 | *** join/#utah arcrw (~pi@c-71-199-61-103.hsd1.ut.comcast.net) |