Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by josty
-
CFMAIL Formatting
If you want to use HTML code in your message, you need to set type="html" in the <cfmail> tag. -
Query result different in Access 97 and Access 2000
The following query matches records where two absolute numbers (i.e. 10.123 and 20.234) are between a certain round number (i.e. 15). To make this match possible I use Int() to convert the abs.numbers in the DB to an Integer without fraction. To prevent formatting errors the data-type of the... -
Get Primary Key Column?
Thanks for the timely response! Your answer shows me that my question was not correctly formed. In your answer it is already clear which field is the Primary Key field. What if you only know the table name and dynamically want to determine which of the table columns (maybe by looping over... -
Get Primary Key Column?
How can I get the Primary Key column(s) from an MSaccess database-table? I want to make a simple dynamic table-editor to use instead of CFGRID. I found column_list very handy, unfortunately I found no such variable for determining whether or not a field is primary,unique etc. I tried looking...
