Help with SQL Statement

Results 1 to 4 of 4

Thread: Help with SQL Statement

  1. #1
    Axelrod Guest

    Default Help with SQL Statement

    Is there anything obvious wrong with this SQL Statement? Ths variable works, and the line breaks are OK in real life. I&#039ve got a field name - CentreID - that is used twice, but it is referred to by its field name each time.<BR><BR>strSQL = "SELECT Centres.Password, ProjServices.* FROM Centres INNER JOIN ProjServices ON Centres.CentreID = ProjServices.CentreID WHERE Centres.Password = &#039" & strPassword & "&#039"<BR><BR>

  2. #2
    salli Guest

    Default RE: Help with SQL Statement

    It might be your ProjServices.*<BR><BR>I&#039ve had trouble with * before. Try calling out the field names you want from this table instead.

  3. #3
    Axelrod Guest

    Default Fraid not...

    I tried doing this and get the same error ( Too few parameters. Expected 1. )<BR>

  4. #4
    salli Guest

    Default RE: Fraid not...

    This usually means you&#039re trying to call a field which doesn&#039t exist in the database - check all your field names are spelled correctly.

Posting Permissions

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