Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2005
    Posts
    24

    Microsoft ASp.NET Web Matrix - Bugs?

    Hi. I'm developing some tables in a database using Web Matrix in an effort to update a website I do, and am experiencing some problems. One of my tables is called "areadining". The column headings are CODE, CITYCATEGORY, NAME, ADDRESS, CITY, STATE, ZIP, and PHONE. The records I'm using under CITYCATEGORY are Montezuma, Oglethorpe, and Ellaville. When I run a Test Query, I'm using SELECT * FROM areadining WHERE CITYCATEGORY = "MONTEZUMA". I've also tried running:

    SELECT * FROM areadining WHERE CITYCATEGORY = "Montezuma"

    When I try to run the test query, I get an error, Invalid Column=Montezuma. Montezuma is NOT of my column headings. What gives?

    Any help will be appreciated.

    Ken

  2. #2
    Join Date
    Mar 2004
    Location
    Atlanta, GA
    Posts
    58
    I am sure that you should wrap Montezuma in single quotes. It should look like this:

    SELECT * FROM areadining WHERE CITYCATEGORY = 'Montezuma'

    Shannon

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •