Select * does not return Identity Column

Webmaster Forum / ColdFusion / Getting Started / August 2006

Select * does not return Identity Column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

umuayo - 29 Aug 2006 20:06 GMT

Any one know why CF is not returning my identity column? I need the value of
the Identity column to pass through URL and process record updates.

Select * does not return it.

Used #queryName.ColumnList# and it is not showing.

Reply to this Message

umuayo - 29 Aug 2006 20:23 GMT

Got it. I had to spell out the columns and @@ identity to retrieve the value of the Identity column

Reply to this Message

Dan Bracuk - 29 Aug 2006 20:24 GMT

Use your primary key field(s) instead.

Reply to this Message

Webmaster Forum / ColdFusion / Getting Started / August 2006

Select * does not return Identity Column