Creating SQL statements (lesson 2 - snippet visibility defined) [1000469]

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:	799 / 300
Referenced in:	#681 - All IOIOI examples (collection) #1000471 - Creating SQL statements (lesson 3 - get snippet title) #3000189 - Answer for stefanreich(>> t bla) #3000382 - Answer for ferdie (>> t = 1, f = 0) #3000383 - Answer for funkoverflow (>> t=1, f=0 okay) #3000384 - Answer for 6uru0fsh1va (>> t-sql?)