PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

Accueil  |  Messages récents  | Connexion  |   | Français  FR
Accueil → WEBDEV 2024 → Limit issue in query
Limit issue in query
Débuté par Mister RUAN, 11 sep. 2017 15:24 - Aucune réponse
#1
Membre enregistré
208 messages
Popularité : +1 (1 vote)
Posté le 11 septembre 2017 - 15:24
Good day.

I have a problem with the query inside Webdev PHP. I created a query with multiple parameters where the some of the parameters is in the LIMIT function. If I add the Limit with start line and return lines it works 100% but if I add the parameters it does not pass the parameters through and returns all the lines in the table.

Works:
SELECT
codes.code AS code,
codes.itemname AS itemname,
codes.brand_code AS brand_code,
codes.brand AS brand,
codes.registration_country_iso_code AS registration_country_iso_code,
codes.ItemDescription_Prefix AS ItemDescription_Prefix,
codes.code_Prefix AS code_prefix
FROM
barcodes
WHERE
barcodes.registration_country_iso_code = {Paramregistration_country_iso_code}
AND barcodes.ItemDescription_Prefix = {ParamItemDescription_Prefix}
LIMIT 1, 5;


Dont's pass:

SELECT
codes.code AS code,
codes.itemname AS itemname,
codes.brand_code AS brand_code,
codes.brand AS brand,
codes.registration_country_iso_code AS registration_country_iso_code,
codes.ItemDescription_Prefix AS ItemDescription_Prefix,
codes.code_Prefix AS code_prefix
FROM
barcodes
WHERE
barcodes.registration_country_iso_code = {Paramregistration_country_iso_code}
AND barcodes.ItemDescription_Prefix = {ParamItemDescription_Prefix}
LIMIT {ParamStartRecord}, {ParamLines};


Why would it not pass the parameters?

Thanks

Ruan
Message modifié, 11 septembre 2017 - 15:25
→ Revenir à WEBDEV 2024