1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

What is the meaning of this?

Discussion in 'C#' started by chrisj, Feb 14, 2008.

  1. #1
    Could you please help me remedy this error? Thank you....

    Microsoft OLE DB Provider for SQL Servererror '80040e14'
    Line 1: Incorrect syntax near '='.
    /home/reactivate.asp, line 17


    I believe line 17 is: MyConn.Execute uSQL

    <!--#include file="app_config.asp"-->
    <!--#include file="inc_header.asp"-->
    <%
    MType			= Trim( request( "MType" ) )
    IF MType = 0 THEN 
    	sMESSAGE = sMESSAGE & "<li />You did not select a valid MEMBERSHIP TYPE"
    	%><!--#include file="inc_error.asp"--><%
    ELSE
    
    	Call OPEN_DB()
    	
    	'// UPDATE USER ACCOUNT STATUS ( to Unpaid Account )
    
    	uSQL	= "UPDATE mms_tbl_user " &_
    			  "SET fldSTATUS = '" & Cstr(drpSTATUS(5)) & "' " &_
    			  "WHERE ID = " & session( "sUSER_ID" ) 
    	[B]MyConn.Execute uSQL[/B]
    
    	dSQL	= "DELETE from mms_tbl_user_membershipType " &_
    			  "WHERE fldUSER_ID = " & session( "sUSER_ID" ) 
    	MyConn.Execute dSQL
    	
    	cSQL	= "DELETE from mms_tbl_user_cate " &_
    			  "WHERE fldUSER_ID = " & session( "sUSER_ID" ) 
    	MyConn.Execute cSQL
    	
    	set cRS = MyConn.Execute( "SELECT * FROM mms_tbl_membershipType_cate WHERE fldMembershipType_ID = " & MTYPE )
    	while not cRS.EOF
    		MyConn.Execute( "INSERT INTO mms_tbl_user_cate (fldCATE_ID, fldUSER_ID)" &_
    						"VALUES (" & cRS( "fldCATE_ID" ) & ", " & session( "sUSER_ID" ) & ")" )
    	cRS.MoveNext
        wend
    
    	'// DEFINE MEMBERSHIP LEVEL ASSIGNMENT
    
    	mSQL = "INSERT INTO mms_tbl_user_membershipType (fldMType_ID, fldUSER_ID)" &_
    		   "VALUES (" & MType & ", " & session( "sUSER_ID" ) & ")" 
    	MyConn.Execute mSQL
    
    	MyConn.Close
    	Set MyConn = Nothing
    
    	Session.Timeout = 25
    	Response.Redirect "_register_2.asp?p=" & PAYMENT & "&MType=" & MType
    	Response.End
    
    END IF
    %>
    Code (markup):

    SEMrush
     
    chrisj, Feb 14, 2008 IP
    SEMrush
  2. vpguy

    vpguy Guest

    Messages:
    275
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #2
    1. Is session("sUSER_ID") a string? If so, you need to enclose it in single quotes:
    "WHERE ID = '" & session( "sUSER_ID" ) & "'"
    Code (markup):
    2. Does drpSTATUS(5) contain a single quote? If so, you need to escape it by doubling it:
    Replace(Cstr(drpSTATUS(5)), "'", "''")
    Code (markup):
    I'm not sure if either of those is what's causing it though.
     
    vpguy, Feb 15, 2008 IP
  3. Free Born John

    Free Born John Guest

    Messages:
    111
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #3
    it's an sql syntax error - if you break at line 17 and look at the vale of dsql it should be obvious. If not, post it here.
     
    Free Born John, Feb 16, 2008 IP
  4. chrisj

    chrisj Well-Known Member

    Messages:
    606
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    101
    #4
    thanks,,,,,,,
     
    chrisj, Feb 24, 2008 IP