Skip to main content
T
Tfort
Participating Frequently
April 2, 2009
Question

Access query problems

  • April 2, 2009
  • 3 replies
  • 924 views
This query takes data from two tables so they can be compared . They are linked together using the PWS_ID. When I run it I get the error....

Element DATECCRDELIVERED is undefined in TBL07COMPLYDETAIL. Query is below.
This topic has been closed for replies.

3 replies

N
Newsgroup_User
Inspiring
April 2, 2009
Dan Bracuk wrote:
> Your error message means that table tbl07ComplyDetail does not have a field named dateccrdelivered.

Actually does it not mean that CF thinks there is a structure variable
named 'tbl07ComplyDetail' and that it does not have an element named
'datecrdelivered'. If it was a field not being in a table would that
not be a SQL|Database error not a CF error?

Why it thinks this - I could not see a reason for in the code you provided.
T
TfortAuthor
Participating Frequently
April 2, 2009
Right, I looked into that. I did a cfdump and copied the field names directly from that.
D
Dan_Bracuk
Inspiring
April 2, 2009
Your error message means that table tbl07ComplyDetail does not have a field named dateccrdelivered.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices