View Single Post
  #4 (permalink)  
Old Jan 29th, 2008, 23:53
Monie Monie is offline
Most Reputable Member
Join Date: Feb 2004
Location: Borneo
Age: 27
Posts: 1,608
Blog Entries: 2
Thanks: 0
Thanked 4 Times in 3 Posts
Re: Get value from SQL string ?

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"!

Last edited by Monie; Jan 30th, 2008 at 07:36.
Reply With Quote