sql query/code problem

Results 1 to 2 of 2

Thread: sql query/code problem

  1. #1
    Join Date
    Dec 1969

    Default sql query/code problem

    ola,<BR>i have made a description page with people details and a photograph. My database contains 2 table - people and photo. SQL below - <BR>SQLQuery="Select * from people, photos where ID = " & CInt(Request.QueryString("ID")) & ";"<BR><BR>This does not work for the photo - it write images/pablo.jpg and in all pages not the one with pablo. how do i get phot to appear and only with pablo?<BR>(ID is in &#039;people&#039; table)

  2. #2
    Join Date
    Dec 1969

    Default RE: sql query/code problem

    Theres a coma after the table you want to read from and I dont see where you ended your sql statment. try this<BR>sql="select * from people where ID=&#039;" & request("ID") & "&#039;"

Posting Permissions

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