troubleshooting Question

Need some help on using "Like" in an If...then statement in ASP...

Avatar of MitchellVII
MitchellVIIFlag for United States of America asked on
ASPHTMLWeb Browsers
6 Comments1 Solution694 ViewsLast Modified:
Hi,

I'm ndew to ASP so I probably have this totally wrong.  I am trying the check an <input> value to see if it DOES NOT SAY Like "Click here*" in ASP.  What I tried was:

Add Clients String:
    If Not Upload.Form("Clients") Like "Click here*" Then
        sql = "INSERT INTO contact (ProspectID, ContactClients) VALUES (" & Upload.Form("ProspectID") & ", ''Core', '" & Upload.Form("Clients") & "')"
        'Insert Record:
        oConn.Execute(sql)
    End if      

I am using "Upload.Form" instead of "Request.Form" here because this code is also running some Upload Code earlier, so that was necessary.

Anyway, when I try to run this I get th following error:

Microsoft VBScript runtime  error '800a0023'

Sub or Function not defined

/forms/scripts/asp/DocEPW_INSERT.asp, line 112

and line 112 is where this:

    If Not Upload.Form("Clients") Like "Click here*" Then

is located.  I'm sure its just my syntax that is messed up, thanks!
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 6 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros