Application error

Results 1 to 2 of 2

Thread: Application error

  1. #1
    Join Date
    Dec 1969

    Default Application error

    error is <BR><BR>ADODB.Command error &#039 800a0bb9&#039 <BR><BR>The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another. <BR><BR>? <BR><BR><BR><BR>sql1 = "SELECT user_id FROM User_Login WHERE login_name=&#039" & strUserID & "&#039"<BR> <BR>Set RecordSet = Server.CreateObject("ADODB.Recordset")<BR>Set objcomm = Server.CreateObject("ADODB.Command")<BR>objcomm.Ac tiveConnection = conn <BR>objcomm.CommandText = sql1<BR>objcomm.CommandType = adCmdText<BR>set RescordSet = objcomm.Execute

  2. #2
    LeeAnnie Guest

    Default One suggestion.....

    Is UserID a number or is it text? If it is a number, then use only double quotes, no single quotes.

Posting Permissions

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