Results 1 to 3 of 3

Thread: problem with a query

  1. Feb 27th, 2007, 08:27 AM #1
    k3pos
    k3pos is offline

    Thread Starter
    Addicted Member
    Join Date
    Feb 2007
    Posts
    148

    problem with a query

    Help,

    Code:
    Rstring = "select * from `custmers`"
    DBr.Open Rstring
    what is the problem here??

    i see no problem and the softwere says its illegle.

    -k3pos
    Reply With Quote Reply With Quote
  2. Feb 27th, 2007, 09:39 AM #2
    LinXG
    LinXG is offline
    Hyperactive Member
    Join Date
    Jun 2006
    Posts
    396

    Re: problem with a query

    Your SQL string should be...

    Rstring = "select * from custmers"
    assuming also that that is the way you spell customers.

    You use ' marks in most SQL queries to show text values, for example

    Code:
    Rstring = "SELECT * FROM custmers WHERE custmer_name = 'Jones' "
    Reply With Quote Reply With Quote
  3. Feb 27th, 2007, 09:51 AM #3
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: problem with a query

    If you are using ADO, you need to add the connection object
    Code:
    Rstring = "select * from `custmers`"
    DBr.Open Rstring, ConnObjectGoesHere
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width