Q: SQL Insert - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Q: SQL Insert

I try to insert a new row into my table.
But I get the error: Syntax error in INSERT INTO statement.

I used the following insert into statement:
[code]
INSERT INTO tblDeelnemers (PartnerID,Voornaam,Achternaam,Emailadres,BannerFlag,BannerURL,Password,WebsiteTitel,WebsiteURL,WebsiteOmschrijving,Rubriek) VALUES (3,'stuk','stukje','[email protected]','true','http://www.stukjes.nl/banner.gif','joPass123','stukjes','http://www.stukje.nl','stukjes van eens stuk','literatuur')
[/code]

Note: The fieldnames are all fieldnames except the Id autonumber field

Who knows what is wrong with my INSERT INTO statement???

Comments

  • rodemmrodemm Posts: 44Member
    Well there should be someone that can solve my problem???

    : I try to insert a new row into my table.
    : But I get the error: Syntax error in INSERT INTO statement.
    :
    : I used the following insert into statement:
    : [code]
    : INSERT INTO tblDeelnemers (PartnerID,Voornaam,Achternaam,Emailadres,BannerFlag,BannerURL,Password,WebsiteTitel,WebsiteURL,WebsiteOmschrijving,Rubriek) VALUES (3,'stuk','stukje','[email protected]','true','http://www.stukjes.nl/banner.gif','joPass123','stukjes','http://www.stukje.nl','stukjes van eens stuk','literatuur')
    : [/code]
    :
    : Note: The fieldnames are all fieldnames except the Id autonumber field
    :
    : Who knows what is wrong with my INSERT INTO statement???
    :
    :

  • rodemmrodemm Posts: 44Member
    Dear myself,

    You made the mistake that you pass a boolean value in single quotes you shouldn't do that, stupid student. So, if nobody likes to answer your question, you should do it yourself.

    Roderik

    : Well there should be someone that can solve my problem???
    :
    : : I try to insert a new row into my table.
    : : But I get the error: Syntax error in INSERT INTO statement.
    : :
    : : I used the following insert into statement:
    : : [code]
    : : INSERT INTO tblDeelnemers (PartnerID,Voornaam,Achternaam,Emailadres,BannerFlag,BannerURL,Password,WebsiteTitel,WebsiteURL,WebsiteOmschrijving,Rubriek) VALUES (3,'stuk','stukje','[email protected]','true','http://www.stukjes.nl/banner.gif','joPass123','stukjes','http://www.stukje.nl','stukjes van eens stuk','literatuur')
    : : [/code]
    : :
    : : Note: The fieldnames are all fieldnames except the Id autonumber field
    : :
    : : Who knows what is wrong with my INSERT INTO statement???
    : :
    : :
    :
    :

Sign In or Register to comment.