You need to use TRIM because MS Access inserts a space infront the value
for the sign.
So,
SELECT tblcasinos.casinoname, tblcasinos.blackjack AS CasinoBlackjack,
FROM tblblackjack, tblcasinos
WHERE tblcasinos.blackjack = Trim(str(tblblackjack.blackjackid))
Works as if you did a Innerjoin on blackjack and blackjackid :-)
*big grin*
Now, in order to solve my problem though, I did something different.
I did a select on the tblcasinos table.
Then I do a
<SELECT NAME="blackjack" SIZE="5" MULTIPLE ID="blackjack">
<CFOUTPUT QUERY="blackjack">
<CFIF #ValueList(getcasinos.blackjack)# CONTAINS
#blackjack.blackjackid# >
<OPTION
VALUE="#blackjack.blackjackid#">#blackjack.blackjackdesc#</OPTION>
</CFIF>
</CFOUTPUT>
</SELECT>
on each select box. Is this going to take a while? Most definitely.
It's a very dirty solution to the problem.
But its the quickest solution other than completely redesigning this
application.
If anyone can think of another solution that does not require
redesigning the table structures I'm all ears...and eyes :)
-Gel
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
