Retrieving Strings from a recordset

Results 1 to 2 of 2

Thread: Retrieving Strings from a recordset

  1. #1
    Join Date
    Dec 1969

    Default Retrieving Strings from a recordset

    I have a problem with retrieving a string field from a database. My recordset opens fine, and loops through all the records except for one little problem. When I save the value of a field into another name for use later, it only saves the first word of the field. For example:<BR><BR>&#060;%Category=Server.HTMLEncode( objRS.fields("Category").value)%&#062;<BR><BR>If the value of Category in the objRS recordset is "Travel & Tourism", my variable Category only shows it as "Travel". How do I convert this to hold the whole name? I want to use it in a table heading later in the page, and am confused....<BR><BR>Any help is appreciated.<BR><BR>Heather<BR>

  2. #2
    Join Date
    Dec 1969

    Default ASPFAQs, category FORMS

    The link to the ASPFAQs is at the top right of this and most every page on this site.<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