SQL text type and recordsets

Results 1 to 2 of 2

Thread: SQL text type and recordsets

  1. #1
    Join Date
    Dec 1969

    Default SQL text type and recordsets

    Hi,<BR>I am tring to update a SQL text value using recordsets.<BR><BR>Set detailsForCopyRS = Server.CreateObject("ADODB.Recordset")<BR>detailsF orCopyRS.Open sCopySQL, conStr, 0, 1<BR>detailsForUpdateRS.movefirst<BR>detailsForUpd ateRS("content_type") = request.form("sContentType")<BR>detailsForUpdateRS ("topic_name") = cstr(request.form("sTopicName"))<BR>&#039;this is the text value<BR>detailsForUpdateRS("topic_content") = cstr(request.form("registeredUser"))<BR>detailsFor UpdateRS.update<BR><BR>when I look in the database the column &#039;topic_content&#039; has the value &#039;0&#039; in it and not what hase been passed from the form.<BR><BR>Any ideas about how to update a text value using a recordset???

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL text type and recordsets

    Check what value your getting <BR>cstr(request.form("registeredUser"))<BR>befo re you execute the update statement.<BR><BR>- Raghavendra

Posting Permissions

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