> ¾Æ·¡ ¿¡·¯ ¸Þ½ÃÁö´Â ºÐ¸í Ä®·³¼ö¿Í ¸ÅÄ¡°¡ ¾ÈµÇ¾úÀ»¶§ ³ª´Â ¿¡·¯ÀΰɷΠ¾Æ´Âµ¥ ÈåÈåÈå ¿Ö ÀÚ²Ù ÀÌ ¿¡·¯°¡ ³ª´Â Áö »ç¶÷ ¼ÓÀ» Å¿쳻¿ä
> ------------------¿¡·¯¸Þ½ÃÁö--------------
> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ','.
> /test/pm/bookregist.asp, line 128
>
>
> ------------------ÇØ´çÄõ¸®¹®----------------
> RSQL = "Insert Into ccommodity (ccategorynum,ccode,cname,ccategory,ccompany,cmakename,"
> RSQL = RSQL & "cmakedate,clevel,ccount,size,iunit,cpricein,cpriceout1,cpriceout2,cpriceout3,"
> RSQL = RSQL & "ccontent,warehousein_day,CImageFile,CImageWidth,CImageHeight) VALUES "
> RSQL = RSQL & "('" & cnrs(0) & "'"
> RSQL = RSQL & ",'" & ccode & "'"
> RSQL = RSQL & ",'" & cname & "'"
> RSQL = RSQL & ",'" & ccategory & "'"
> RSQL = RSQL & ",'" & ccompany & "'"
> RSQL = RSQL & ",'" & cmakename & "'"
> RSQL = RSQL & ",'" & cmakedate & "'"
> RSQL = RSQL & ",'" & clevel & "'"
> RSQL = RSQL & ",0,'" & size & "'"
> RSQL = RSQL & ",'" & iunit & "'"
> RSQL = RSQL & "," & cpricein
> RSQL = RSQL & "," & cpriceout1
> RSQL = RSQL & "," & cpriceout2
> RSQL = RSQL & "," & cpriceout3
> RSQL = RSQL & ",'" & date() & "'"
> RSQL = RSQL & ",'" & ccontent & "'"
> RSQL = RSQL & ",'" & file_name & "'"
> RSQL = RSQL & "," & imagewidth
> RSQL = RSQL & "," & imageheight & ")"
>
> dbcon.Execute RSQL
-----------------------------------------------------------
|