Topic: Adding columns makes code fail, why?


MIGhunter    -- 04-15-2007 @ 2:40 AM
  Ok, I wrote some code for a master detail page.  Then I added some columns to the access file.  I added them to the select statement and I added them to the table.  However, when I execute the page, I get VARIABLE email is not defined.  

If I comment them out, it works fine but not when in normal mode.  Any suggestions on what it could be?


Scarecrow    -- 01-07-2009 @ 6:25 PM
  probably because email is a reserved word.

Either change the name or enclose in []

Ken

www.scarecrowapplications.com


weathermanfsu    -- 06-09-2009 @ 12:22 PM
  it says variable email is not defined, this indicates a problem with the output to the screen, not with the database query.

When you spit out variable to the screen inside the cfoutput, make sure you qualify it, meaning preface it with a scope.  In your case, your query (since that is where you are getting the information...)

<cfquery name="myquery"...>
selected email from blah blah....
</cfquery>

<cfoutput>
#myquery.email#
</cfoutput>

If you are every displaying information that the user submitted from a form, then it would be form.email....

I hope that makes sense.  Basically it did not know where to go and get the data for the email field to show the user.


Webmaster    -- 06-09-2009 @ 2:05 PM
  can we see your code?

Pablo Varando
Senior Application Architect
EasyCFM.COM, LLC.

904.483.1457 \\ mobile
webmaster@easycfm.com \\email

\m/ (>.<) \m/
--- rock on ---


EasyCFM.COM ColdFusion Forums : http://archive.easycfm.com/forums
Topic: http://archive.easycfm.com/forums/viewmessages.cfm?Forum=30&Topic=11409