I have the following error when I try to use the LIMIT clause in my SQL expression:
Syntax error (missing operator) in query expression 'vins_nom LIMIT 1'
If I donīt use "LIMIT 1" itīs ok.
CODE
SQLStmt = "SELECT vins_id, vins_nom, vins_desc, vins_photo, villages_nom, domaines_nom, appelations_nom, couleurs_nom, millesimes_nom, cepages_nom, vins_btmin, vins_bouteille, vins_prix1, vins_coupcoeur FROM (((((vins LEFT JOIN villages ON vins.villages_id=villages.villages_id ) LEFT JOIN domaines ON vins.domaines_id=domaines.domaines_id) LEFT JOIN appelations ON vins.appelations_id=appelations.appelations_id) LEFT JOIN couleurs ON vins.couleurs_id=couleurs.couleurs_id) LEFT JOIN millesimes ON vins.millesimes_id=millesimes.millesimes_id) LEFT JOIN cepages ON vins.cepages_id=cepages.cepages_id"
SQLStmt &= " WHERE TRIM(vins.vins_coupcoeur) <> ''"
SQLStmt &= " AND vins.vins_site "
SQLStmt &= " ORDER BY vins_nom LIMIT 1"
Thank for your help.
28 Apr, 2008 - 08:38 AM
|