My Form Solicits The Following:
Type of Pet: (radio button selection)
First Name (text)
Last Name (text)
Street Address (text/numeric)
City (text)
State (text)
Zip Code: (numeric)
Email: (text)
Phone: (numeric)
Name of Pet (Text)
Age (numeric)
Weight (numeric)
Breed (text)
Color (text)
Gender (radio button selection)
Spayed (radio button selection)
Rabies Vacine (radio button selection)
Pet Information (text box)
Photo (upload)
OptIn (Checkbox Yes/No)

The SQL table CREATION TOOL at my host has the following columns
KEY - Column - Type - Length - Prec. - Scale - Nullable - Default - ID. -
Id.Incr. -
Id. seed - Row GUID

I'm presuming the field name goes into the "Column" column. However, I am
seeking guidance in understanding how to respone/what to enter in the other
columns beginning with KEY and ending with Row GUID with the TYPE column
appearing to be the most significant. I would presume that VarChar would be
appropriate for the text fields and Int. appropriate for the numbers (zip
code etc) fields..............but who knows. The TYPLE Column provides a
drop down menu which provides the following list from which to choose:

BigInt, Binary, Bit, Char, DataTime, Decimal, Float, Image, Int, Money,
NChar, None,
NText. Numeric. NVarChar, NVarCharMax, Real, SmallDateTime, SmallInt,
SmallMoney, SysName, Text, TimeStamp, TinyInt, UniqueIdentifer, VarBinary
VarBinaryMax, VarChar, VarCharMax, Variant, XML

Can you direct me to a handy "jump start" learning aid/resource/cheat
sheet...................whatever..........that will get me "up and running".

PS: I wish there was a way of including an attachment with this question.

Thanks.






--
Templar