|
 |
asp_ado_rds thread: adding more than 255 characters in sql through asp
Message #1 by "arnab" <arnab2410@a...> on Thu, 4 Oct 2001 12:50:33
|
|
Hi
To all programmers
i have a little problem..
<TEXTAREA cols=15 name=cbrief rows=7 wrap=true><%=trim(rs("brief"))%>
</TEXTAREA></td>
i am updating this brief field which is amemo type in access.
but while updating if i pass a brief more than 50 character it won't add
where as the field type is memo. but if i pass less than 50 then it what
works fine and update properly.this is happening if i am working on my pc
or doing the same thing in online
thanks
arnab
Message #2 by <mail_nkkamath@y...> on Thu, 4 Oct 2001 20:55:27 -0700 (PDT)
|
|
hi arnab,
you have not specified whether the the data being
added contains spaces or no.
and if the data that has got saved to the backend does
so with the embedded spaces.
The problem may either be due to the spaces within the
words that you are trying to save just check this up,
if so then better save the entire data that you are
bringing from the recordset within double quotes so as
to include the entire data with embedded spaces.
I doubt whether the 50 characters that you have
specified has got anything as such, but still give
this a try.
bye
Narasimha
--- arnab <arnab2410@a...> wrote:
> Hi
> To all programmers
> i have a little problem..
> <TEXTAREA cols=15 name=cbrief rows=7
> wrap=true><%=trim(rs("brief"))%>
> </TEXTAREA></td>
>
> i am updating this brief field which is amemo type
> in access.
> but while updating if i pass a brief more than 50
> character it won't add
> where as the field type is memo. but if i pass less
> than 50 then it what
> works fine and update properly.this is happening if
> i am working on my pc
> or doing the same thing in online
> thanks
> arnab
Message #3 by "arnab" <arnab2410@a...> on Fri, 5 Oct 2001 09:49:26
|
|
> hi arnab,
> you have not specified whether the the data being
> added contains spaces or no.
> and if the data that has got saved to the backend does
> so with the embedded spaces.
> The problem may either be due to the spaces within the
> words that you are trying to save just check this up,
> if so then better save the entire data that you are
> bringing from the recordset within double quotes so as
> to include the entire data with embedded spaces.
> I doubt whether the 50 characters that you have
> specified has got anything as such, but still give
> this a try.
>
> bye
> Narasimha
>
>
hi Narasimha
i forget to wrote that there are spaces in text that i am passing in the
field.i'll try what you have said .
thanks
arnab
|
|
|
View Cart
