|
|||||||
| Code Review Antionline community members can use this section of the site to post code for sharing and testing. |
 |
|
|
Thread Tools | Display Modes |
February 23rd, 2010, 05:11 PM
|
#1 |
|
Member
Join Date: Oct 2003
Posts: 81
 |
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 |
|
|
|
February 23rd, 2010, 06:38 PM
|
#2 |
|
Gonzo District BOFH
Join Date: Jan 2006
Location: SW MO
Posts: 888
 |
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 |
|
|
|
|
February 23rd, 2010, 11:13 PM
|
#3 |
|
Senior Member
Join Date: Jun 2002
Location: Ozz.
Posts: 257
|
Upload the image to an externale image host, as unfortunatly the image size guidelines here are awfully stupid.
 http://imageshack.us 
|
|
|
|
|
February 24th, 2010, 10:24 AM
|
#4 |
|
AO's Filibustier
Join Date: Nov 2008
Location: Swamps of Jersey
Posts: 371
|
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'
__________________
In God We Trust....Everything else we backup. Last edited by Cheap Scotch Ron; February 24th, 2010 at 10:38 AM.. |
|
|
|
|
| Bookmarks |
«
Previous Thread
|
Next Thread
»
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| SQL Tutorial – Basics | mikester2 | Other Tutorials Forum | 5 | January 31st, 2005 12:16 PM |
| SQL Tutorial | ch4r | Other Tutorials Forum | 5 | January 18th, 2005 07:20 AM |
| Foot Printing with Host | SonofGalen | The Security Tutorials Forum | 7 | February 9th, 2004 10:14 AM |
| Heads Up - Cumulative Patch for Microsoft SQL Server (815495) | CXGJarrod | Microsoft Security Discussions | 0 | July 23rd, 2003 10:00 PM |
| SQL Sapphire Worm Analysis | s0nIc | AntiVirus Discussions | 2 | January 27th, 2003 11:23 AM |
All times are GMT +1. The time now is 11:57 AM.