Updating a large text field (SQLServer 2000) using

Results 1 to 2 of 2

Thread: Updating a large text field (SQLServer 2000) using

  1. #1
    Join Date
    Dec 1969

    Default Updating a large text field (SQLServer 2000) using

    I&#039;m trying to save a text field larger than a standard VBScript Variant/String. The field in SQLServer 2000 is of type "text" and can handle the input, however I theSQL string I&#039;m building is too large.<BR><BR>I&#039;ve been away from ADO/ASP for a while. If I remember correctly, there are ADO methods that could handle the request directly. I&#039;ve looked around and can&#039;t find an example.<BR><BR>Can anyone help?<BR><BR>Thank you.<BR>Steve<BR><BR>Currently:<BR><BR>Dim sSQL<BR><BR>&#039; Build update stmt<BR>sSQL = "UPDATE LANDSCAPE_DETAIL SET landscape=&#039;" & request("landscapeDetailValue") & _<BR> "&#039;, USER_MODIFIED = " & session("USER_ID") & " WHERE LANDSCAPE_DETAIL_ID = " & iLandscapeDetailID<BR> <BR>&#039; execute SQL<BR>Set dbconn = Server.CreateObject("ADODB.Connection")<BR>dbconn. Open connODBC<BR>set rs = dbconn.Execute(sSQL)<BR><BR>&#039;clean up<BR>set sSQL = nothing<BR>&#039;rs.close<BR>set rs = nothing<BR>dbconn.close<BR>set dbconn = nothing<BR> <BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default Propert way to do this


Posting Permissions

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