Problem using CFTextArea

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default Problem using CFTextArea

    I am attempting to add text from a CFTextArea into an MS Access Database table
    field of type Memo and getting an error. The default size for a Text Type field
    in Access is 255 so even if I have the field type set to Memo the maximum size
    of text I can enter using CFTextArea is still 255. Has anyone got around this
    problem before.

    Thanks.

    A_Wilson Guest

  2. Similar Questions and Discussions

    1. How to create linebreaks in cftextarea, format = flash
      I'm using <cfform format="flash">, and I can't figure out how to create a linebreak in the cftextarea form control. For example, in the following...
    2. Can we set anchor style in cftextarea with Flashformat??
      Can we set anchor style in cftextarea with Flash format?? Here is a sample source. <cfform format="flash"> <cftextarea id="txaTest"...
    3. Flash Form cftextarea
      Getting following error ?String literal was not properly terminated? when loading a cfform flash. It?s coming from a cftextarea tag. The user is...
    4. cftextarea control?
      Ok this forum is exactly what I want to try to do, but how do i do it? It will allow me to bold and http://www.cnn.com in a text box. But I have...
    5. How do I ... <cftextarea>
      Try this instead, im not sure why you are getting that error. <cftextarea name='emp_about' style='font-family:Arial, Helvetica, sans-serif;...
  3. #2

    Default Re: Problem using CFTextArea

    Try to use in insert/update queries: tableName.fieldName= <cfqueryparam
    cfsqltype="cf_sql_longvarchar" value="#form.FieldName#">. We did it in Oracle
    for text areas values. If it would not work try to split textarea in several
    smaller ones with max size 255. If this is not appropriate - use a database
    other than Access.

    CF_Oracle Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139