At 12:38 PM 11/11/04, Ian Skinner wrote:
> I don't know how unique the url's are in your data, but if any of them
> are repeated you would probably want an "URL" table.
Actually, that is correct. Some URL's may be good for more than 1 word. I
was just thinking of updating them manually one by one, but if there's a
better way, I'm all ears :-)
>And your select query would become something like this:
>SELECT
> WORD, URL
>FROM
> WORD_TBL, URL_TBL,W ORD_URL_JOIN
>WHERE
> URL_TBL.ID = WORD_URL_JOIN.URL_ID
>AND WORD_URL_JOIN.WORD_ID = WORD_TBL.ID
>AND WORD_TBL.ID = <cfqueryparam value="#myWordVariable#"
>CFSQLTYPE="SQL_DB_CHAR">
I'm not familiar with joins, so these questions may sound silly, but here
they are:
- in the last line, shouldn't I have "WORD_TBL.WORD" instead of
"WORD_TBL.ID"? Because the user will type a word, that should match the
actual word stored under that record ID.
- I understand the use of #myWordVariable#, which would come from the text
entry field in the form used to search the dictionary. But, what would
"cfqueryparam" and "cfsqltype" do? In other words, are they required, or
just "good-to-have"?
- any reason why, in the "WHERE" statements, you used "URL_TBL.ID" first
(i.e., before the "=" sign), but then you used a similar expression
("WORD_TBL.ID") second (i.e., after the "=" sign) in the next part?
Thanks in advance,
Roberto Perez
[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184062
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
