Total respect to all of you who do this every day every year.

This is probably simple and I will kick myself when told I expect but I have my sql statement

SelectCommand="SELECT [ID], [Name], [Add1], etc

Now, I want to present a different screen depending on the id type e.g

<% If [ID] = 1 Then %>

only what is the variable I need to put in place of the [ID] to recover the parameter of ID in the database because when I try this it just kicks up an error.

I am using VB by the way and appreciate any help. If you have the answer you will find me in the corner dribbling.

Well I guess your all as useless as me then...My mistake I though people knew what they were doing here and helped idiots like me out.

When coming to a forum looking for FREE help, insulting the user base is pretty much a guranteed way for you to NEVER get an answer, regardless of how simplistic your question maybe.

And how you retrieve this data will determine how your reference the ID column from your SQL statement.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

Maybe the "useless as me" and "idiots like me" comments were meant as a little self-deprecating humor but that's so hard to see in type so I'm locking this before it gets ugly. :) aasiddle, if you want to take a deep breath and start a new thread on the topic and try again nice and safe, please do. Sorry no one here answered. Keep in mind, this is a 100% volunteer, community, one person helping another out for no reward other than it feels good effort.

Jim Minatel
Senior Acquisitions Editor
Wiley Technology Publishing
WROX Press
Blog: http://wroxblog.typepad.com/
Jim's Book of the week: No book this week - Donate to the Red Cross!