View Single Post
  #4 (permalink)  
Old 04-13-2008, 02:51 AM
MikeL7
 
Posts: n/a
Diggs:
Default Re: defining recordset according to first three digitsof code

What error message are you getting, probably in this line

$query_rs_allcourses = sprintf("SELECT * FROM courses WHERE coursecode LIKE
'$strippedcode'", GetSQLValueString($colname_rs_allcourses, "text"));

Try this:
$query_rs_allcourses = sprintf("SELECT * FROM courses WHERE coursecode LIKE
'%$strippedcode%'");



Reply With Quote