ASP sql

Results 1 to 3 of 3

Thread: ASP sql

  1. #1
    Join Date
    Dec 1969

    Default ASP sql

    i got an error(missing operator)in sql statement to update data into database by using following statement.if anybody help me,i&#039;ll thank to you so much.<BR><BR>&#060;%<BR>dim Nric,alias,sql<BR>Nric=request.form("nric") <BR>alias=Request.Form("alias")<BR><BR>objRS.Ope n "staffbio", objConn, 3, 3<BR> <BR>sql="Update staffbio set Alias =" & alias & "where NRIC=&#039;" & Nric & "&#039;"<BR>Set objRS=objConn.Execute(sql1)<BR>%&#062;<BR><BR>

  2. #2
    Medieval Dude Guest

    Default RE: ASP sql

    Set objRS=objConn.Execute(sql1)<BR><BR>...and sql1 would be? I only see you using a variable named sql.

  3. #3
    Join Date
    Dec 1969

    Default RE: ASP sql

    Try giving a space before where clause.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts