DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: sqlstatement

  1. #1
    Join Date
    Aug 2000
    Posts
    5
    hello,

    i have a very simple question:
    why doesn't this insert execute. I can't seem to find the error

    INSERT INTO HOST (HOST, IP, COMPANY, APP, CONTACT, INSERTED)
    VALUES (HOUAPPS053, 34.224.101.214, MWK, IPMS, GSMET, 11-15-00)
    /

    i get message "missing comma" ?? where?

  2. #2
    Join Date
    Nov 1999
    Location
    Elbert, Colorado, USA
    Posts
    81
    Your character strings need to have single quotes around them. I suspect that it is looking at the IP address as a number and getting confused by the multiple periods.
    Try this:

    INSERT INTO HOST (HOST, IP, COMPANY, APP, CONTACT, INSERTED)
    VALUES ('HOUAPPS053', '34.224.101.214', 'MWK', 'IPMS', 'GSMET', '11-15-00');

  3. #3
    Join Date
    Jun 2000
    Posts
    295
    Also you may need to use date function if your date mask
    is not MM-DD-YY.

Posting Permissions

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


Click Here to Expand Forum to Full Width