|
|
Hello~
I am adding records to a table from another with an Append query in Access.
The column names and types are exactly the same. However, when I look at the
query results on a web page (how I am outputting my data), the page displays
perfectly for the older records that were already present in the table, but do
not work for the new records from the Append table. It seems to be hanging on a
particular number field, practiceTypeID, which is very similar to other fields
in the table that come before it, and seem to be pulling just fine! I have
attached the error and the query, but my big question is, why do some records
work and others do not? Please help! Thanks!
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Syntax error (missing operator) in query expression
'practiceType.id ='.
The error occurred in
118 : practiceType
119 : WHERE
120 : practiceType.id = #getMentorInfo.practiceTypeID#
121 : </cfquery>
122 :
---------------------------------------------------
<cfquery name="getMentorInfo" datasource="mentors">
SELECT
mentors.*, internOps_new.*, practiceType.id,
practiceType.typeName,
practiceArea.id, practiceArea.areaName
FROM
mentors,
internOps_new,
practiceType,
practiceArea
WHERE
mentors.id = #id# and internOps_new.mentorID =
#id# and practiceType.id =
mentors.practiceTypeID
</cfquery>
<cfquery name="getPracticeID" datasource="mentors">
SELECT
*
FROM
practiceType
WHERE
practiceType.id = #getMentorInfo.practiceTypeID#
</cfquery>
|
|