Likely what happened is they changed or updated the driver for their SQL
Server databases (or possibly MDAC or some other modification to the
server itself - I'm not sure offhand if MDAC is omitted with Java
drivers or not) and the new or updated driver, etc. just isn't
supporting that syntax... which I think is non-standard.
I believe the standard syntax would be
select scope_identity() as formatid from format
I'd probably even go the extra yard and say
select formatid from format
where formatid = scope_identity()
simply because I wouldn't put it past the driver to return a query
containing one copy of scope_identity() for every record in that table,
for example, it does that if you say:
select 5 as mynumber from mytable
if there are 5 records in mytable, you get
5
5
5
5
5
hth,
ike
--
s. isaac dealey ^ new epoch
isn't it time for a change?
ph: 503.236.3691
http://onTap.riaforge.org/blog
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296935
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
