Without going to in depth into what you are trying to do(I get lost after
about 5 sentences - mind goes elsewhere ;)) - you may try to use dot
notation for your queries, and see if that helps. So in other words, try:
<cfoutput>
#query1.var_name#
#query2.other_var_name#
</cfoutput>
Dot notation is a very useful thing to learn, even if it doesn't help you in
this case, it is extremely handy.
-Bill
/intraget
----- Original Message -----
From: Michael Wilson <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Saturday, October 21, 2000 11:37 PM
Subject: Update Query/Output question from a newbie...
> Hi all and thanks for taking time to look this over. I will try my best to
> keep it as brief as possible, although I need to give you some background
on
> my problem. Thanks in advance for any help you can provide.
>
> I have a client I did a site for about 4 years ago and it have never
really
> been changed much. The site owner asked me to update the look and
> functionality of the site to make it easier to use. He also requested that
I
> create a system that would allow him to update the Distributors section on
> his own, so I went with ColdFusion, because I want to learn more about it.
>
> I am working on the code for the Distributors first. The original page is
> http://www.mfay.com/Locations.htm. Don't laugh, it's really Old School...
>
> I stared with my Database in MS Access, dbcms.mdb. I have 2 tables,
> tbldistrib and tblstates.
>
> tbldistrib has the following columns: distrib_id (auto number),
> distrib_name, distrib_city, distrib_state and distrib_phone
>
> tblstates has the following columns: state_id (auto number), state_name
and
> state_abb (incase he wants to use abbreviation later)
>
> Next I started on the Add New Distributor area of his CMS. I created the
> insert form using Text type inputs for name, city and phone. I used a
select
> box for the sate and got the select options from tblstates/state_names in
> the Database.
>
> the code I used for the select box:
>
> Query:
>
> <CFQUERY NAME="GetState" DATASOURCE="dbcms">
> SELECT state_name
> FROM tblstates
> </CFQUERY>
>
> Output:
>
> <SELECT NAME="distrib_state">
> <CFOUTPUT QUERY="GetState">
> <OPTION>
> #GetState.state_name#
> </OPTION>
> </CFOUTPUT>
> </SELECT>
>
>
> All went according to plan and it works fine. I then created the display
> page and messed around with the ordering and formatting until I have it
real
> close to the original style of listing the distributors. You can find it
at:
> http://xiondev2.dynip.com/cms/list_distrib.cfm
>
> Then I started on the Update Distributor section... I can make this work
by
> using the following
>
> Query:
>
> <CFQUERY DATASOURCE="dbcms" NAME="Distributor">
> SELECT distrib_name,
> distrib_city,
> distrib_state,
> distrib_phone
> FROM tbldistrib
> WHERE distrib_id = #distrib_id#
> </CFQUERY>
>
> Output:
>
> <CFOUTPUT QUERY="Distributor">
>
> <FORM ACTION="distrib_update.cfm" METHOD="post">
> <INPUT TYPE="hidden" NAME=distrib_id" Value="#distrib_id#">
>
> <p>
> Distributor Name:
> <INPUT TYPE="text" NAME=distrib_name" SIZE="35" MAXLENGTH="50"
> Value="#Trim(distrib_name)#">
>
>
> ..and so forth for each form field. What I would like to do is have the
> "State Name" portion of the form return as a select box as in the insert
> form, displaying the current distrib_state as the default option while
also
> populating the rest of the select box (options) with the data (state
names)
> from the tblsates/state_names in the database. This way my client can
change
> the Distributor State if he needs to in the same manner as when he adds a
> new distributor.
>
> I tried running 2 Queries and 2 outputs calling a distrib_id in the url
> (...cfm?distrib_id=30)
>
> Query:
>
> <CFQUERY DATASOURCE="dbcms" NAME="GetState" >
> SELECT state_name
> FROM tblstates
> </CFQUERY>
>
> Output:
>
> <SELECT NAME="distrib_state">
> <CFOUTPUT QUERY="GetState">
> <OPTION>
> #GetState.state_name#
> </OPTION>
> <OPTION>
> #Trim(distrib_state)#
> <OPTION>
> </CFOUTPUT>
> </SELECT>
>
> and received errors:
>
> Invalid tag nesting configuration
>
> A query driven CFOUTPUT tag is nested inside a CFOUTPUT tag that also has
a
> QUERY= attribute. This is not allowed. Nesting these tags implies that you
> want to use grouped processing. However, only the top-level tag can
specify
> the query that drives the processing.
>
> I moved things around several times and got several different results and
> errors, lol but nothing like what I was thinking about.
>
> Any ideas on how I can accomplish what I am looking for? Should I go back
to
> the insert form and have him manually enter the state information and
forget
> about the select box and the tblstates idea? The actual goal was to learn
> _how_ to do this rather than it being a "must have" in the system, but I
am
> out of ideas.
>
> Any help is much appreciated and I am sorry for being long on words, but I
> wanted to make sure my question was clear enough to elicit clear answers
> that I can understand.
>
> I have placed all the CF code in .txt files at:
>
> http://xiondev2.dynip.com/cms/cftext/insertform.txt
> http://xiondev2.dynip.com/cms/cftext/insertdata.txt
> http://xiondev2.dynip.com/cms/cftext/updateform.txt
> http://xiondev2.dynip.com/cms/cftext/list_distrib.txt
>
>
> Thanks,
>
> Mike
>
>
>
>
>
>
>
> --------------------------------------------------------------------------
----------------------
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
