Solved

VS 2008 Web Developer

Posted on 2009-05-04
3
191 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 500 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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
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.

738 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