the sql code. I find it much easier to write and read
<cfinsert datasource="dsn" fields="#fieldlist#" table="tblWhatever">
than:
<cfquery datasource="dsn" name="blah">
Insert into tblwhatever (field1,field2,field3,field4,.....)
Values (<cfqueryparam cfsqltype="cf_sql_integer"
value="#formval1#">,(<cfqueryparam cfsqltype="cf_sql_integer"
value="#formval2#">,(<cfqueryparam cfsqltype="cf_sql_integer"
value="#formval3#">,(<cfqueryparam cfsqltype="cf_sql_integer"
value="#formval4#">,.....
</cfquery>
Now if cfinsert could return that last inserted id, that would take care of
90% of my insert queries.
--
marlon
"And Bobby you are right, I am being selfish, but the last time I checked,
we don't have a whole lot of songs that feature the cowbell!"
> -----Original Message-----
> From: Robertson-Ravo, Neil (RX) [mailto:Neil.Robertson-
> [EMAIL PROTECTED]
> Sent: Tuesday, March 30, 2004 5:45 AM
> To: CF-Talk
> Subject: RE: Replacement for CFUpdate
>
> whats wrong with using SQL?
>
>
> _____
>
> From: Marlon Moyer [mailto:[EMAIL PROTECTED]
> Sent: 29 March 2004 22:58
> To: CF-Talk
> Subject: Replacement for CFUpdate
>
>
> Before I start making a replacement, does anyone already have a
> CFInsert/CFUpdate replacement custom tag. I love the using those 2 tags,
> but I want to extend them a bit. I'd like to be able to return the last
> id
> inserted on the cfinsert side.
>
> Marlon
> _____
>
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
