Jumping into the pool, I hope this is relevant
Type mismatches mean that the structure of the DB is different for the two
tables. One may be text and the other a number, or with different
properties that don't allow one of the fields to be matched upward in the
hierarchy of precision. Go back to the table definitions and check each
field against the other field
Richard
-----Original Message-----
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 14, 2000 10:16 AM
To: [EMAIL PROTECTED]
Subject: Re: Populating more than one Select
Found solution to previous problem
WHERE c.cat_id = s.cat_id
It should be c.ID as there is no such field as cat_id in categories.
However; this too produces an error:
[Microsoft][ODBC Microsoft Access Driver] Type mismatch in expression.
What on earth does that mean?
Will
----- Original Message -----
From: "Bud" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 14, 2000 4:12 PM
Subject: Re: Populating more than one Select
> On 9/14/00, W Luke penned:
> ><cfquery name="findcats" datasource="localads">
> > SELECT ID, cat_id, cat_name, sub_name FROM categories, sub_categories
> > ORDER by cat_name
> > </cfquery>
>
> Try:
> <cfquery name="findcats" datasource="localads">
> SELECT ID, cat_id, cat_name, sub_name
> FROM categories c, sub_categories s
> WHERE c.cat_id = s.cat_id
> ORDER by cat_name
> </cfquery>
>
> >
> > <CF_TwoSelectsRelated
> > QUERY="findcats"
> > NAME1="Cat"
> > NAME2="Selected"
> > DISPLAY1="cat_name"
> > DISPLAY2="sub_name"
> > VALUE1="cat_id"
> > VALUE2="sub_name"
>
> Just curious. Wouldn't you want value2 to be sub_id. It should work
> if you change the query though. And I presume you remembered to put
> name="MyOtherForm" in the form header.
> --
>
> Bud Schneehagen - Tropical Web Creations
>
> _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> ColdFusion Solutions / eCommerce Development
> [EMAIL PROTECTED]
> http://www.twcreations.com/
> 954.721.3452
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
