Results 1 to 2 of 2

Thread: sql statement problem

  1. #1
    Join Date
    May 2005

    sql statement problem

    strSQL = "SELECT jobs.Id, jobs.EmailAddress, jobs.JobTitle, jobs.Salary1, jobs.Salary2, jobs.SalaryRateOTE, jobs.SalaryRateIncBen, jobs.SalaryRateProRata, jobs.SalaryRateNegShow, jobs.SalaryRateNegHide, jobs.Town, jobsector.Name AS jobsector, type.Name AS type, per.Name AS per, region.Name AS region FROM jobs, jobsector, type, per, region WHERE jobsector.Id = jobs.jobsectorId AND type.Id = jobs.typeId AND per.Id = jobs.perId AND region.Id = jobs.regionId AND Id=" & lngRecordNo";"

    the problems on that last bit ... Id=" & IngRecordNo";"

    the end statement'ss wrong but i dunno how id put it right...

    could someone help me please.... thanks


  2. #2
    Join Date
    Dec 2004
    ...AND Id=" & lngRecordNo & ";"

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Recent Articles