Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 1.0 and 1.1 > ASP.NET 1.0 and 1.1 Basics
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
ASP.NET 1.0 and 1.1 Basics ASP.NET discussion for users new to coding in ASP.NET 1.0 or 1.1. NOT for the older "classic" ASP 3 or the newer ASP.NET 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 1.0 and 1.1 Basics section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old December 14th, 2007, 06:13 AM
Registered User
 
Join Date: Dec 2007
Location: , , .
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to cannielynn0312 Send a message via Yahoo to cannielynn0312
Default Space in my database table Access

i have a textarea called CommentPCWFlow for the user to key in their comment.


But when i save the form to the database the value stored is only part of the key in value.

Example:
the user key in:
THE TEXT IS YOU.

Data stored in database table:
THE

i set the data type properties as TEXT.
i tried to keyin 123 abc


My code:

<td height="45" valign=top class="style22" style="border-style: solid"><%=textPC2FlowComment%>
                    <input type=hidden textarea name="CommentPCWFlow" value =="<%=textPC2FlowComment%>"></td>

in some other fields i encountered an extra symbol such as " in my stored data in database table.

im using asp, & access & jsp( for validation)
im a newbie in web application programming & ASP.

what should i checked?

  #2 (permalink)  
Old December 18th, 2007, 06:58 PM
Friend of Wrox
Points: 2,101, Level: 18
Points: 2,101, Level: 18 Points: 2,101, Level: 18 Points: 2,101, Level: 18
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2003
Location: , , .
Posts: 599
Thanks: 6
Thanked 3 Times in 3 Posts
Default

Hi,

You're input code looks a little strange. I think it should be:

<input type=textarea name="CommentPCWFlow" value="<%=textPC2FlowComment%>">

You don't need to have a hidden input. You can just write the value in the database directly to the textarea. Hmmm. Plus I haven't seen your code to capture the values or how you're inserting. Its usually something very simple.

Good luck,
Richard

  #3 (permalink)  
Old December 24th, 2007, 04:06 AM
Registered User
 
Join Date: Dec 2007
Location: , , .
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to cannielynn0312 Send a message via Yahoo to cannielynn0312
Default

Hi,

this is my coding to pass the value to the database.
this is java script:

rsCommon.Fields("PCWFlowComment") = Request.Form("CommentPCWFlow")
    if Request.Form("CommentPCWFlow") <> "" then
    rsCommon.Fields("PCWFlowComment") = Request.Form("CommentPCWFlow")
    else
    rsCommon.Fields("PCWFlowComment") = null
    end if

  #4 (permalink)  
Old December 26th, 2007, 12:49 PM
Friend of Wrox
Points: 2,101, Level: 18
Points: 2,101, Level: 18 Points: 2,101, Level: 18 Points: 2,101, Level: 18
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2003
Location: , , .
Posts: 599
Thanks: 6
Thanked 3 Times in 3 Posts
Default

Are you sure you're using javascript?

You don't need this logic. Its not helping you in any way. No matter what the value is all you're doing it setting
rsCommon.Fields("PCWFlowComment") = Request.Form("CommentPCWFlow").

rsCommon.Fields("PCWFlowComment") = Request.Form("CommentPCWFlow")
    if Request.Form("CommentPCWFlow") <> "" then
    rsCommon.Fields("PCWFlowComment") = Request.Form("CommentPCWFlow")
    else
    rsCommon.Fields("PCWFlowComment") = null
    end if

Try going back to basics. Create a page with one Text Area and post it to your insert page. Look in the database and see what got inserted. Is this an Access database? Post your INSERT query here. Also, this is a .NET forum and your code looks like classic ASP which is another forum.




  #5 (permalink)  
Old December 27th, 2007, 06:02 AM
Registered User
 
Join Date: Dec 2007
Location: , , .
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to cannielynn0312 Send a message via Yahoo to cannielynn0312
Default

Thanks.

Thatcoding is in ASP classic.
Yup. its classic ASP + Access database.
ok i'll post it in Classic ASP beginner forum.


 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to sql database access two table ants Beginning VB 6 1 September 21st, 2008 12:33 PM
copy table from one access database to another acc fabdulla SQL Language 5 November 21st, 2007 11:13 AM
Access Database and Large Excel Table xpromac MySQL 1 October 24th, 2006 05:38 PM
removing unwanted space below table ngvietanh HTML Code Clinic 1 August 24th, 2006 10:28 AM
Remove Space from table records mateenmohd SQL Server 2000 1 July 20th, 2003 06:55 AM



All times are GMT -4. The time now is 02:57 PM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.