Posted by Erland Sommarskog on 06/08/05 01:11

vbnetrookie (bigjmt@hotmail.com) writes:
> Well thanks alot Martijn,
>
> Thoses extra quotes really made a difference. Now it all works!!
> here's the new string:
> Dim sqlStr As String = "SELECT DISTINCT Last_Name FROM [" & PubName &
> "] WHERE PostalCode ='" & postalcode & "' And Title='" & title & "'
> ORDER BY Last_Name "
>

And now for title enter the following string:

' DROP TABLE [AIM International] --

As a safety precaution, make sure that you have a backup of your database
available.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: Re: Want to grab a list of available databases on a given server
• Prev in forum: Re: Want to grab a list of available databases on a given server
• Thread view: Re: query with a table name that has a space...

[Reply to this message]