Help - I don't know what to check

Results 1 to 4 of 4

Thread: Help - I don't know what to check

  1. #1
    Tosha Guest

    Default Help - I don't know what to check

    I&#039m getting this error:<BR>Microsoft VBScript runtime error &#039 800a0023&#039 <BR><BR>Sub or Function not defined <BR><BR>/reg-members.asp, line 134 <BR><BR>When trying to insert a record into a access database. I have no sub&#039s or functions in this file. Here is the code<BR>around line 134:<BR><BR> q1 = "INSERT INTO [members] ("<BR> q2 = "Email, FirstName, LastName, School, "<BR> q3 = "State, Major, Status) "<BR> q4 = " VALUES ("<BR> q5 = "&#039" & Email & "&#039, &#039" & FirstName & "&#039, &#039" & LastName & "&#039, "<BR>line34->q6 = "&#039" & School & "&#039, &#039" & state & "&#039, &#039" & Major & "&#039, &#039" & Status & "&#039) "<BR><BR> stmt = q1 & q2 & q3 & q4 & q5 & q6<BR> response.write stmt<BR> conn.Execute stmt, , adCmdText<BR><BR>can anyone give me some hints on what to check?

  2. #2
    Join Date
    Dec 1969
    Posts
    55

    Default RE: Help - I don't know what to check

    I&#039m not sure, but try changing the names of the variables. One or two of them might be reserved words.

  3. #3
    Nathan Pond Guest

    Default RE: Help - I don't know what to check

    For one thing, what is this:<BR><BR>line34->q6 = "&#039" & School & "&#039, &#039" & state & "&#039, &#039" & Major & "&#039, &#039" & Status & "&#039) "<BR><BR>what is the line34-> all about?<BR><BR>something else.. not sure about this but the 2 commas in a row when opening the data connection might be causing a problem.

  4. #4
    TOSHA Guest

    Default THANK to both of you...

    dah... i had word wrap on and was look at the wrong line... my real problem is i don&#039t know how to do an if then statement with a condition of an email address containing a .edu top-level domain. trying to use the like command but it isn&#039t working.


Posting Permissions

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