Another question about empty strings??? dates this time

[crashc123]

First thanks to all for all the help you guys have given. Truly a lifesaver!!!

Okay now for the final...(I hope question)...

how to allow empty strings in date fields? the table can have blank dates but when I leave a field blank on form i get this error

Microsoft JET Database Engine error '80040e07'
Syntax error in date in query expression '##'.
/myweb/Projectlist_copy(11-16-01)(2).asp, line 273

here's the code it refers to:

strSQL = "UPDATE Projects SET " _
& "JobNo='"&Request.Form("JobNo&quot&"',"_
& "Title='"&Request.Form("Title&quot&"',"_
& "Description='"&Request.Form("Description&quot&"',"_
& "Aircraft='"&Request.Form("Aircraft&quot&"',"_
& "JobType='"&Request.Form("JobType&quot&"',"_
& "Engineer='"&Request.Form("Engineer&quot&"',"_
& "Focal='"&Request.Form("Focal&quot&"',"_
& "DER='"&Request.Form("DER&quot&"',"_
& "DateIn=#"& Request.Form("DateIn&quot&"#,"_ 'here I think is the problem and lines below
& "DateDue=#"& Request.Form("DateDue&quot&"#,"_
& "8110Due=#"& Request.Form("8110Due&quot&"#,"_
& "DTRDue=#"& Request.Form("DTRDue&quot&"#"_
& "WHERE (ID="& iRecordId &&quot"


Set cnnDBEdit = Server.CreateObject("ADODB.Connection&quot
cnnDBEdit.Open CONN_STRING

cnnDBEdit.Execute strSQL, adAffectAll, adCmdText or adExecuteNoRecords


/////////////////////////////////////
here is the lines from the request form:

<tr>
<td>Date In</td>
<td><input type=&quot;text&quot; name=&quot;DateIn&quot; Value=&quot;<%=(rstDBEdit.Fields(&quot;DateIn&quot.Value) %>&quot; ><i>mm/dd/yy</i></td>
</tr>
<tr>
<td>Date Due</td>
<td><input type=&quot;text&quot; name=&quot;DateDue&quot; Value=&quot;<%= (rstDBEdit.Fields(&quot;DateDue&quot.Value) %>&quot; ><i>mm/dd/yy</i></td>
</tr>
<tr>
<td>8110 Due</td>
<td><input type=&quot;text&quot; name=&quot;8110Due&quot; Value=&quot;<%= (rstDBEdit.Fields(&quot;8110Due&quot.Value) %>&quot; ><i>mm/dd/yy</i></td>
<tr>
<tr>
<td>DTR Due</td>
<td><input type=&quot;text&quot; name=&quot;DTRDue&quot; Value=&quot;<%= (rstDBEdit.Fields(&quot;DTRDue&quot.Value) %>&quot; ><i>mm/dd/yy</i></td>
</tr>

 

[TechnicalAnalysis]

I think you've spot on the problem. You may have to do a condition like this on all your date fields

if Request.Form(&quot;DateIn&quot=&quot;&quot; then
& &quot;DateIn=''&quot;
else
& &quot;DateIn=#&quot; & Request.Form(&quot;DateIn&quot
End if

Regards

http://www.technical.analysis.dingojunction.com

 

[crashc123]

Now I am back to this one( was ignoring it hoping it would mysteriously disappear)

Where would I put this statement? before the update sql? in the request form ? in the sql update statement?

Again Thanks for all your help

Sonya