DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 5 of 5

Thread: Query Question

  1. #1
    Shawn M Guest

    Query Question


    I have a query that is hanging me up, so I am looking for help.

    I am pulling form a fox-pro table and putting the data in a sql server 6.5
    table, with a query to see if it exists already or not, then add it to the
    table.

    my program errors out on a
    SELECT * FROM trans_country WHERE Country='People's Rep Korea'

    I know this can go into the database but the query to search for it isn't
    working due to the multiple single quotes.

    Any suggestions would be appreciated?

  2. #2
    Shawn M Guest

    Re: Query Question


    "DaveSatz" <davidsatz@yahoo.com> wrote:
    >SELECT * FROM trans_country WHERE Country="People's Rep Korea"


    I create this select string from a list on another database, and I do this
    suggestion and I get an error in my select "Invalid Column Name" from the
    exception engine in my VC++ application on the open of the record set that
    contains the select statement.

    Any Other Suggestions?

  3. #3
    DaveSatz Guest

    Re: Query Question

    SELECT * FROM trans_country WHERE Country="People's Rep Korea"

    --
    Thanks,
    David Satz
    Principal Software Engineer
    Hyperion Solutions
    ->Using SQL Server 7.0 SP2/6.5 SP5a/Cold Fusion 4.5.1/ADO 2.1/VB 6.0/MTS
    (Please reply to group)
    -----------------------------------------------------------------

    "Shawn M" <smiller@duke.com> wrote in message
    news:39fddaf6$1@news.devx.com...
    >
    > I have a query that is hanging me up, so I am looking for help.
    >
    > I am pulling form a fox-pro table and putting the data in a sql server 6.5
    > table, with a query to see if it exists already or not, then add it to the
    > table.
    >
    > my program errors out on a
    > SELECT * FROM trans_country WHERE Country='People's Rep Korea'
    >
    > I know this can go into the database but the query to search for it isn't
    > working due to the multiple single quotes.
    >
    > Any suggestions would be appreciated?




  4. #4
    DaveSatz Guest

    Re: Query Question

    SET QUOTED_IDENTIFIER OFF
    before executing select

    "Shawn M" <smiller@duke.com> wrote in message
    news:39fddfbd$1@news.devx.com...
    >
    > "DaveSatz" <davidsatz@yahoo.com> wrote:
    > >SELECT * FROM trans_country WHERE Country="People's Rep Korea"

    >
    > I create this select string from a list on another database, and I do this
    > suggestion and I get an error in my select "Invalid Column Name" from the
    > exception engine in my VC++ application on the open of the record set that
    > contains the select statement.
    >
    > Any Other Suggestions?




  5. #5
    dsl Guest

    Re: Query Question



    SELECT * FROM trans_country WHERE Country='People''s Rep Korea'

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center