To anyone who can help,
I am trying to output a list of records on a page, also nested in this list
are individually populated
drop down boxes which has values determined by the parent record. But before
I get to this stage I can't get the query
syntax right.
I can't quite get the query syntax right, below is what I have tried but I
only seem to get 1 variant and no more.
All the records are there but can't seem to output them. I have also tried
<cfx_dumpquery> tag but still can't get any more than
one row out of get_variants.
<cfquery name="get_prod" datasource="#dsnvar#" dbtype="#dsntype#">
SELECT * FROM prod
WHERE cat_id = '1' AND active = '1'
ORDER BY prod_priority
</cfquery>
<cfquery name="get_variants" datasource="#dsnvar#" dbtype="#dsntype#">
Select *
>From variants
WHERE prod_id = #get_prod.prod_id#
</cfquery>
Am probably being stuuupid due to sleep depravation.
If anyone can help I would appreciate it.
Cheers
Chris.
-------------------------------------------------------
Chris Poole
Development Engineer
-------------------------------------------------------
e-mango.com ltd Tel: 01202 587 400
Lansdowne Place Fax: 01202 587 401
17 Holdenhurst Road
Bournemouth Mailto:[EMAIL PROTECTED]
BH8 8EW, UK http://www.e-mango.com
-------------------------------------------------------
This message may contain information which is legally
privileged and/or confidential. If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of e-mango.com ltd,
unless otherwise explicitly and independently indicated
by an authorised representative of e-mango.com ltd.
-------------------------------------------------------
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
