asp with sql server 2000?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » T-SQL (SS2K8) » asp with sql server 2000?

asp with sql server 2000?

Rate Topic

Display Mode

Topic Options

Author

Message

raghuldrag

Posted Tuesday, March 19, 2013 11:42 PM

SSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 6:24 AM
Points: 99, Visits: 242

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

foxxo

Posted Wednesday, March 20, 2013 1:32 AM

Say Hey Kid

Group: General Forum Members
Last Login: 2 days ago @ 6:13 PM
Points: 712, Visits: 1,053

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 »

Permissions