Bizarre CFIF issue with dynamic form variables? Very strange...

Question

I can't figure out what I'm doing wrong here. Here's my code. Issue explained below. SELECT * FROM dbo.BaseModel WHERE dbo.BaseModel.AccountID = #molmsAccountID# AND.dbo.BaseModel.basemodelActive = 1

#form['baseconfig#reviewconfigloader.basemodelID#']# #reviewconfigloader.basemodelName# #reviewconfigloader.basemodelSubName#

x 14

$486/yr

$1444/yr

$1444/3 yr

What I'm doing here is fairly basic.I'm running a query with a number of configs in it...and then creating a loop to output them. Ultimately, I only want the configurations that didnt have 0 submitted in the form on the previous page. Each one of the configs in the config query has a dynamic form variable on the previous page with a quantity tied to it. I am trying to eliminate all quantities past that aren't 0 (or not eliminate, just not show)...as you can see from the cfif statement.Here's where it gets weird. You'll notice I output #form['baseconfig#reviewconfigloader.basemodelID#']#, just for testing, which shows me the quantity as it should. I ran a test and put in a couple of 1s, 0s, 12s, 6s, etc in the form fields on the previous page. If this thing worked, it wouldnt show anything for any of the records with their basemodelID value being submitted as 0. Not the case. It shows all records. What is more hilarious is that it outputs perfectly in my test #form['baseconfig#reviewconfigloader.basemodelID#']#, showing the correct numbers entered in the previous form, the 1s, the 0s, etc, tied to each record. But for whatever reason, the cfif code isn't catching it. What's even more bizarre...I replaced the cfif ("form.baseconfig#reviewconfigloader.basemodelID#") NEQ 0 with GT 12 (12 was the highest number that I put in the form) and it still showed all records. Then I put it in as LT 12 and it showed nothing. I decided to take it one step further and put it in for GT 1231243242343 (random massive number), which it still showed all of the records. So somehow, my CFIF statement thinks that ("form.baseconfig#reviewconfigloader.basemodelID#") is a incredibly large number, although when I output it in the row below, it is the number it should be.I'm stumped. Any ideas? Thanks in advance!!

BKBK · Accepted Answer

hey BKBK, thanks for the try...but this just errors with the # errorbecause the # are taken out of the parenthasis. So it just bombs. letme know if you think of anything else though!Sorry about that, Jeculture. The Xmas factor.I rolled it out without checking. What it should have said is:or

Dan_Bracuk · Answer

To get the correct answer, I suggest a simpler approach. Start by looping through your form fields and identifying the values you want to display. Then incorporate those values into the where clause of your query and output all the query results.

I troubleshoot if/else logic problems like this:

if the variable has the expected value

output yes

else

output no and the value and the expected value.

To make your code more efficient, put your cfoutput tag outside the loop so it only has to execute twice. Also, if the query we see here is the same one you used to generate the form fields, you don't have to run it twice. Make it a session variable on your form page and do a query of query to narrow down your results based on the form submission.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded