I am just about ready to take over the world (as I do every night) and hit a brick wall ... Bellow is a CF template which is loaded to a main template using <cfinclude>.
I am using access DB - I keep on getting following error
----------------------------------------------------
Error Diagnostic Information
An error occurred while evaluating the expression:
"#getUser.Company#"
Error near line 22, column 75.
Error resolving parameter GETUSER.COMPANY
ColdFusion was unable to determine the value of the parameter. This problem is very likely due to the fact that either:
You have misspelled the parameter name, or
You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE tag.
The error occurred while processing an element with a general identifier of (CFINPUT), occupying document position (22:4) to (22:92).
Date/Time: 02/03/02 08:55:14
Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
Remote Address: 127.0.0.1
HTTP Referrer: Query String: ID=20
---------------------------------------------------------
I can assure you that the field Company is properly spelled. I even remed out line of code and I got same error with following <cfinput> ... I then removed the <cfoutput> tags (open/close) and still got the same error - and last, I changed the tag from <cfinput> to <input> and NADA!
Please help, I need to take over world sometime this tonight! If not, I will try tomorrow night and the next
Thank you all in advance;
josel
----------------------------------------------------------
CODE FOLLOWS:
<cfif isdefined("session.UserName"
>
<cfif isdefined("#URL.ID#"
>
<cfquery name="getUser" datasource="deco" dbtype="odbc">
select *
from accounts
where UserID=#URL.ID#
</cfquery>
<cfquery name="getID" datasource="deco" dbtype="odbc">
select *
from UserID
where UserID=#URL.ID#
</cfquery>
</cfif>
</cfif>
<cfif ("getUser.recordcount" IS NOT "0"
AND ("getID.recordcount" IS NOT "0"
>
<cfoutput>
<table width="100%" border="0" cellpadding="0" cellspacing="1">
<tr>
<td valign="top" height="24">
<cfinput type="text" name="company" length="30" maxlength="30" value="#getUser.Company#">
</td>
</tr>
<tr>
<td valign="top" height="24">
<cfinput type="text" name="firstname" length="30" maxlength="30" required="yes" message="First name is required" value="#getUser.FirstName#">
</td>
</tr>
<tr>
<td valign="top" height="24">
<cfinput type="text" name="lastname" length="30" maxlength="30" required="yes" message="Last name is required" value="#getUser.LastName#">
</td>
</tr>
<tr>
<td valign="top" height="24">
<cfinput type="text" name="address1" length="30" maxlength="50" required="yes" message="Your street name & address is required" value="#getUser.Address1#">
</td>
</tr>
<tr>
<td valign="top" height="24">
<cfinput type="text" name="address2" length="30" maxlength="50" value="#getUser.Address2#">
</td>
</tr>
<tr>
<td valign="top" height="24">
<cfinput type="text" name="city" length="30" maxlength="30" required="yes" message="City is required" value="#getUser.City#">
</td>
</tr>
<tr>
<td valign="top" height="24">
<cfinput type="text" name="state" length="2" maxlength="2" required="yes" message="State is required" value="#getUser.State#">
</td>
</tr>
<tr>
<td valign="top" height="24">
<cfinput type="text" name="zipcode" length="10" maxlength="10" required="yes" message="Zip code is required" value="#getUser.ZipCode#">
</td>
</tr>
<tr>
<td valign="top" height="24">
<cfinput type="text" name="email" length="30" maxlength="50" required="yes" message="Email address is required" value="#getUser.UserCode#">
</td>
</tr>
<tr>
<td valign="top" height="24">
<cfinput type="text" name="email2" length="30" maxlength="50" required="yes" message="Please re-enter your email address" value="#getUser.UserCode#">
</td>
</tr>
<tr>
<td valign="top" height="24">
<cfinput type="text" name="phone" length="20" maxlength="20" value="#getUser.HomePhone#">
</td>
</tr>
<tr>
<td valign="top" height="24">
<cfinput type="text" name="fax" length="20" maxlength="20" value="#getUser.FaxPhone#">
</td>
</tr>
<tr>
<td valign="top" height="24">
<cfinput type="text" name="workphone" length="20" maxlength="20" value="#getUser.WorkPhone#">
</td>
</tr>
<tr>
<td valign="top" height="24">
<cfinput type="text" name="cellphone" length="20" maxlength="20" value="#getUser.CellPhone#">
</td>
</tr>
<tr>
<td valign="top" height="25">
<cfinput type="password" name="password1" length="30" maxlength="30" required="yes" message="Password is required" value="#getID.UserPswd#">
</td>
</tr>
<tr>
<td valign="top" height="25">
<cfinput type="password" name="password2" length="30" maxlength="30" required="yes" message="Please re-enter your password" value="#getID.UserPswd#">
</td>
</tr>
<tr>
<td valign="top" height="24">
<input type="checkbox" name="mailist">
</td>
</tr>
<tr>
<td valign="top" height="24">
<input type="checkbox" name="share">
</td>
</tr>
</table>
</cfoutput>
<cfelse>
Sorry, we were unable to retrieve your profile information.<br>
If you feel this is an error, please contact us at your earliest convenience.<br>
<p>
If you have not registered, please do so <a href="register.cfm">NOW</a>!"<br>
<p>
If you have already registered, you need to <a href="login.cfm">SIGN IN</a> to access your profile information.
<p>&nbps;
Thank you!<br>
<p>
</cfif> If you have the knowledge, consult and educate those who need it! - Jose Lerebours
I am using access DB - I keep on getting following error
----------------------------------------------------
Error Diagnostic Information
An error occurred while evaluating the expression:
"#getUser.Company#"
Error near line 22, column 75.
Error resolving parameter GETUSER.COMPANY
ColdFusion was unable to determine the value of the parameter. This problem is very likely due to the fact that either:
You have misspelled the parameter name, or
You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE tag.
The error occurred while processing an element with a general identifier of (CFINPUT), occupying document position (22:4) to (22:92).
Date/Time: 02/03/02 08:55:14
Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
Remote Address: 127.0.0.1
HTTP Referrer: Query String: ID=20
---------------------------------------------------------
I can assure you that the field Company is properly spelled. I even remed out line of code and I got same error with following <cfinput> ... I then removed the <cfoutput> tags (open/close) and still got the same error - and last, I changed the tag from <cfinput> to <input> and NADA!
Please help, I need to take over world sometime this tonight! If not, I will try tomorrow night and the next

Thank you all in advance;
josel
----------------------------------------------------------
CODE FOLLOWS:
<cfif isdefined("session.UserName"

<cfif isdefined("#URL.ID#"

<cfquery name="getUser" datasource="deco" dbtype="odbc">
select *
from accounts
where UserID=#URL.ID#
</cfquery>
<cfquery name="getID" datasource="deco" dbtype="odbc">
select *
from UserID
where UserID=#URL.ID#
</cfquery>
</cfif>
</cfif>
<cfif ("getUser.recordcount" IS NOT "0"


<cfoutput>
<table width="100%" border="0" cellpadding="0" cellspacing="1">
<tr>
<td valign="top" height="24">
<cfinput type="text" name="company" length="30" maxlength="30" value="#getUser.Company#">
</td>
</tr>
<tr>
<td valign="top" height="24">
<cfinput type="text" name="firstname" length="30" maxlength="30" required="yes" message="First name is required" value="#getUser.FirstName#">
</td>
</tr>
<tr>
<td valign="top" height="24">
<cfinput type="text" name="lastname" length="30" maxlength="30" required="yes" message="Last name is required" value="#getUser.LastName#">
</td>
</tr>
<tr>
<td valign="top" height="24">
<cfinput type="text" name="address1" length="30" maxlength="50" required="yes" message="Your street name & address is required" value="#getUser.Address1#">
</td>
</tr>
<tr>
<td valign="top" height="24">
<cfinput type="text" name="address2" length="30" maxlength="50" value="#getUser.Address2#">
</td>
</tr>
<tr>
<td valign="top" height="24">
<cfinput type="text" name="city" length="30" maxlength="30" required="yes" message="City is required" value="#getUser.City#">
</td>
</tr>
<tr>
<td valign="top" height="24">
<cfinput type="text" name="state" length="2" maxlength="2" required="yes" message="State is required" value="#getUser.State#">
</td>
</tr>
<tr>
<td valign="top" height="24">
<cfinput type="text" name="zipcode" length="10" maxlength="10" required="yes" message="Zip code is required" value="#getUser.ZipCode#">
</td>
</tr>
<tr>
<td valign="top" height="24">
<cfinput type="text" name="email" length="30" maxlength="50" required="yes" message="Email address is required" value="#getUser.UserCode#">
</td>
</tr>
<tr>
<td valign="top" height="24">
<cfinput type="text" name="email2" length="30" maxlength="50" required="yes" message="Please re-enter your email address" value="#getUser.UserCode#">
</td>
</tr>
<tr>
<td valign="top" height="24">
<cfinput type="text" name="phone" length="20" maxlength="20" value="#getUser.HomePhone#">
</td>
</tr>
<tr>
<td valign="top" height="24">
<cfinput type="text" name="fax" length="20" maxlength="20" value="#getUser.FaxPhone#">
</td>
</tr>
<tr>
<td valign="top" height="24">
<cfinput type="text" name="workphone" length="20" maxlength="20" value="#getUser.WorkPhone#">
</td>
</tr>
<tr>
<td valign="top" height="24">
<cfinput type="text" name="cellphone" length="20" maxlength="20" value="#getUser.CellPhone#">
</td>
</tr>
<tr>
<td valign="top" height="25">
<cfinput type="password" name="password1" length="30" maxlength="30" required="yes" message="Password is required" value="#getID.UserPswd#">
</td>
</tr>
<tr>
<td valign="top" height="25">
<cfinput type="password" name="password2" length="30" maxlength="30" required="yes" message="Please re-enter your password" value="#getID.UserPswd#">
</td>
</tr>
<tr>
<td valign="top" height="24">
<input type="checkbox" name="mailist">
</td>
</tr>
<tr>
<td valign="top" height="24">
<input type="checkbox" name="share">
</td>
</tr>
</table>
</cfoutput>
<cfelse>
Sorry, we were unable to retrieve your profile information.<br>
If you feel this is an error, please contact us at your earliest convenience.<br>
<p>
If you have not registered, please do so <a href="register.cfm">NOW</a>!"<br>
<p>
If you have already registered, you need to <a href="login.cfm">SIGN IN</a> to access your profile information.
<p>&nbps;
Thank you!<br>
<p>
</cfif> If you have the knowledge, consult and educate those who need it! - Jose Lerebours