Get value from SQL string ?

[VegaLA]

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...

[Monie]

You are right about "DLookup is not used in VBScript/ASP"!
But there is a VBScript Function that you could use, It imitates the functionality of the MS Access function of the same name which is like the one that you are using ^

Code: Select all

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

I am not sure that you use the correct syntax for your code above ^ but from what I understand when I see your code is that you are trying to retrieve the PicInsert field from the tblCon table where the Name is from your contributor input field. This is the same as the following SQL statement in more organize and fast way:

HTML: Select all

<%
   Dim strvalue, name
   name = Request.Form("contributor")
   strvalue  = ("SELECT PicInsrt FROM tblConn WHERE Name= '"& name &"'")
%>

Note: when retrieving a string value, you must put ' around them. " is for numbers. Assign any value that you would like to search into a variable for fast script execution (Like what I have done with your Request.Form)

[robbied72]

The only Comment I will make to Monie's code is not to use reserved names like "name" but rather use something like "vName", I always use v's in front of variables to clearly denote them.

Have a look at this page for a list of reserved names - http://www.webthang.co.uk/tuts/tuts_...rds/rwords.asp

Hope this helps.

[Monie]

Thanks for the tips robbied!
So the code should look like this:

HTML: Select all

<%
  Dim strvalue, vName
  vName = Request.Form("contributor")
  strvalue  = "SELECT PicInsrt FROM tblConn WHERE Name= '"& vName &"'"
%>

and you should consider changing your database field name as well, "Name"!

[robbied72]

Kind of, I would also rename the database field "Name" to UserName or something as it is also a reserved name.

[Monie]

Yeah... that sort that out!
Instead of using VBScript function, you should consider just stick with simple SQL statement to do just what you wanted for faster script execution.