DEV Community

Judy
Judy

Posted on

2 1 1 1 1

Getting positions of members according to primary key values #eg58

In the following product category table, ID field is the primary key. The task is to find ordinal number of the member whose ID field value is 5.

Image description

SPL script:

Image description

A1 Connect to the database;
A2 Retrieve Category table from the database and set ID as the primary key;
A3 Find ordinal number of the record whose primary key value is 5. If the desired primary key value does not exist or no primary key is defined, pfind() function returns 0.

SPL open source address

Download

Top comments (0)

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay