Combining Variables

Question

I have a form that is being generated via a query loop. One
of the fields is 'ispercentage'&i (which the i is the index for
the loop). So the number afterwards could be between 0 and 9. So
obviously the variable name is going to change. How do I place that
into my sql insert query? I can't do #form.ispercentage# because
that comes back undefined (as is would be 'ispercentage(1-9 or even
more as more are added)'. The sql insert query is also looping to
add each new item.

Newsgroup_User · Accepted Answer

The generally preferred method is array notation:#form['scheduleuser" & i]#

Newsgroup_User · Answer

> Actually, no! I knew there was something wrong there, but you pointed it out! That line actually shouldn't even be there! It works perfect now! Thanks so much for the help!

The best way of troubleshooting this sort of thing is to use your eyes. As
part of the error message, it will display the actual SQL statement that
was trying to be executed. This is usually the best thing to check for
syntax errors like this, rather than looking at the code that generates the
SQL, which relies on you executing the code in your head, as well as having
to sort out what is CF code and what is SQL and what is... missing.

--
Adam

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.