Mercurial > hgrepos > hgweb.cgi > s4
comparison s4-funcs.sh @ 955:946f2db59413 draft
quote SQL in backtick
| author | HIROSE Yuuji <yuuji@gentei.org> |
|---|---|
| date | Wed, 10 Nov 2021 20:52:04 +0900 |
| parents | 93c38e425c85 |
| children | 4961963431f9 |
comparison
equal
deleted
inserted
replaced
| 954:ab78a6e229a6 | 955:946f2db59413 |
|---|---|
| 495 isgrpowner() ( | 495 isgrpowner() ( |
| 496 # $1=user, $2=group | 496 # $1=user, $2=group |
| 497 gn=`sqlquote "$2"` | 497 gn=`sqlquote "$2"` |
| 498 sql="select user from grp_adm where gname=$gn and user='$1';" | 498 sql="select user from grp_adm where gname=$gn and user='$1';" |
| 499 err isgrpowner: $sql | 499 err isgrpowner: $sql |
| 500 test -n "`query $sql`" | 500 test -n "`query \"$sql\"`" |
| 501 ) | 501 ) |
| 502 isgrpownerbygid() ( | 502 isgrpownerbygid() ( |
| 503 # $1=user, $2=group-rowid | 503 # $1=user, $2=group-rowid |
| 504 sql="select user from grp_adm where gname=(select gname from grp where rowid=$2) and user='$1';" | 504 sql="select user from grp_adm where gname=(select gname from grp where rowid=$2) and user='$1';" |
| 505 err isgrpownerbygid: $sql | 505 err isgrpownerbygid: $sql |
