Int and smalldatetime problems - Urgent

[Nugroho Prasetyo]

I try to input a record to sql server from ASP programs as follow :

Data that I pass :
Insert into Lawyer Values('000001', 'Nugroho Prasetyo', 'NP', 4/5/68, 'Jakarta', 4/1/98, 300.00, '001', 'D.001', 'danika', 'System Administrator', 'Jl. djhasjdhj 10', 'Kdks jkt 13110', '856-6089', '0818-150438', 'inu@pacific.net.id&#39

My table sql :
Use LGSDATA
Go

CREATE TABLE Lawyer
(
lwr_nil char(6) NULL,
lwr_nama char(35) NOT NULL,
lwr_initial char(3) NOT NULL,
lwr_tgllhr smalldatetime NULL,
lwr_tmplhr varchar(40) NULL,
lwr_tglmsk smalldatetime NULL,
lwr_feert numeric(7,2) NULL,
lwr_urut char(3) NOT NULL,
lwr_nminv varchar(30) NULL,
lwr_passwd char(8) NOT NULL,
lwr_jabat char(2) NULL,
lwr_addr1 varchar(30) NULL,
lwr_addr2 varchar(30) NULL,
lwr_phome varchar(14) NULL,
lwr_php varchar(14) NULL,
lwr_email varchar(30) NULL,
)
Go

CREATE UNIQUE CLUSTERED INDEX lwr_urutx ON Lawyer(lwr_urut)
Go


When I pass this sql command to sql server I got an error :

Insert into Lawyer Values('000001', 'Nugroho Prasetyo', 'NP', 4/5/68, 'Jakarta', 4/1/98, 300.00, '001', 'D.001', 'danika', 'System Administrator', 'Jl. djhasjdhj 10', 'Kdks jkt 13110', '856-6089', '0818-150438', 'inu@pacific.net.id&#39

Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[Microsoft][ODBC SQL Server Driver][SQL Server]Operand type clash: int is incompatible with smalldatetime

/admin/reguser.asp, line 125

as long as I know I don't have an Int value in this matter.


There's anybody can help me to fix this problem ???
Help Please ...

Thank's

[Patrick FEDIERE]

In fact when you want to insert date/time it is necessary that the data in the value list of the Insert statement is QUOTED like '4/1/98' or
Insert into Lawyer Values('000001', 'Nugroho
Prasetyo', 'NP', '4/5/68', 'Jakarta', '4/1/98', 300.00,
and it's works ...
Bye

On 1/5/99 9:46:15 AM, Nugroho Prasetyo wrote:
> I try to input a record to sql server from ASP programs as follow :

Data
> that I pass :
Insert into Lawyer Values('000001', 'Nugroho
> Prasetyo', 'NP', 4/5/68, 'Jakarta', 4/1/98, 300.00,
> '001', 'D.001', 'danika', 'System
> Administrator', 'Jl. djhasjdhj 10', 'Kdks jkt 13110',
> '856-6089', '0818-150438',
> 'inu@pacific.net.id&#39

My table sql :
Use LGSDATA
Go

CREATE
> TABLE Lawyer
(
lwr_nil char(6) NULL,
lwr_nama char(35) NOT
> NULL,
lwr_initial char(3) NOT NULL,
lwr_tgllhr smalldatetime
> NULL,
lwr_tmplhr varchar(40) NULL,
lwr_tglmsk smalldatetime
> NULL,
lwr_feert numeric(7,2) NULL,
lwr_urut char(3) NOT
> NULL,
lwr_nminv varchar(30) NULL,
lwr_passwd char(8) NOT
> NULL,
lwr_jabat char(2) NULL,
lwr_addr1 varchar(30)
> NULL,
lwr_addr2 varchar(30) NULL,
lwr_phome varchar(14)
> NULL,
lwr_php varchar(14) NULL,
lwr_email varchar(30)
> NULL,
)
Go

CREATE UNIQUE CLUSTERED INDEX lwr_urutx ON
> Lawyer(lwr_urut)
Go


When I pass this sql command to sql server I got
> an error :

Insert into Lawyer Values('000001', 'Nugroho
> Prasetyo', 'NP', 4/5/68, 'Jakarta', 4/1/98, 300.00,
> '001', 'D.001', 'danika', 'System
> Administrator', 'Jl. djhasjdhj 10', 'Kdks jkt 13110',
> '856-6089', '0818-150438',
> 'inu@pacific.net.id&#39

Microsoft OLE DB Provider for ODBC Drivers
> error '80040e07'

[Microsoft][ODBC SQL Server Driver][SQL
> Server]Operand type clash: int is incompatible with smalldatetime
>

/admin/reguser.asp, line 125

as long as I know I don't have an
> Int value in this matter.


There's anybody can help me to fix this
> problem ???
Help Please ...

Thank's