Results 1 to 5 of 5
  1. #1

    Yet another mysql question

    when trying to add this:

    INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Large Image Width (Pop-up)', 'LARGE_IMAGE_WIDTH', , 'The pixel width of large images (Pop-up)<br>(Use 0 for non-specific size)', 4, 32, now(), now(), NULL, NULL);

    I get this:

    #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' 'The pixel width of large images (Pop-up)<br>(Use 0 for non-sp


    What would be correct?
    Thanks, Kevin

  2. #2
    Join Date
    Oct 2004
    Posts
    104
    Put something between those commas

  3. #3
    Join Date
    Mar 2004
    Location
    New Zealand
    Posts
    532

    Re: Yet another mysql question

    ...IMAGE_WIDTH', , 'The p...
    Missing a value.

  4. #4
    Thanks, got it
    Thanks, Kevin

  5. #5
    Gotta hate those little typos!
    data center directory - The comprehensive data center resource. Version 2.0 coming soon!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •