¾ÆÀ̵ð ºñ¹Ð¹øÈ£ | ȸ¿ø°¡ÀÔ | ºñ¹Ð¹øÈ£ºÐ½Ç
   
¡¡»õ·Î¿î¼Ò½Ä
¡¡FAQ
¡¡À¥ÇÁ·Î±×·¥
¡¡À¥DB
¡¡À¥¼­¹ö
¡¡À¥ÇÁ·Î±×·¥¼öÁ¤
¡¡ÇØÇÇÄ®·³
¡¡°ñµåÆÁ
 
Á¦ÀÛÀÇ·Ú
À¥ÇÁ·Î±×·¥ ÆǸŸô
 
ÇöÀçÀ§Ä¡: ¸ÞÀÎ ÇØÇÇÆ÷·³ À¥ÇÁ·Î±×·¥ : °Ô½Ã¹° ÆîÃÄÀбâ
Total related article : 1  
µî·ÏÀÏ:2006-03-16
½Ã°£:07:09:58
Á¶È¸¼ö:2413
from:70.21.233.76
Syntax error (missing operator) in query expression... ±Û¾´ÀÌ : cmydesign

Microsoft JET Database Engine error '80040e14'

Syntax error (missing operator) in query expression 'cat_id='.

/products/index_catalog.asp, line 12

À§¿Í °°Àº  ¿¡¶ó°¡ ³³´Ï´Ù.

»ç¿ëÇÏ´Â ¼Ò½º°¡ ¾Æ·¡¿Í °°½À´Ï´Ù. ´Ù¸¥ °÷¿¡¼­ »ç¿ëÇß´ø ¼Ò½º¸¦ ¾à°£ ¼öÁ¤Çؼ­ »ç¿ëÇÏ·Á Çϴµ¥ ¸ðµç°ÍÀº ´Ù °°Àºµ¥ ´Ù¸¥°÷¿¡¼­ »ç¿ëÇß´ø ¼Ò½º´Â ·Î±×ÀÎÈÄ¿¡ »ç¿ëÇÏ°Ô µÇ¾îÀÖ±¸¿ä, ·Î±×ÀÎÀ» ÇϰԵǸé index_products.asp<--ÀÌ ÆäÀÌÁö·Î °¡°Ô ÀÛ¾÷µÇ¾îÁ®ÀÖ½À´Ï´Ù.
ÇÏÁö¸¸ Á¦°¡ Áö±Ý ÀÛ¾÷ÇÏ·Á´Â°Ç ÆäÀÌÁö¸¦ Ŭ¸¯ÇÏ¸é ±×³É ÆäÀÌÁö°¡ ³ª¿À±¸¿ä Redirect °°Àº°Ç ¾ø°Ô ÇÏ·ÁÇÕ´Ï´Ù.

<%
Dim sCatID, rsCategory, sSql
sCatID = Request("cid")
If Len(sCatID) = 0 Then Response.Redirect "index_products.asp"
sSql = "SELECT cat_subtitle_img FROM categories WHERE cat_id=" & sCatID
Set rsCategory = cnnDB.Execute(sSql)

' Set image path
Dim sSubTitleImage
If Not rsCategory.EOF Then sSubTitleImage = ImgURL & rsCategory("cat_subtitle_img")
 
' Clean up
rsCategory.Close
Set rsCategory = Nothing
%>

±×·¡¼­ If Len(sCatID) = 0 Then Response.Redirect "index_products.asp"<--À̺κÐÀ» ¾Èº¸ÀÌ°Ô
If Len(sCatID) = 0 Then 'Response.Redirect "index_products.asp" ÀÌ·¸°Ô Çß´õ´Ï ¿¡¶ó°¡ ³ª³×¿ä.

sCatID = Request("cid")
If Len(sCatID) = 0 Then Response.Redirect "index_producs.asp" <--ÀÌ ºÎºÐÀ» ¼öÁ¤ÇÏ¸é µÉ²¨°°Àºµ¥...Ãʺ¸¶ó Áö½ÄÀÌ Âª¾Æ¼­ À߸𸣰ڽÀ´Ï´Ù. °í¼ö´Ôµé ºÎµð ÇѼö ºÎŹµå¸³´Ï´Ù.

°¨»çÇÕ´Ï´Ù.


  

 
¨Ô
Á¦¸ñ
ÀÛ¼ºÀÎ
Á¶È¸
µî·ÏÀÏ
Syntax error (missing operator) in query expressio...
cmydesign
2413
2006-03-16 07:09:58
 

  HOME | ȸ»ç¼Ò°³ | Á¦ÀÛÀÇ·Ú | °³ÀÎÁ¤º¸Ãë±Þ¹æħ | CGIMALL | ÀÚ·á½Ç | »çÀÌÆ®µî·Ï | ·©Å·100 | Æ÷·³ | Ãʺ¸°¡À̵å | Áú¹®°ú´äº¯ | ¹è³Ê±¤°í
Copyright¨Ï1997~2008 HappyCGI All rights reserved
Powered By HappyCGI