Author Topic: Picture naming problem....  (Read 5072 times)

0 Members and 1 Guest are viewing this topic.

Offline Vienix

  • Full Member
  • ***
  • Posts: 144
    • View Profile
    • com.municate.nl
Picture naming problem....
« on: May 24, 2002, 03:15:09 PM »
Hi,

I have a category "Rice Paddy's", no problem.

I put a picture there, named "Rice Paddy's" , big problem:

DB Error: Bad SQL Query: SELECT image_id AS next_image_id FROM 4images_images WHERE image_name > 'Some Rice Paddy's' AND cat_id = 25 AND image_active = 1 ORDER BY image_name ASC LIMIT 1
You have an error in your SQL syntax near 's' AND cat_id = 25 AND image_active = 1 ORDER ' at line 3

DB Error: Bad SQL Query: SELECT image_id AS prev_image_id FROM 4images_images WHERE image_name < 'Some Rice Paddy's' AND cat_id = 25 AND image_active = 1 ORDER BY image_name DESC LIMIT 1
You have an error in your SQL syntax near 's' AND cat_id = 25 AND image_active = 1 ORDER B' at line 3


Demonstration :

http://www.bali-pictures.com/4images/

....

 8O

Vienix
Thats It !

Offline Jan

  • Administrator
  • 4images Guru
  • *****
  • Posts: 5.024
    • View Profile
    • 4images - Image Gallery Management System
Picture naming problem....
« Reply #1 on: May 24, 2002, 03:30:09 PM »
Your first three "must do" before you ask a question:
1. Forum rules
2. FAQ
3. Search