CFIF and dynamic variables

[hml398]

I have SuperBowl brain or something this afternoon. I am trying to use a cfif statement with a dynamic variable and I am not writing correctly.

<CFIF getrecord.event#eventid# is "n"> where eventid is a dynamic variable from a loop and getrecord is the query that I am pulling from.

Help!

Thanks,

[JR__Bob__Dobbs-qSBHQ2]

Try this.

<cfif getrecord.event[#eventid#] is "n">

If that doesn't work please specify the data type and content of n

Edited.

[JR__Bob__Dobbs-qSBHQ2]

This may be better. I'm assuming event is a column name from a recordset and eventid if the row number of the row you want to examine.

<cfif getrecord["event"][#eventid#] eq "n">

Edit: attached code.

[hml398]

I get an error

Element EVENT is undefined in GETRECORD.

[hml398]

Actually the field is called event1, event2, event3, etc.

getrecord.event1, getrecord.event2

[JR__Bob__Dobbs-qSBHQ2]

See sample.

Edit: fixed code sample

[Dan_Bracuk]

quote:

---

Originally posted by: hml398
Actually the field is called event1, event2, event3, etc.

getrecord.event1, getrecord.event2

---

Normalize your database and you won't have problems like this.

[hml398]

I get the data from the getrecord query.

I am outputting a bunch of table cells from a query that picks all of the events. The eventid value comes from the matrix query that is being outputted for the table cells.