"Bob The ASP Builder" <boj@isplanket.com> wrote in message
news:1idl9111d49b2hu0crhkdla4kv1jmf2asn@4ax.com...
> On Mon, 30 May 2005 07:13:49 +0200, Bob The ASP Builder
> <boj@isplanket.com> wrote:
>
>>I use Access database with an ASP frontend.
>
> I actually found this little piece of code doing the right thing for
> me
>
> for each column in RS.fields
> if column.Properties("IsAutoIncrement") then
> Else
> Response.Write column.name
>
> Response.Write "<br>"
> End If
> next
>
> Thanks to myself
>

"Jon" <warpedpixel@gmail.com> wrote in message
news:u%23FWxdOZFHA.1868@TK2MSFTNGP14.phx.gbl...
> an alternative to that would be:
>
> for each column in RS.fields
> if column.name <> "IdField" then Response.Write column.name &
> "<BR>"
> next
>
> Just a suggestion to keep your code a bit shorter and also if you have any
> fields that use Autonumber than your Id Field (unlikely but possible) it
> won't write these either.
>
> --
> Jon
> warpedpixel@gmail.com
> Look at that dead pixel on your screen! *SLAP* Gotcha!
> "Bob The ASP Builder" <boj@isplanket.com> wrote in message
> news:1idl9111d49b2hu0crhkdla4kv1jmf2asn@4ax.com...
>> On Mon, 30 May 2005 07:13:49 +0200, Bob The ASP Builder
>> <boj@isplanket.com> wrote:
>>
>>>I use Access database with an ASP frontend.
>>
>> I actually found this little piece of code doing the right thing for
>> me
>>
>> for each column in RS.fields
>> if column.Properties("IsAutoIncrement") then
>> Else
>> Response.Write column.name
>>
>> Response.Write "<br>"
>> End If
>> next
>>
>> Thanks to myself
>>
>
>

<boj@isplanket.com> wrote:

>I use Access database with an ASP frontend.