Hi all,
I am trying to get the value from a SQL string and store it in a variable but i'm guessing DLookup is not used in VBScript/ASP as it is with Access/VBA which is my background so the synax below is of course not working !

HTML: Select all

strvalue = dlookup("PicInsert") FROM tblCon WHERE "Name" = Request.Form("contributor")

How would I go about doing this ?
Thanks in advance,
Mitch...