Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

asp with sql server 2000? Expand / Collapse
Author
Message
Posted Tuesday, March 19, 2013 11:42 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 21, 2014 11:33 PM
Points: 172, Visits: 427
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
Post #1433003
Posted Wednesday, March 20, 2013 1:32 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 7:29 PM
Points: 1,236, Visits: 1,718
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