www.webdeveloper.com
Results 1 to 2 of 2

Thread: sql statement problem

  1. #1
    Join Date
    May 2005
    Posts
    76

    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

    dan

  2. #2
    Join Date
    Dec 2004
    Posts
    8,637
    ...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