Never mind, in the other code I use the query tag in the <CFMAIL so I needed the <cfoutput>
This time I do not..


Thanks

-----Original Message-----
From: Morphis, Greg
Sent: Monday, March 01, 2004 3:04 PM
To: CF-Talk
Subject: Undefined values?

I have an update/insert query (depending on if the record already exists).
Afterwards I want my page to email a group with information pertaining to the record.
I have the cfmail code correct(I use it elsewhere on my site) however here I get a weird error
"The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code.
Null Pointers are another name for undefined values. "

It highlights the last ## statement.
Also in the debugger it shows
15:55:20.020 - java.lang.NullPointerException - in D:\Inetpub\wwwroot\sales\agentdb\AgentInsert.cfm : line 157

Any ideas? When I remove the whole #form.entitytype# and execute, it highlights the form.commcontactname
Thanks

Here's my cfmail tag...

<CFIF form.vendorid is "">
<CFMAIL TO="[EMAIL PROTECTED]" FROM="[EMAIL PROTECTED]" SUBJECT="Vendor ID Request AgentID: #form.agentID#" type="HTML">
<strong>The following Agent requires a Vendor ID set up for them. Thank you</strong><br><br>

<cfoutput>
<table class="data">
<tr>
<td align="right"><font size="-1">Date:</font></td>
<td><font size="-1">#dateformat(form.DATEENTERED,"mmm-dd-yyyy")#</font></td>
</tr>
<tr>
<td align="right"><font size="-1">Agent:</font></td>
<td><font size="-1">#form.agentname#</font></td>
</tr>
<tr>
<td align="right" valign="top"><font size="-1">Address:</font></td>
<td><font size="-1">#form.commstreet#</font></td>
</tr>
<tr>
<td></td>
<td><font size="-1">#form.commcity#, #form.commst#, #form.commzip#</font></td>
</tr>
<tr>
<td align="right"><font size="-1">Contact:</font></td>
<td><font size="-1">#form.commcontactname#</font></td>
</tr>
<tr>
<td align="right"><font size="-1">Entity:</font></td>
<td>#form.entitytype#</td>
</tr>
</table>
</cfoutput>
</CFMAIL>
<CFELSE>
<table class="data">
<tr>
<td class="label">Agent Inserted into Database</td>
</tr>
</table>

</CFIF>

Greg Morphis
Rapid Response Team
Client Server Dev/Analyst I
Armageddon Programmer/Support
Desk: 501/905-2881
Cell: 501/529-3691

******************************************************************************************
The information contained in this message, including attachments, may contain
privileged or confidential information that is intended to be delivered only to the
person identified above. If you are not the intended recipient, or the person
responsible for delivering this message to the intended recipient, ALLTEL requests
that you immediately notify the sender and asks that you do not read the message or its
attachments, and that you delete them without copying or sending them to anyone else.
  _____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to