Results 1 to 5 of 5

Thread: SQL Statement - what the

  1. Apr 30th, 2003, 02:38 AM #1
    Beacon
    Beacon is offline

    Thread Starter
    PowerPoster Beacon's Avatar
    Join Date
    Jan 2001
    Location
    Pub Floor
    Posts
    3,188

    SQL Statement - what the

    Hey All,

    Any idea what's wrong?
    Half asleep i know i've missed something.

    VB Code:
    1. strSQL = "Select * FROM tbl_Part WHERE [Model] LIKE '%" & Replace(varSearch, "'", "''") & "%' " _

    2.         & "OR PartNumber LIKE '%" & Replace(varSearch, "'", "''") & "%' " _

    3.         & "OR Description LIKE '%" & Replace(varSearch, "'", "''") & "%' " _

    4.         & "AND Country ='Australia';"

    This returns all records regardless of the Country??
    Reply With Quote Reply With Quote
  2. Apr 30th, 2003, 03:18 AM #2
    CVMichael
    CVMichael is offline
    PowerPoster
    Join Date
    Feb 2002
    Location
    Canada, Toronto
    Posts
    5,803
    Put all the ORs in brackets:

    Code:
    strSQL = "Select * FROM tbl_Part WHERE ( [Model] LIKE '%" & Replace(varSearch, "'", "''") & "%' " _
		& "OR PartNumber LIKE '%" & Replace(varSearch, "'", "''") & "%' " _
		& "OR Description LIKE '%" & Replace(varSearch, "'", "''") & "%' " _
		& ") AND Country ='Australia';"
    Reply With Quote Reply With Quote
  3. Apr 30th, 2003, 03:28 AM #3
    Wokawidget
    Wokawidget is offline
    Super Moderator Wokawidget's Avatar
    Join Date
    Nov 2001
    Location
    Headingly Occupation: Classified
    Posts
    9,632
    Yes, that is correct. You have OR statement in there....you need to put brackets around them, ie:
    Code:
    SELECT * 
FROM tblUsers
WHERE (Username = 'Moose' OR Username = 'Badger') AND Banned = 0
    Does that help?

    Woka
    My .NET Tutorials:
    • Silverlight Enabled WebPart in WSS

    My VB.NET Code Examples:
    • Create IIS Virtual Directory • Validate Login Against Active Directory • Automatically retrieve Identity field value from inserted DataRow using SQL Server and ADO.NET

    My ASP.NET Code Examples:
    • Login To Website (Forms Authentication) • Login To Website (Custom Authentication)

    My VB6 Code Projects:
    • Multithreading In VB6 • Custom Tooltips • Multi Language Support • Item Selector Control • Annimated Systray Icon • Simple Effective Graph Control • Download From Web • LiveUpdate, download application updates from the web automatically • Systray Notification Messages • Skin A Form • API Timer • Badger Messenger, an MSN clone that uses the MSN Network • Wokawidgets VB6 Component Suite
    Reply With Quote Reply With Quote
  4. Apr 30th, 2003, 03:35 AM #4
    Beacon
    Beacon is offline

    Thread Starter
    PowerPoster Beacon's Avatar
    Join Date
    Jan 2001
    Location
    Pub Floor
    Posts
    3,188
    Beautiful thanks guys.

    Too many things going on shoulda known that.

    b
    Reply With Quote Reply With Quote
  6. Apr 30th, 2003, 03:39 AM #5
    swatty
    swatty is offline
    Frenzied Member swatty's Avatar
    Join Date
    Aug 2002
    Location
    somewhere on earth
    Posts
    1,478

    RESOLVED ?
    Code:
    If Question = Incomplete Then
   AnswerNextOne
Else
   ReplyIfKnown
End If
    cu Swatty
    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