You could try using the Max_ID custom tag from the fusebox.org site. I've
used it quite a bit with no problems.....
HTH,
Judith
Kevin Bridges put into words:
>I feel like an idiot asking this question, but here goes.
>
>Is it possible to increment an integer that is not an autonumber or sequence
>in an access database with a single query? I can't setup triggers or
>sequences and think that selecting the max() value of the field as one query
>then updating the value and using another query to insert that information
>sucks.
>
>Thanks!
>
>Kevin Bridges
Judith Taylor
ICQ: 67460562
Freelance ColdFusion Developer - Athens, OH
Friends don't let friends code before coffee.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
