SQL query problem

Results 1 to 3 of 3

Thread: SQL query problem

  1. #1
    Madonna Guest

    Default SQL query problem

    The following is my SQL statement. The problem is that instead of replacing the old value of the record it appends the new value to the old value. So in my database I have old telephone number, new telephone number, etc.<BR>I would appreciatiate anyone&#039;s help on this one...<BR><BR>strSQL= "UPDATE Customer SET telephone = &#039;"&telephone&"&#039; WHERE customerName=&#039;"&coName&"&#039;"<BR><BR>objCon n.Execute strSQL<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL query problem

    check your variables witha response.write before you execute this statement - the statement looks fine - are you sure your variables dont include the old numbers etc...

  3. #3
    Madonna Guest

    Default RE: SQL query problem

    When I response.write it includes the old numbers...<BR>So how do i get rid of the old numbers!

Posting Permissions

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