|
|
ÇöÀçÀ§Ä¡: ¸ÞÀÎ ÇØÇÇÆ÷·³ À¥µðºñ : °Ô½Ã¹° Àбâ |
|
  2001-09-17 (21:52:07) from 61.255.229.155 |
|
|
  ÀÛ¼ºÀÎ : ys4874 |
Á¶È¸¼ö : 3178    |
|
Á¦¸ñ : mssql¿¡¼ µÎ Å×À̺íÀ» µ¿½Ã¿¡ update ÇÒ·Á¸é ¾î¶»°Ô... |
asp ½ºÅ©¸³Æ®¿¡¼ ¾Æ·¡¿Í °°ÀÌ ÀÛ¼ºÇߴµ¥... <% Set db = Server.CreateObject("ADODB.Connection") db.open ("DSN=stussDB;UID=sa;PWD=;") SQL = "Select * from student, li_Record ON student.st_no = li_Record.st_no WHERE student.st_no = " &request("st_no") Set rs=Server.CreateObject("ADODB.Recordset") rs.Open SQL, db %>
À¥ ºê¶ó¿ìÀú¿¡¼ ´ÙÀ½°ú °°Àº ¿¡·¯ ¸Þ½ÃÁö°¡ ³ª¿É´Ï´Ù. Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'ON'. /test/st_rec_update.asp, line 6
¿¡·¯Á» Àâ¾Æ ÁÖ¼¼¿ä....
|
|
¸Þ¸ð |
|
³²°ÜÁø ¸Þ¸ð°¡ ¾ø½À´Ï´Ù.
|
|
   |
  |
|
¨Ô |
Á¦¸ñ |
ÀÛ¼ºÀÎ |
Á¶È¸ |
µî·ÏÀÏ |
|
|
mssql¿¡¼ µÎ Å×À̺íÀ» µ¿½Ã¿¡ update ÇÒ·Á¸é ¾î¶»°Ô... |
ys4874 |
3179 |
2001-09-17 |
|
  |
|
|