1. foxgolfer's Avatar
    I previously posted that I was having difficulty adding a new course, something I had done many times. Following is the message I receive after entering the course basic information:



    ADD FACILITY


    INSERT INTO tblCourse (fid, version, CourseName, NewCourseName, NumberOfHoles, dtmCreated, dtmUpdated, UpdatedBy, CreatedBy, clat, clon, Par) VALUES (, 1, 'Sanctuary Golf Course', 'Sanctuary Golf Course', 18, now(), now(), '68.253.210.203', '68.253.210.203', 41.523584, -87.950449, 72)

    Bad query: 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 ' 1, 'Sanctuary Golf Course', 'Sanctuary Golf Course', 18, now(), now(), '68.253.' at line 1

    Please go Back and try again.

    Any ideas what's happening?

    Thanks,
    Tom
    11-11-11 11:18 AM
  2. ashworth's Avatar
    I previously posted that I was having difficulty adding a new course, something I had done many times. Following is the message I receive after entering the course basic information:



    ADD FACILITY


    INSERT INTO tblCourse (fid, version, CourseName, NewCourseName, NumberOfHoles, dtmCreated, dtmUpdated, UpdatedBy, CreatedBy, clat, clon, Par) VALUES (, 1, 'Sanctuary Golf Course', 'Sanctuary Golf Course', 18, now(), now(), '68.253.210.203', '68.253.210.203', 41.523584, -87.950449, 72)

    Bad query: 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 ' 1, 'Sanctuary Golf Course', 'Sanctuary Golf Course', 18, now(), now(), '68.253.' at line 1

    Please go Back and try again.

    Any ideas what's happening?

    Thanks,
    Tom
    Thanks for reporting this Tom.

    I had a small bug on my web site. It has now been fixed. Like I said I have been doing a lot of work and someone this small bug caused a big issue!

    Thanks again Tom! (Justin gives Tom a Gold star )
    11-15-11 02:18 PM
LINK TO POST COPIED TO CLIPBOARD