The DisplayChooser tag has an enumerated value of 'integer' for the spouseTablePrimaryKeyType, but that value doesn't
appear to be handled in the DisplayChooser tag.
Line 158 in DisplayChooser handles 'numeric' but there isn't a handler for 'integer'. If I change 'numeric' to
'integer' it works, so it looks like we need a handler for 'integer'.
Jeff
Jeff Fleitz wrote:
I am working with an Access 2003 database, which has a table called
Workshop. Workshop is a spouse of PlumUser via the PlumUserWorkshop
table which is storing just the autoincrementing keys from the parents
(UserID, WorkshopID).
I have a form called WorkshopRegistrationForm, which is essentially a
PlumUserEdit form or ProfileEditForm, with a DisplayChooser tag that
allows a user to select workshops.
<cf_DisplayChooser
spouseTable="Workshop"
childTable="PlumUserWorkshop"
spouseTablePrimaryKey="WorkshopID"
spouseTablePrimaryKeyType="integer"
foreignKeyFromChildTableToMainTable="UserID"
foreignKeyFromChildTableToSpouseTable="WorkshopID"
chooserLabel="Select Your Workshops"
maximumNumberOfOptions="100"
spouseTableDisplayColumn="WSTitle"
spouseTableDisplayColumnType="Text"
attachedItemsLabel="Registered"
unattachedItemsLabel="Not Registered">
The chooser works fine when originally adding workshops, but when coming
back in after some have been successfully added, I am getting a SQL
error for a 'datatype mismatch in criteria'. Looking at the query,
quotes are surrounding the integer values in the WHERE clause.
These are brand new unmodified tags, the project was created today. I
have not seen this one before, probably because I am using SQL Server
most of the time. I am curious as to why I don't seem to have any
problems with the PlumRoles chooser control in the PlumUserEditForm.
Any clues? Of course my 'one day project' just hit a major snag ;)
Processing Request
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC
Microsoft Access Driver] Data type mismatch in criteria expression.
The error occurred in D:\wwwroot\fmc_dev\components\DatabaseBlocks.cfc:
line 68
Called from D:\wwwroot\fmc_dev\customtags\DisplayChooser.cfm: line 191
Called from D:\wwwroot\fmc_dev\customtags\DisplayChooser.cfm: line 95
Called from D:\wwwroot\fmc_dev\customtags\DisplayChooser.cfm: line 22
Called from D:\wwwroot\fmc_dev\ws\WorkshopRegistrationForm.cfm: line 45
Called from D:\wwwroot\fmc_dev\components\DatabaseBlocks.cfc: line 68
Called from D:\wwwroot\fmc_dev\customtags\DisplayChooser.cfm: line 191
Called from D:\wwwroot\fmc_dev\customtags\DisplayChooser.cfm: line 95
Called from D:\wwwroot\fmc_dev\customtags\DisplayChooser.cfm: line 22
Called from D:\wwwroot\fmc_dev\ws\WorkshopRegistrationForm.cfm: line 45
66 : <cfif Len(Trim(Arguments.orderByClause)) GT 0>
67 : ORDER BY #PreserveSingleQuotes(Arguments.orderByClause)#
68 : </cfif>
69 : </cfquery>
70 :
--------------------------------------------------------------------------------
SQL SELECT Workshop.WorkshopID, Workshop.WSTitle FROM Workshop WHERE
WorkshopID NOT IN ('3','12') ORDER BY Workshop.WSTitle
DATASOURCE fmc
VENDORERRORCODE -3030
SQLSTATE 22018
**********************************************************************
You can subscribe to and unsubscribe from lists, and you can change
your subscriptions between normal and digest modes here:
http://www.productivityenhancement.com/support/DiscussionListsForm.cfm
**********************************************************************
