 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / ASP.NET / General / June 2007Help with SQL "INSERT INTO " syntax
Good day, I've been trying to work with SQL and an Access database in order to handle custom user profiles. I haven't had any trouble reading from my database, but inserting new entries into it has been troublesome to say the least. My ASP.NET script is supposed to execute an INSERT INTO statement in order to add a user to the database. Here is a sample: INSERT INTO LoginInfo (username, password, datafile) VALUES ('a', '0cc175b9c0f1b6a831c399e269772661', 'H:\CommConn\userdata\a.xml') This structure comes from http://www.w3schools.com/sql/sql_insert.asp Everything seems valid, but ASP still throws an error stating that the syntax of the statement is invalid. Could someone point out where the 'syntax' error is? Evan Try INSERT INTO LoginInfo (username, password, datafile) VALUES ('a', '0cc175b9c0f1b6a831c399e269772661',@ 'H:\CommConn\userdata\a.xml') Notice the @ sign. "\" is an escape character. You have to use 2 '\'s if you dont use the @ sign. HTH > Good day, > [quoted text clipped - 16 lines] > > Evan I was using Visual Basic, and did not believe that to be the problem. I tried anyway, used the @ symbol. That didn't work, so I tried using '\\' instead. Finally, I removed the last field altogether and had just: INSERT INTO LoginInfo (username, password) VALUES ('a', '0cc175b9c0f1b6a831c399e269772661') and the query still failed. I'm totally lost now. Evan > Try > INSERT INTO LoginInfo (username, password, datafile) VALUES ('a', [quoted text clipped - 29 lines] > > > Evan On Jun 21, 4:58 am, ewpat...@gmail.com wrote: > I was using Visual Basic, and did not believe that to be the problem. > I tried anyway, used the @ symbol. That didn't work, so I tried using [quoted text clipped - 7 lines] > > I'm totally lost now. What error are you getting? Have you tried putting username and/or password into [square brackets] in case they are reserved words? Is the username field large enough for the size of the data you're trying to put into it? Is there any validation on the database which is rejecting your data for violating constraints, primary key etc? > Good day, > [quoted text clipped - 16 lines] > > Evan How are you executing this? C# or VB don't know anything about SQL commands. You will have to use some sort of SqlCommand to send this sql-statement to the database. If this is not the problem, show some more code about how you are trying to use it. Hans Kestin > Good day, > [quoted text clipped - 14 lines] > syntax of the statement is invalid. Could someone point out where the > 'syntax' error is? A few things. First, are you building the insert string? If so, are you positive it's building the way you think it is? Always try the sql statement in query analyzer to see if your SQL statement is valid, or if you're building a poor SQL statement. It looks to me like it may be a data type exception, if the second column is of SQL type uniqueidentifier, which is the same thing as a guid. The format looks similar to the uniqueidentifier binary format, which would not have single quotes around it. A uniqueidentifier value in a query should only have single quotes around it when it is in the string format 'xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx'.  SignatureHTH, Kevin Spencer Microsoft MVP Printing Components, Email Components, FTP Client Classes, Enhanced Data Controls, much more. DSI PrintManager, Miradyne Component Libraries: http://www.miradyne.net >> Good day, >> [quoted text clipped - 20 lines] > Always try the sql statement in query analyzer to see if your SQL > statement is valid, or if you're building a poor SQL statement.
Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.