cLng or not?

Results 1 to 2 of 2

Thread: cLng or not?

  1. #1
    Join Date
    Dec 1969

    Default cLng or not?

    Here is my code: <BR><BR>live_new = CLNG(Request("live_new"))<BR><BR> strSQL5 = "UPDATE site_pics SET live =&#039;y&#039; WHERE pic_id IN (" & live_new & ") "<BR> <BR> objConn.Execute strSQL5 <BR><BR>I know I&#039;m getting the live_new from a response.write but in my db I have is set as a Long Integer so I put the cLng on the request that&#039;s coming in. It runs through the code with no error but the pic_id doesn&#039;t get updated. Any ideas? Thanks in advance

  2. #2
    Join Date
    Dec 1969

    Default Response.Write strSQL5...

    ...and tell us what is thus displayed.<BR><BR>Why are you using IN ( ... ) if the value of live_new is a single integer??? Why not just = ... ??? (Though it should work, anyway.)<BR><BR>

Posting Permissions

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