March 19, 2013 at 11:42 pm
hai friends,
I m currently using sql server 2000 DB for my asp application
my table is
create table ttr
(
startdate datetime,
from_loctn varchar(100),
to_location varchar(100),
Modeoftravel nvarchar(100),
seattype nvarchar(100)
)
Modeoftravel and seattype is dropdownbox. if im choose it ll store value only not name
(ex:
insert into ttr('20-03-2013','abc','dbn','train','IIAC')
but showing my table as
modeoftravel value is 1
seattype value 1
how to modify
March 20, 2013 at 1:32 am
That's going to be an ASP problem, not a TSQL problem. The dropdown must be sending a 1 when generating the TSQL insert statement.
You need to modify the dropdown box properties to write the value rather than the item index number.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy