|
|
|
|
²ÀÁö / 2001-09-07 / ¿ÀÈÄ 3:56:02 / 147.6.140.128
Á¶È¸¼ö : 124
|
[Áú¹®] Å×À̺í Çü½Ä Á» ºÁÁÖ¼¼¿ä....¹ú·¹°¡ ´ýºµç°Í °°¾Æ¿ä.. |
> Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting character string to smalldatetime data type.
>
> /buildingsite/kwanak/write_ok.asp, line 69
>
>
> ¾Æ¾Æ¾Æ¾Æ¾Æ
> ¿À´Ãµû¶ó ODBC°¡ ¹«Ã´À̳ª °í»ý½Ãŵ´Ï´Ù.
> ....
> SQL = SQL & ",'" & b_re_level & "'"
> SQL = SQL & ",'" & b_pwd & "')"
>
>
>
> db.Execute SQL <--------69 LINE
>
> rs.Close
> db.Close
> .......
>
> [TABLE] ¿ µ¥ÀÌÅÍÇü½Ä ±æÀÌ
> b_board_idx int 4
> b_name varchar 10
> b_subject " 60
> b_content " 50
> b_writeday smalldatetime 4
> b_visit int 4
> b_pwd nvarchar 10
> b_num int 4
> b_email char 50
> b_tag char 50
> b_ref int 4
> b_re_step int 4
> b_re_level int 4
> ÀÌ»ó ÀÌ·¸°Ô ¸¸µé¾ú´Âµ¥¿ä...
> b_writeday¿¡ Çü½ÄÀÌ Æ²·È½À´Ï±î??
> ¸Â´Ù°í »ý°¢ÀÌ µå´Âµ¥......
> Çѹø ºÁÁÖ¼¼¿ä....
>
>
>
>
>
>
>
-----------------------------------------------------------
b_writedayÄ÷³ÀÇ µ¥ÀÌÅÍ ÇüÀÌ smallintÇüÀε¥, °Å±â´Ù ÀÏ¹Ý ¹®ÀÚ¿¸¦ Áý¾î ³ÖÀ¸·Á±¸ Çϼ̳׿ä..
Getdate()ÇÔ¼ö¸¦ ÀÌ¿ëÇغ¸½Ã°Å³ª, ¾Æ´Ô ƯÁ¤³¯Â¥¸¦ ³Ö°íÀÚ ÇÑ´Ù¸é Convert()ÇÔ¼ö¸¦ ÀÌ¿ëÇÏ¿© °¡°øÈÄ ÀμƮ¸¦ ÇØ º¸½Ê½Ã¿ä.. |
|
|
|