|
|
|
|
 |
|
손님 / 2001-03-21 / 오후 5:26:37 / 211.238.54.100
조회수 : 145
|
| [질문] 겁나게 무서운 에러메시지 |
----------------에러메시지
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'board_idx', table 'MyDB.dbo.MyBoard'; column does not allow nulls. INSERT fails.
/tasp/mysite/write_ok.asp, line 51
----------------해당부분 소스
SQL = "INSERT INTO MyBoard (name,email,homepage,title,content,num,"
SQL = SQL & " readnum,writeday,pwd) VALUES "
SQL = SQL & "('" & name & "'"
SQL = SQL & ",'" & email & "'"
SQL = SQL & ",'" & homepage & "'"
SQL = SQL & ",'" & title & "'"
SQL = SQL & ",'" & content & "'"
SQL = SQL & "," & number
SQL = SQL & ", 0 ,'" & now() & "'" <--라인 51
SQL = SQL & ",'" & pwd & "')"
--------------------------------
|
|
|
