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

    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.


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

    SELECT * FROM areadining WHERE CITYCATEGORY = 'Montezuma'


Posting Permissions

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