Results 1 to 5 of 5

Thread: Probable an easy select problem[RESOLVED]

Threaded View

  1. #1

    Thread Starter
    Frenzied Member FishGuy's Avatar
    Join Date
    Mar 2005
    Location
    Bradford UK
    Posts
    1,708

    Resolved Probable an easy select problem[RESOLVED]

    Morning All,
    I have the following sql statement which although is selecting a few fields it is still relativley simple
    Code:
         Me.SqlSelectCommand1.CommandText = "SELECT Quotations.[Enquiry Number], Quotations.Price, Quotations.NeworRecon AS Co" & _
            "ndition, Quotations.QuoteValidity, Quotations.InstallationPeriod, Quotations.Ext" & _
            "ension, Quotations.StairliftType, Quotations.FirstName, Quotations.Surname, Quot" & _
            "ations.QuoteRequested, Quotations.QuoteSent, Appointments.TITLE, Appointments.IN" & _
            "ITIAL, Appointments.NAME, Appointments.ROAD, Appointments.VILLAGE, Appointments." & _
            "TOWN, Appointments.COUNTY, Appointments.POSTCODE, Appointments.[ENQUIRY  NUMBER]" & _
            ", Quotations.ID, Quotations.Quantity, Quotations.Make AS Make, Quotations.Model," & _
            " Quotations.Platform AS Platform, Quotations.Automatic AS Automatic, Quotations." & _
            "Hinge AS Hinge, Quotations.Joint AS Joint, Appointments.TITLE & ' ' & Appointments.NAME  FROM Quotations INNER JOIN Appointments ON Quotations.[E" & _
            "nquiry Number] = Appointments.[ENQUIRY  NUMBER] WHERE (Quotations.QuoteRequested" & _
            " = 1) AND (Quotations.QuoteSent = 0)"
    It is because i inserted the firstname & ' ' & surname line that i am getting the error "Operator equals boolean AND, type equals varchar at execute reader" ???
    Does anyone know what is going wrong in this pls?
    Last edited by FishGuy; May 27th, 2005 at 05:42 AM. Reason: resolved

Posting Permissions

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



Click Here to Expand Forum to Full Width