User Profile

Collapse

Profile Sidebar

Collapse
jbird4k
jbird4k
Last Activity: Nov 29 '11, 07:44 PM
Joined: Nov 28 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • jbird4k
    replied to mysql syntax error
    in MySQL
    i have had some success in dynamically adding a single record, but I had to provide a value for every field.

    How would I insert a null or blank value? Not all fields apply to all users.
    See more | Go to post

      Leave a comment:

    • jbird4k
      replied to mysql syntax error
      in MySQL
      I added the quotes and still received the same error. I can manually enter the exact same data and not recieve an error.

      is there any way to determine which field is throwing the error?
      ....near line 67. is actually the column name not the value, the ..115. is the last line of the query.

      confused and frustrated.
      See more | Go to post

        Leave a comment:

      • jbird4k
        replied to mysql syntax error
        in MySQL
        OK, rabbit, I have removed all quotes.

        What is the proper syntax for inserting a date? with or without quotes?

        and ran it again and received the same error message.
        See more | Go to post

          Leave a comment:

        • jbird4k
          started a topic mysql syntax error
          in MySQL

          mysql syntax error

          hi

          I am having an issue inserting data into a mysql table.

          I am getting the following error.

          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 '', 2011-11-28 , 2011-11-28 , 2011-11-28 , 'foster.sharon@ oig.dol' at line 75

          here is the code that is trying to execute

          Code:
          insert into pers000.superspersonal(BADGE_NBR,
          ...
          See more | Go to post
          No activity results to display
          Show More
          Working...