<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2523" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>I have a table with forty fields. I use a single Z
SQL Method, from different places in my code, passing different
parameters.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2><params>AccountId
ControlClientId:optional </FONT><FONT face=Arial
size=2> Mobile:optional </FONT><FONT face=Arial
size=2></params><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>update MyAccount </FONT></DIV>
<DIV><FONT face=Arial size=2>set<BR> <dtml-if
ControlClientId><BR> ControlClientId =
<dtml-sqlvar ControlClientId type=int>,<BR>
</dtml-if><BR> <dtml-if
Mobile><BR> Mobile = <dtml-sqlvar
Mobile type=string>,<BR>
</dtml-if><BR> accountid = <dtml-sqlvar accountid
type=int></FONT></DIV>
<DIV><FONT face=Arial size=2>where </FONT></DIV>
<DIV><FONT face=Arial size=2> accountid = <dtml-sqlvar
accountid type=int></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>When I pass in an empty 'Mobile', the above code
does not distinguish this from an empty string, and the database column is not
updated.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Can I detect whether an string was passed in, even
if it is empty?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks in Advance</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Kevin</FONT></DIV></BODY></HTML>