Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

VS 2008 Web Developer

Posted on 2009-05-04
3
Medium Priority
?
196 Views
Last Modified: 2013-11-27
I am new to Visual Studio Web Developer 2008. Can any one tell me why the very simple insert query gives me an error, please see attached file.
VSerr.jpg
0
Comment
Question by:rbrindisi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 9

Expert Comment

by:ezraa
ID: 24298052
you need to put the values in quotes:
Insert into table (field) values ("value")
0
 
LVL 9

Accepted Solution

by:
ezraa earned 2000 total points
ID: 24298065
corrected code:
insert into Table1 (city, state, country) values ('lodi','nj','usa')

Open in new window

0
 

Author Closing Comment

by:rbrindisi
ID: 31577698
That worked, thank you.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question