ASP ERROR while updating

Results 1 to 2 of 2

Thread: ASP ERROR while updating

  1. #1
    Join Date
    Dec 1969

    Default ASP ERROR while updating

    I&#039;ve an update sql statement that works perfect on the query analyzer....but the same statement raises an error when executed on the asp page(connection.execute) do I update a numeric statement is something like this..<BR><BR>update tablename set columnname=&#039;"&variable&"&#039; where some condition....<BR><BR>4 numeric fields i use "&variable&"

  2. #2
    Join Date
    Dec 1969

    Default RE: ASP ERROR while updating

    you dont need to enclose the numeric fields in the quotes:<BR>"update tablename set columnname=" & variable & "where some condition....<BR>this should do.<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