asp with sql server 2000?

• raghuldrag

  Hall of Fame

  Points: 3160

  More actions

  March 19, 2013 at 11:42 pm

  #291253

  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

• Andrew G

  SSChampion

  Points: 12809

  More actions

  March 20, 2013 at 1:32 am

  #1598740

  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.