Not logged in.  Login/Logout/Register | List snippets | | Create snippet | Upload image | Upload data

4
LINES

< > BotCompany Repo | #1000469 // Creating SQL statements (lesson 2 - snippet visibility defined)

IOIOI

In: "bla from tb_snippet where visible"
Out: "bla from tb_snippet where sn_public=1 or sn_author=$user_id"
In: "select * from tb_snippet where visible"
Out: "select * from tb_snippet where sn_public=1 or sn_author=$user_id"

Author comment

Began life as a copy of #1000467

download  show line numbers   

Travelled to 12 computer(s): aoiabmzegqzx, bhatertpkbcr, cbybwowwnfue, gwrvuhgaqvyk, ishqpsrjomds, lpdgvwnxivlt, mqqgnosmbjvj, pyentgdyhuwx, pzhvpgtvlbxg, tslmcundralx, tvejysmllsmz, vouqrxazstgt

Comments [hide]

ID Author/Program Comment Date
774 #738 Solved!

Details:
LBla(inPattern="^(.+)\\Q from tb_snippet where visible\\E$", outPattern="$1 from tb_snippet where sn_public=1 or sn_author=\\$user_id")
2015-08-19 17:04:24  delete 

add comment

Snippet ID: #1000469
Snippet name: Creating SQL statements (lesson 2 - snippet visibility defined)
Eternal ID of this version: #1000469/1
Text MD5: e8880e338cf3928d2d3d1cdfaa0f3234
Author: stefan
Category:
Type: IOIOI
Public (visible to everyone): Yes
Archived (hidden from active list): No
Created/modified: 2015-08-08 17:49:01
Source code size: 228 bytes / 4 lines
Pitched / IR pitched: No / Yes
Views / Downloads: 792 / 297
Referenced in: [show references]