Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

asp with sql server 2000? Expand / Collapse
Posted Tuesday, March 19, 2013 11:42 PM


Group: General Forum Members
Last Login: Wednesday, July 27, 2016 4:25 AM
Points: 186, Visits: 473
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
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
Post #1433003
Posted Wednesday, March 20, 2013 1:32 AM



Group: General Forum Members
Last Login: Yesterday @ 9:54 PM
Points: 1,963, Visits: 2,217
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.
Post #1433027
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse