Results 1 to 4 of 4

Thread: SQL Query help

  1. #1

    SQL Query help

    Im trying to create an SQL query but get the following error

    Can anyone please help ?

    All I want to do is display the name of everything where the parent is named "01 - PRIME Wave 1"

    if anyone can also tell me how I do it for several parents also would be good

    Thanks
    Attached Images Attached Images

  2. #2
    Gonzo District BOFH westin's Avatar
    Join Date
    Jan 2006
    Location
    SW MO
    Posts
    1,187
    Maybe I am getting old, but I had some trouble reading that. Could you post the text from the error into the thread?
    \"Those of us that had been up all night were in no mood for coffee and donuts, we wanted strong drink.\"

    -HST

  3. #3
    HYBR|D
    Guest
    Upload the image to an externale image host, as unfortunatly the image size guidelines here are awfully stupid.

    http://imageshack.us


  4. #4
    AO's Filibustier Cheap Scotch Ron's Avatar
    Join Date
    Nov 2008
    Location
    Swamps of Jersey
    Posts
    378
    Assuming you are using MS SQLServer (image not clear), change the SQL to use single quotes.

    e.g.

    Select NameColumn from MetaTable where NameColumn = '01 - PRIME Wave 1'
    Last edited by Cheap Scotch Ron; February 24th, 2010 at 11:38 AM.
    In God We Trust....Everything else we backup.

Similar Threads

  1. SQL Tutorial – Basics
    By mikester2 in forum Other Tutorials Forum
    Replies: 5
    Last Post: January 31st, 2005, 01:16 PM
  2. SQL Tutorial
    By ch4r in forum Other Tutorials Forum
    Replies: 5
    Last Post: January 18th, 2005, 08:20 AM
  3. Foot Printing with Host
    By SonofGalen in forum The Security Tutorials Forum
    Replies: 7
    Last Post: February 9th, 2004, 11:14 AM
  4. Heads Up - Cumulative Patch for Microsoft SQL Server (815495)
    By CXGJarrod in forum Microsoft Security Discussions
    Replies: 0
    Last Post: July 23rd, 2003, 10:00 PM
  5. SQL Sapphire Worm Analysis
    By s0nIc in forum AntiVirus Discussions
    Replies: 2
    Last Post: January 27th, 2003, 12:23 PM

Posting Permissions

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