Posted by Jack Jackson on 07/30/05 01:10

Aaron,
Thanks for showing me this it is very cool indeed.

However maybe I am being dumb and obdurate but what I am really trying
to do is build some of these things myself (with, thankfully, help) so
that I understand enough that when I see a great tool like yours I'll
actually appreciate what it's doing for me. I can see that your tool is
doing everything in one line, and I think its really great. I just am
such a beginner that I think tools like that would encourage me to
*never* get above this level I'm at now.

I got the questions and answers thing working, starting with Kristen's
two-query code and moving from there. I would like to come back to see
how it can be done with one query and one function, but at this point my
eyes are so bleary I'm grateful for the fact that I can now focus on
getting the form to process!

Thanks again

JJ

Aaron Greenspan wrote:
> Jay,
>
> This is why I think frameworks are helpful Here's how I'd do it with
> Lampshade in one line of code with my own hypothetical field names:
>
> dropdownBox('answerid', "SELECT answerid, CONCAT(questions.description,'
> - ',answers.description) AS display FROM questions LEFT JOIN answers ON
> questions.questionid=answers.questionid ORDER BY questions.description,
> answers.description", $myrow['answerid'], 'Question and Answer', 'Choose
> an Answer');
>
> For more information on this function:
>
> http://www.thinkcomputer.com/software/lampshade/documentation.html?function=dropdownBox
>
>
> I'd be happy to help you get it set up if you have any questions.
>
> Aaron
>
> Aaron Greenspan
> President & CEO
> Think Computer Corporation
>
> http://www.thinkcomputer.com
>

[Back to original message]