Do you set the "maxsize" attribute in the <input> tag? However, that would
physically limit input length, not truncate "extra" characters.

How did you define your ADO object? It has to be adVarChar of the same
length as defined in the table.

-----Original Message-----
From: ASP Databases digest [mailto:asp_databases@p...]
Sent: Saturday, February 22, 2003 6:03 PM
To: asp_databases digest recipients
Subject: asp_databases digest: February 22, 2003


-----------------------------------------------
When replying to the digest, please quote only
relevant material, and edit the subject line to
reflect the message you are replying to.
-----------------------------------------------

The URL for this list is:
http://p2p.wrox.com/list.asp?list=asp_databases

Get the Readers Advantage price for 
Professional ASP Data Access from Barnes & Noble.
---

http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&bfpid=1861
003927&bfmtype=book

ASP_DATABASES Digest for Saturday, February 22, 2003.

1. RE: How to use access database with double combo
2. Details not stored properly in SQL table
3. Re: Details not stored properly in SQL table

----------------------------------------------------------------------

Subject: RE: How to use access database with double combo
From: "Carl E. Olsen" <carl-olsen@m...>
Date: Fri, 21 Feb 2003 18:28:46 -0600
X-Message-Number: 1



I would use two pages.  The second page would either add or delete a
record from a table in a database, and then redirect back to the first
page after the operation has completed.  I would fill the option list by
cycling through the records in the database table, such as:

While NOT objRS.EOF
<option value="<%= objRS("NameID") %>.html"><%= objRS("Name")
%></option>
objRS.MoveNext
Wend

> -----Original Message-----
> From: radeon [mailto:radeon@s...]
> Sent: Friday, February 21, 2003 2:20 PM
> To: ASP Databases
> Subject: [asp_databases] How to use access database with double combo
> 
> how to i put a Add and Remove button into the double combo so that
when i
> click the Add button,it will add user into the combo box and when i
click
> Remove button it will remove user.
> 
> here is the source
> 
> <form name="doublecombo"><br>
> 
> 
> <p>
> <select name="example" size="1" onChange="redirect
> (this.options.selectedIndex)">
> 
> <option>Mr Yap</option>
> <option>Miss Lee</option>
> <option>Mdm Wong</option>
> </select>
> 
> <select name="stage2" size="1">
> <option value=".html">Assignment 1</option>
> <option value=".html">Assignment 2</option>
> <option value=".html">Assignment 3</option>
> </select>
> 
> <input type="button" name="test" value="Load" onClick="go()">
> </p>
> 
> 
> <script>
> <!--
> 
> var groups=document.doublecombo.example.options.length
> var group=new Array(groups)
> 
> for (i=0; i<groups; i++)
> 
> 	group[i]=new Array()
> 
> 	group[0][0]=new Option("Assignment 1","")
> 	group[0][1]=new Option("Assignment 2",".html")
> 	group[0][2]=new Option("Assignment 3",".html")
> 
> 	group[1][0]=new Option("Assignment Lab 1",".html")
> 	group[1][1]=new Option("Assignment Lab 1",".html")
> 
> 	group[2][0]=new Option("Assignment Tutorial 1",".html")
> 	group[2][1]=new Option("Assignment Tutorial 2",".html")
> 	group[2][2]=new Option("Assignment Tutorial 3",".html")
> 	group[2][3]=new Option("Assignment Tutorial 4",".html")
> 
> var temp=document.doublecombo.stage2
> 
> function redirect(x)
> {
> 	for (m=temp.options.length-1;m>0;m--)
> 
> 		temp.options[m]=null
> 
> 	for (i=0;i<group[x].length;i++)
> 		{
> 			temp.options[i]=new Option(group[x]
> [i].text,group[x][i].value)
> 		}
> 
> 	temp.options[0].selected=true
> }
> 
> function go()
> {
> 	location=temp.options[temp.selectedIndex].value
> }
> //-->
> </script>
> 
> </form>
> 
> 
> 
> 
> 
> 
> to unsubscribe send a blank email to leave-asp_databases-
> 1112136X@p...



----------------------------------------------------------------------

Subject: Details not stored properly in SQL table
From: "Andy" <andy@t...>
Date: Sat, 22 Feb 2003 17:46:12 +0800
X-Message-Number: 2

Hello,

I have below column on one of my SQL server database :

id int(4)
status varchar(255)
username varchar(30)
email varchar(60)
priority char(255)
category varchar(100)
subject varchar(300)
description varchar(8000)
ticdate datetime(8)
url varchar(50)

In my webpage, there is a TEXTAREA box where user input their comment and
then submit details to my asp page that will insert the records to the
database column above.

When I checked on the column description, it only shows the first line of
details from the TEXTAREA box and all the inputs below the first line is not
stored into the description column.


Should I change the description column type or anything?


Thanks for the advice.



Andy


----------------------------------------------------------------------

Subject: Re: Details not stored properly in SQL table
From: Mark Eckeard <meckeard2000@y...>
Date: Sat, 22 Feb 2003 06:56:23 -0800 (PST)
X-Message-Number: 3

Andy,

Please post your code & procedure.

Mark.
--- Andy <andy@t...> wrote:
> Hello,
> 
> I have below column on one of my SQL server database
> :
> 
> id int(4)
> status varchar(255)
> username varchar(30)
> email varchar(60)
> priority char(255)
> category varchar(100)
> subject varchar(300)
> description varchar(8000)
> ticdate datetime(8)
> url varchar(50)
> 
> In my webpage, there is a TEXTAREA box where user
> input their comment and
> then submit details to my asp page that will insert
> the records to the
> database column above.
> 
> When I checked on the column description, it only
> shows the first line of
> details from the TEXTAREA box and all the inputs
> below the first line is not
> stored into the description column.
> 
> 
> Should I change the description column type or
> anything?
> 
> 
> Thanks for the advice.
> 
> 
> 
> Andy
> 
> 


__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/



---

END OF DIGEST