|
 |
access_asp thread: plz. help me
Message #1 by "asif hameed" <asifqua@h...> on Fri, 14 Jun 2002 13:10:27 +0000
|
|
<html><div style='background-color:'><DIV> </DIV>
<DIV>i m facing two problems ,</DIV>
<DIV>can anybody solve it, actully i m reading the data from an access table and displaying it into a </DIV>
<DIV>text field and text area.</DIV>
<DIV> </DIV>
<DIV>problem 1)</DIV>
<DIV>if the value contains dpaces in the thable then it is not displaying the complete data, it </DIV>
<DIV>trim the value after space,when i displaying it into text field</DIV>
<DIV>my code is as fallow</DIV>
<DIV> </DIV>
<DIV>response.write "<input type=text name=fn value=" & rs("fname") & ">"</DIV>
<DIV>if fname contains "hello world" ,but it just display hello in the text field</DIV>
<DIV> </DIV>
<DIV>but when i displays it into textarea then it display the whole text </DIV>
<DIV>how can solve this problem</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>problem 2)</DIV>
<DIV> </DIV>
<DIV>my second problem is that how i read the data from a memo field</DIV>
<DIV> </DIV>
<DIV>thanks</DIV>
<DIV> </DIV>
<DIV>asif hameed</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV></div><br clear=all><hr>Join the world?s largest e-mail service with MSN Hotmail.
<a href='http://g.msn.com/1HM500901/158'>Click Here</a><br></html>
Message #2 by jake williamson 28 <jake.williamson@2...> on Fri, 14 Jun 2002 14:28:53 +0100
|
|
i use this on a text field to register when a return has been used:
<%= Replace(yourrecordset("COLNAM").Value, Chr(13), "<br>") %>
so thats basically saying 'if you come across a keystroke Chr(13) replace it
with a <br>.
works ok - can you apply this to what your doing in any way??
cheers,
jake
on 14/6/02 2:10 pm, asif hameed at asifqua@h... wrote:
>
> i m facing two problems ,
> can anybody solve it, actully i m reading the data from an access table and
> displaying it into a
> text field and text area.
>
> problem 1)
> if the value contains dpaces in the thable then it is not displaying the
> complete data, it
> trim the value after space,when i displaying it into text field
> my code is as fallow
>
> response.write "<input type=text name=fn value=" & rs("fname") & ">"
> if fname contains "hello world" ,but it just display hello in the text field
>
> but when i displays it into textarea then it display the whole text
> how can solve this problem
>
>
>
> problem 2)
>
> my second problem is that how i read the data from a memo field
>
> thanks
>
> asif hameed
>
Message #3 by "Peter Rooney" <peter.rooney@w...> on Fri, 14 Jun 2002 14:24:16 +0100
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0014_01C213AF.33FABC70
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
asif,
Try changing:
<input type=text name=fn value=" & rs("fname") & ">
To:
<input type=text name=fn value=""" & rs("fname") & """>
-----Original Message-----
From: asif hameed [mailto:asifqua@h...]
Sent: Friday, June 14, 2002 2:10 PM
To: Access ASP
Subject: [access_asp] plz. help me
i m facing two problems ,
can anybody solve it, actully i m reading the data from an access table and
displaying it into a
text field and text area.
problem 1)
if the value contains dpaces in the thable then it is not displaying the
complete data, it
trim the value after space,when i displaying it into text field
my code is as fallow
response.write "<input type=text name=fn value=" & rs("fname") & ">"
if fname contains "hello world" ,but it just display hello in the text field
but when i displays it into textarea then it display the whole text
how can solve this problem
problem 2)
my second problem is that how i read the data from a memo field
thanks
asif hameed
_____
Join the world's largest e-mail service with MSN Hotmail. HYPERLINK
"http://g.msn.com/1HM500901/158"Click Here
--- Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.368 / Virus Database: 204 - Release Date: 5/29/2002
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.368 / Virus Database: 204 - Release Date: 5/29/2002
Message #4 by s.bussing@i... on Fri, 14 Jun 2002 14:38:13
|
|
Hi asif,
Problem 1.)
You don't use quote arround you your field. So space is considered as end
of the string.
Use this:
response.write "<input type='text' name='fn' value='" & rs("fname") & "'>"
Copy this string and it will work.
Problem 2.)
response.write "<textarea>" & rs("yourmemofield") & "</textarea>"
That's all there is to it.
Goodluck
> <html><div style='background-color:'><DIV> </DIV>
<DIV>i m facing two problems ,</DIV>
<DIV>can anybody solve it, actully i m reading the data from an access
table and displaying it into a </DIV>
<DIV>text field and text area.</DIV>
<DIV> </DIV>
<DIV>problem 1)</DIV>
<DIV>if the value contains dpaces in the thable then it is not displaying
the complete data, it </DIV>
<DIV>trim the value after space,when i displaying it into text field</DIV>
<DIV>my code is as fallow</DIV>
<DIV> </DIV>
<DIV>response.write "<input type=text name=fn value=" & rs("fname")
& ">"</DIV>
<DIV>if fname contains "hello world" ,but it just display hello in the
text field</DIV>
<DIV> </DIV>
<DIV>but when i displays it into textarea then it display the whole text
</DIV>
<DIV>how can solve this problem</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>problem 2)</DIV>
<DIV> </DIV>
<DIV>my second problem is that how i read the data from a memo field</DIV>
<DIV> </DIV>
<DIV>thanks</DIV>
<DIV> </DIV>
<DIV>asif hameed</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV></div><br clear=all><hr>Join the world?s largest e-mail
service with MSN Hotmail. <a href='http://g.msn.com/1HM500901/158'>Click
Here</a><br></html>
Message #5 by "Serge Wagemakers" <swagemakers@d...> on Fri, 14 Jun 2002 16:00:32 +0200
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_005B_01C213BC.9CD0BC60
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi,
Problem 1)
Are you sure you have a space between "hello" and "world" ? Sounds to me
like you might have a Carriage Return and/or a Newline character in your
string. What is your select statement like? What columns do you have
with what kind of datatypes? Did you try to execute the selectstatement
in Access?
Problem 2)
Getchunk(Number_of_bytes)
eg., aVar =3D rs("MemoField").Getchunk(2048)
HTH,
Serge
----- Original Message -----
From: asif hameed
To: Access ASP
Sent: Friday, June 14, 2002 3:10 PM
Subject: [access_asp] plz. help me
i m facing two problems ,
can anybody solve it, actully i m reading the data from an access
table and displaying it into a
text field and text area.
problem 1)
if the value contains dpaces in the thable then it is not displaying
the complete data, it
trim the value after space,when i displaying it into text field
my code is as fallow
response.write "<input type=3Dtext name=3Dfn value=3D" & rs("fname") &
">"
if fname contains "hello world" ,but it just display hello in the text
field
but when i displays it into textarea then it display the whole text
how can solve this problem
problem 2)
my second problem is that how i read the data from a memo field
thanks
asif hameed
-------------------------------------------------------------------------
-----
Join the world's largest e-mail service with MSN Hotmail. Click Here
--- Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
|
|
|
View Cart
