What is the name of your query? Is it "market"?

e.g. <cfquery name="market" datasource="#dsn#">
        select marketStuff ...

-mike



<[EMAIL PROTECTED]>
07/14/2004 12:44 PM
Please respond to cf-talk

        To:     CF-Talk <[EMAIL PROTECTED]>
        cc:
        Subject:        attribute value...

I've got a piece of code...


195 :  <cfloop query="market" >
196 :        <option value="#market.c_marketid#" <cfif tmp1 IS
market.market >selected</cfif>>#market.market#</option>
197 :       </cfloop>

this is generating the CF error..


The value of the attribute query, which is currently "market", is invalid.

the query
SELECT market, c_marketid, isactive, actionuser, actiondate FROM C_MARKET

ORDER BY market

returns

ALBANY             2         1     0070236         7/13/2004 1:41:15 PM
LITTLEROCK     1        1     0070236         7/13/2004         1:41:00 PM

I'm not entirely understanding this error, can someone explain?
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to