|
ä³ÎÀÌ / 2002-01-09 / ¿ÀÈÄ 4:01:01 / 210.205.142.22
Á¶È¸¼ö : 192
|
[Áú¹®] ÈåÈå Incorrect syntax near ','. ¿¡·¯ |
¾Æ·¡ ¿¡·¯ ¸Þ½ÃÁö´Â ºÐ¸í Ä®·³¼ö¿Í ¸ÅÄ¡°¡ ¾ÈµÇ¾úÀ»¶§ ³ª´Â ¿¡·¯ÀΰɷΠ¾Æ´Âµ¥ ÈåÈåÈå ¿Ö ÀÚ²Ù ÀÌ ¿¡·¯°¡ ³ª´Â Áö »ç¶÷ ¼ÓÀ» Å¿쳻¿ä
------------------¿¡·¯¸Þ½ÃÁö--------------
[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 |
|
|