| Posted By |
Discussion Topic: cfquery question
|
|
sparty2809 |
08-16-2005 @ 1:16 PM |
|
|
Senior Member
Posts: 435
Joined: Feb 2003
|
How can I make this work? It is not displaying anything.
<cfquery datasource="#dsn#" name="qTable">
SELECT table1.*, table2.*, table3.*, table4.*, table5.*, table6.*
FROM table1, table2, table3, table4, table5, table6
WHERE table1.ID = '#SESSION.Auth.ID#' AND table2.ID = '#SESSION.Auth.ID#' AND table3.ID ='#SESSION.Auth.ID#' AND table4.ID ='#SESSION.Auth.ID#' AND table5.ID ='#SESSION.Auth.ID#' AND table6.ID ='#SESSION.Auth.ID#'
</cfquery>
Please help me get an iPod!
http://www.freeiPods.com/?r=12219447
Thanks,
sparty2809
|
|
CJ |
|
08-16-2005 @ 2:37 PM |
|
|
Administrator
Posts: 4262
Joined: Oct 2002
|
well the first question would be...are you sure there are any records in the database that match your criteria? eg. where there's a record in table1, table2, table3, etc.
-CJ-
@ #coldfusion/DALNet
http://charlie.griefer.com
|
|
sparty2809 |
|
08-16-2005 @ 3:37 PM |
|
|
Senior Member
Posts: 435
Joined: Feb 2003
|
Yes, all the IDs equal. I turned on Debugging and it showed they were equal. If I remove the last two, it works, even though the IDs match.
Please help me get an iPod!
http://www.freeiPods.com/?r=12219447
Thanks,
sparty2809
|
