Thank you. Yes, I am using Data Assist. I had finally figured out last night what I needed to do, and was close. Your example showed me where I had gone wrong. For some reason I was using "Server Variable" instead of "Entered Value". Not now my public page has...
SELECT * FROM tblTablehere WHERE visible = 1 ORDER BY id DESC
("visible" being my column name). Now it works. Thanks.
Now I would like to display the value in the Admin Detail page, something other than a "1" or a "0". I know there is a way to format that this, but for the life of me I can't find it in any of my books. I know this is a simple code for most, but I'm still learning the hand coding part.
I assume that I create a condition that says 1 is = to "word1" and 0 is = to "word2" but I don't know which process to use here. I thought I had figured it out in the chapter on typecasting but then decided that was not correct. Can someone point me in the right direction? Should I use an if statement?
Thanks,
Troy
