Active Server Pages

Moderators: None (Apply to moderate this forum)
Number of threads: 1763
Number of posts: 4498

This Forum Only
Post New Thread
Single Post View       Linear View       Threaded View      f

Report
Q: SQL Insert Posted by rodemm on 11 Sept 2002 at 8:54 PM
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:
INSERT INTO tblDeelnemers (PartnerID,Voornaam,Achternaam,Emailadres,BannerFlag,BannerURL,Password,WebsiteTitel,WebsiteURL,WebsiteOmschrijving,Rubriek) VALUES (3,'stuk','stukje','beversamsterdam@hotmail.com','true','http://www.stukjes.nl/banner.gif','joPass123','stukjes','http://www.stukje.nl','stukjes van eens stuk','literatuur') 


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

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

Report
How can one protect the piracy of his software? Posted by rodemm on 13 Sept 2002 at 2:42 PM
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:
:
: INSERT INTO tblDeelnemers (PartnerID,Voornaam,Achternaam,Emailadres,BannerFlag,BannerURL,Password,WebsiteTitel,WebsiteURL,WebsiteOmschrijving,Rubriek) VALUES (3,'stuk','stukje','beversamsterdam@hotmail.com','true','http://www.stukjes.nl/banner.gif','joPass123','stukjes','http://www.stukje.nl','stukjes van eens stuk','literatuur') 
: 

:
: Note: The fieldnames are all fieldnames except the Id autonumber field
:
: Who knows what is wrong with my INSERT INTO statement???
:
:

Report
Re: Help Posted by rodemm on 13 Sept 2002 at 8:13 PM
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:
: :
: : INSERT INTO tblDeelnemers (PartnerID,Voornaam,Achternaam,Emailadres,BannerFlag,BannerURL,Password,WebsiteTitel,WebsiteURL,WebsiteOmschrijving,Rubriek) VALUES (3,'stuk','stukje','beversamsterdam@hotmail.com','true','http://www.stukjes.nl/banner.gif','joPass123','stukjes','http://www.stukje.nl','stukjes van eens stuk','literatuur') 
: : 

: :
: : Note: The fieldnames are all fieldnames except the Id autonumber field
: :
: : Who knows what is wrong with my INSERT INTO statement???
: :
: :
:
:




 

Recent Jobs

Official Programmer's Heaven Blogs
Web Hosting | Browser and Social Games | Gadgets

Popular resources on Programmersheaven.com
Assembly | Basic | C | C# | C++ | Delphi | Flash | Java | JavaScript | Pascal | Perl | PHP | Python | Ruby | Visual Basic
© Copyright 2011 Programmersheaven.com - All rights reserved.
Reproduction in whole or in part, in any form or medium without express written permission is prohibited.
Violators of this policy may be subject to legal action. Please read our Terms Of Use and Privacy Statement for more information.
Operated by CommunityHeaven, a BootstrapLabs company.