help needed with SQL & like% syntax... 1

[TonyU]

[tt]
Hey guys, I'm trying to display a link only if the cookie matches the database field but I'm having problems with syntax because the field in the database is like:

Robert Jones
Steve Casey
Ronald Rhine
etc...

Here's how I thought it was done but nope:

if request.cookies("firstname&quot = views("researvedby&quot & request.cookies("last&quot = views("resevedby&quot then
response.write = response.write &quot;<a href=&quot;&quot;editrecords.asp?id=&quot; & views(&quot;id&quot & &quot;&quot;&quot;>Edit Record</a>&quot;&quot;&quot;


of course views(&quot;reservedby&quot being my recordset and field name.

[tt]
^{&quot;The only ideas that will work for you are the ones you put to work.&quot;}
[/tt]

​

 

[TonyU]

That's suppossed to only be one response.write not two.(my typo)

response.write = response.write &quot;<a href=&quot;&quot;editrecords.asp?id=&quot; & views(&quot;id&quot & &quot;&quot;&quot;>Edit Record</a>&quot;&quot;&quot;

[tt]
^{&quot;The only ideas that will work for you are the ones you put to work.&quot;}
[/tt]

​

 

[GaryC123]

if request.cookies(&quot;firstname&quot = views(&quot;reservedby&quot and uest.cookies(&quot;last&quot = views(&quot;reservedby&quot then
Saturday 12.00

20.00

3.00am

Sunday [img http

 

[TonyU]

No go GaryC123, I just logged in as someone else but I could still see the Edit Record Link

Shouldn't the syntax have a LIKE in it somewhere?

[tt]
^{&quot;The only ideas that will work for you are the ones you put to work.&quot;}
[/tt]

​

 

[TonyU]

NEVER MIND! GaryC123

My dumb A$$ had misspelled reservedby, Sorry dude and thanks again

[tt]
^{&quot;The only ideas that will work for you are the ones you put to work.&quot;}
[/tt]

​