Differences

This shows you the differences between two versions of the page.

View differences: Side by SideInline Go

Link to this comparison view

Both sides previous revisionPrevious revision 2025/08/27 12:26 Richard White [Test3 status query] 2025/08/27 12:26 Richard White 2025/08/27 12:21 Richard White 2025/08/27 12:05 Richard White createdGo Next revision		Previous revision 2025/08/27 12:26 Richard White [Test3 status query] 2025/08/27 12:26 Richard White 2025/08/27 12:21 Richard White 2025/08/27 12:05 Richard White createdGo
dbquery:test3 [2025/08/27 12:21] – Richard White		dbquery:test3 [2025/08/27 12:26] (current) – [Test3 status query] Richard White
Line 4:		Line 4:
	SELECT		SELECT
	IIF (lower(common_name) LIKE '%frog%', 'frog', 'notfrog') AS status,		IIF (lower(common_name) LIKE '%frog%', 'frog', 'notfrog') AS status,
-	scientific_name AS result	+	common_name AS result
	FROM species		FROM species
		+	WHERE lower(common_name) LIKE '%frog%'
	LIMIT 1;		LIMIT 1;
	</code>		</code>
Line 15:		Line 16:
	<code html>		<code html>
-	<div style="background-color: #F8CECC">In debt: :result</div>	+	<div style="background-color: #D5E8D4">Frog: :result</div>
	</code>		</code>
Line 22:		Line 23:
	<code html>		<code html>
-	<div style="background-color: #D5E8D4">All okay: :result</div>	+	<div style="background-color: #F8CECC">No frog found: :result</div>
	</code>		</code>