RE: Multiple submitt + variable
OK this is what I have working. Does the job but seems rather complicated
just to get a value passed to another template...
Critiques and improvements welcomed.
Doug
--
form action=#URLsessionFormat(#self#?fuseaction=#XFA.ShowUserPage#)#
method=post
cfoutput query=UserList
cfoutput
input type=submit name=Status_#user_id# value=Status
/cfoutput
/cfoutput
/form
in ShowUserPage.cfm:
cfif ListLen(attributes.fieldnames) GT 0
cfset thisUserID =
cfset thisfieldname =
cfset count =
cfloop index=myfieldnames list=#attributes.fieldnames#
cfset thisfieldname = variables.myfieldnames
cfif find('_',variables.thisfieldname,1)
cfset count = find('_',variables.thisfieldname,1)
cfif NOT compareNoCase(Left(variables.thisfieldname,
variables.count), STATUS_)
cfset thisUserID = RemoveChars(variables.thisfieldname,1,
variables.count)
cfbreak
/cfif
/cfif
/cfloop
/cfif
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]
Sent: April 17, 2005 9:46 PM
To: CF-Talk
Subject: Re: Multiple submitt + variable
Try this. The trick is that when you get to your action page you loop
through the form fields looking for one with a name beginning with
ActivateMe_. When you find it, then you peel the user id value off of
the field name. I don't use fusebox, so I have no idea how consistent
this is with that methodology.
form action=somepage.cfm method=post
...
cfloop query=q
#myquery.username#
input type=submit name=ActivateMe_#q.user_id# value=This One
/cfloop
/form
In somepage.cfm:
cfset theuserid =
cfloop index=fieldname list=#form.fieldnames#
cfset fieldvalue = Evaluate(form. fieldname)
cfif Left(fieldvalue), 12) is ActivateMe_
cfset theuserid = ListLast(fieldvalue, _)
cfbreak
/cfif
/cfloop
- Original Message -
From: Douglas Fentiman [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Sunday, April 17, 2005 4:11 PM
Subject: Multiple submitt + variable
Hi all,
I have a form with multiple submit buttons. Each button has a unique
associated id value. I want to pass the associated id value with the
submit button that is pressed.
I have checked out the Multiple_Submit Tag, using input type=submit
name=_fuseaction=#XFA.userApprove#, which works well with a single
id value that can be passed as a hidden form field, but haven't been
able to figure out a way to use it with multiple id values.
Also played with appending the id value, input type=checkbox
name=ActivateMe_#user_id# value=1, and using a single submit
button. Then peeling the id value off in the recieving template. This
works but uses a single submit button. I would like to use multiple
submit buttons to make it a one click action for the user.
Any Ideas on how to do this?
-CFMX
-FB3
-no JavaScript
Thks,
Doug
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203159
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
macromedia and Adobe?!
The macromedia Home Page looks interesting.. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203160 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: macromedia and Adobe?!
Looks real. http://www.macromedia.com/macromedia/proom/pr/2005/adobe_macromedia.html Someone in the office just quipped Guess FireWorks will get the magnetic lasoo tool On 4/18/05, Kym Kovan [EMAIL PROTECTED] wrote: The macromedia Home Page looks interesting.. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203161 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
fyi: Adobe to aquire Macromedia
Fyi: http://www.macromedia.com/macromedia/proom/pr/2005/adobe_macromedia.html SAN JOSE, Calif. - April 18, 2005 - Adobe Systems Incorporated (Nasdaq: ADBE) today announced a definitive agreement to acquire Macromedia (Nasdaq: MACR) in an all-stock transaction valued at approximately $3.4 billion Micha Schopman Project Manager ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203162 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: macromedia and Adobe?!
Oops :X Micha Schopman Project Manager -Original Message- From: Jon Austin [mailto:[EMAIL PROTECTED] Sent: maandag 18 april 2005 9:02 To: CF-Talk Subject: Re: macromedia and Adobe?! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203163 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Adobe to aquire Macromedia
Christ :o -Original Message- From: Micha Schopman [mailto:[EMAIL PROTECTED] Sent: Monday, 18 April 2005 4:17 To: CF-Talk Subject: fyi: Adobe to aquire Macromedia Fyi: http://www.macromedia.com/macromedia/proom/pr/2005/adobe_macromedia.html SAN JOSE, Calif. - April 18, 2005 - Adobe Systems Incorporated (Nasdaq: ADBE) today announced a definitive agreement to acquire Macromedia (Nasdaq: MACR) in an all-stock transaction valued at approximately $3.4 billion ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203164 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Adobe to aquire Macromedia
I second that christ, I mean, what kind of working hours are they working over there, it was about 4am in Calif. When you posted that message ;-) -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 09:39 To: CF-Talk Subject: RE: Adobe to aquire Macromedia Christ :o -Original Message- From: Micha Schopman [mailto:[EMAIL PROTECTED] Sent: Monday, 18 April 2005 4:17 To: CF-Talk Subject: fyi: Adobe to aquire Macromedia Fyi: http://www.macromedia.com/macromedia/proom/pr/2005/adobe_macro media.html SAN JOSE, Calif. - April 18, 2005 - Adobe Systems Incorporated (Nasdaq: ADBE) today announced a definitive agreement to acquire Macromedia (Nasdaq: MACR) in an all-stock transaction valued at approximately $3.4 billion ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203165 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: macromedia and Adobe?!
Say goodbye to Freehand then. Just as Coldfusion Studio was absorbed into Dreamweaver when Macromedia purchased Allaire, it is highly unlikely that Adobe will continue to produce both Illustrator and Freehand. We might even find Fireworks absorbed into Photoshop... -- Jay -Original Message- From: Kym Kovan [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 08:58 To: CF-Talk Subject: macromedia and Adobe?! The macromedia Home Page looks interesting.. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203166 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: macromedia and Adobe?!
And GoLive absorbed into Dreamweaver. Micha Schopman Project Manager ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203167 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: macromedia and Adobe?!
Yep, say goodbye to... Freehand, Fireworks, Homesite etc It is not a good omen for CF. -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 09:59 To: CF-Talk Subject: RE: macromedia and Adobe?! Say goodbye to Freehand then. Just as Coldfusion Studio was absorbed into Dreamweaver when Macromedia purchased Allaire, it is highly unlikely that Adobe will continue to produce both Illustrator and Freehand. We might even find Fireworks absorbed into Photoshop... -- Jay -Original Message- From: Kym Kovan [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 08:58 To: CF-Talk Subject: macromedia and Adobe?! The macromedia Home Page looks interesting.. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203168 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: macromedia and Adobe?!
Interesting times ahead. There are going to be a lot of unhappy people all round when they start dumping/merging competing products from either of the company's portfolios. (I just hope GoLive gets the bin treatment) I'm surprised that the monopolies commission (or whatever its called in the US) hasn't had words about this really. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203169 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: macromedia and Adobe?!
Wow, this is just totally surreal. Had a complete out-of-body experience there for a few minutes. The perspectives and consequences are just mind-boggling.. And not necessarily all bad. Adobe ColdFusion Adobe JRun Adobe Flex Adobe Dreamweaver Heh. The thought makes my head spin. I wonder what it will mean for CF. Wild stuff. Jack ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203170 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: macromedia and Adobe?!
I'm NOT excited about putting: Powered by Dried Mud ON ANYTHING! But that's another issue... :) J On 4/18/05, Jack Dalaa [EMAIL PROTECTED] wrote: Wow, this is just totally surreal. Had a complete out-of-body experience there for a few minutes. The perspectives and consequences are just mind-boggling.. And not necessarily all bad. Adobe ColdFusion Adobe JRun Adobe Flex Adobe Dreamweaver Heh. The thought makes my head spin. I wonder what it will mean for CF. Wild stuff. Jack -- --- - Buy SQLSurveyor! http://www.web-relevant.com/sqlsurveyor Never make your developers open Enterprise Manager again. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203171 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: macromedia and Adobe?!
On Monday 18 Apr 2005 10:26 am, Jack Dalaa wrote: Adobe ColdFusion It's true Adobe don't have a app server in their list of products, so I *imagine* CF is safe. I hope. Some sort of statement would be good. I've never like Adobe's tools, and I can't imagine they'll want to make a decent IDE out of the mish-mash of wider-audience products they've now got. Rock on CFEclipse :-) Incidentally, it looks more like a takeover of MM by Adobe, looking at the board make-up etc. -- Tom Chiverton Advanced ColdFusion Programmer ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203172 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: fyi: Adobe to aquire Macromedia
On list, so many times we discussed managemente and strategy and Macromedia. For a long time I felt that there product line was way to diverse. Very Good product with extraordinary potential but to many competing consumer interest to manage. What next. Look to see a sell off of the parts. Breeze will proably go a separate way maybe even ColdFusion. Dwayne -- Original Message -- From: Micha Schopman [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com Date: Mon, 18 Apr 2005 10:16:30 +0200 Fyi: http://www.macromedia.com/macromedia/proom/pr/2005/adobe_macromedia.html SAN JOSE, Calif. - April 18, 2005 - Adobe Systems Incorporated (Nasdaq: ADBE) today announced a definitive agreement to acquire Macromedia (Nasdaq: MACR) in an all-stock transaction valued at approximately $3.4 billion Micha Schopman Project Manager ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203173 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: macromedia and Adobe?!
They probably want dump. The better than to do is to sell the product to small more focused organization. In other words, It's time for the Allairs of the world to step back in, take these products with very slow and incremental upgrade cycles and reenergize them. Dwayne D. Cole, MBA FluxFlow -- Original Message -- From: Stephen Moretti (cfmaster) [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com Date: Mon, 18 Apr 2005 10:20:21 +0100 Interesting times ahead. There are going to be a lot of unhappy people all round when they start dumping/merging competing products from either of the company's portfolios. (I just hope GoLive gets the bin treatment) I'm surprised that the monopolies commission (or whatever its called in the US) hasn't had words about this really. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203174 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: fyi: Adobe to aquire Macromedia
On Monday 18 Apr 2005 11:33 am, Dwayne Cole wrote: separate way maybe even ColdFusion. What makes you think that ? -- Tom Chiverton Advanced ColdFusion Programmer ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203175 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Last ID inserted
Hi guys, I am inserting to a few tables at once (ms-sql, cf7.0). One table will insert into the tableUsers and then I will insert into tableQuestions. In tableQuestions i will want to put the contents of the userID which i just inserted into tableUsers. Can anyone tell me how I can get the exact userID which I just inserted so I can put into my tableQuestions table? I know of MaxID (or something like that) but i am worried that in some cases there may be more than one person accessing the DB and I may grab the incorrect information. Any ideas would be appreciated. Thanks, Saturday ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203176 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: macromedia and Adobe?!
Thomas Chiverton wrote: Incidentally, it looks more like a takeover of MM by Adobe, looking at the board make-up etc. PDF FAQ http://snipurl.com/abodemacromediaFAQ ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203177 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Last ID inserted
SET NOCOUNT ON INSERT INTO tableUsers (blah) VALUES (moreblah) SELECT InsertedID = Scope_Identity() SET NOCOUNT OFF HTH On 4/18/05, Stuart Kidd [EMAIL PROTECTED] wrote: Hi guys, I am inserting to a few tables at once (ms-sql, cf7.0). One table will insert into the tableUsers and then I will insert into tableQuestions. In tableQuestions i will want to put the contents of the userID which i just inserted into tableUsers. Can anyone tell me how I can get the exact userID which I just inserted so I can put into my tableQuestions table? I know of MaxID (or something like that) but i am worried that in some cases there may be more than one person accessing the DB and I may grab the incorrect information. Any ideas would be appreciated. Thanks, Saturday ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203178 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Last ID inserted
set nocount on insert into tbl select @@identity as newid set nocount off -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 11:48 To: CF-Talk Subject: Last ID inserted Hi guys, I am inserting to a few tables at once (ms-sql, cf7.0). One table will insert into the tableUsers and then I will insert into tableQuestions. In tableQuestions i will want to put the contents of the userID which i just inserted into tableUsers. Can anyone tell me how I can get the exact userID which I just inserted so I can put into my tableQuestions table? I know of MaxID (or something like that) but i am worried that in some cases there may be more than one person accessing the DB and I may grab the incorrect information. Any ideas would be appreciated. Thanks, Saturday ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203179 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: macromedia and Adobe?!
Great say goodbye to flash paper... Adam H On 4/18/05, Stephen Moretti (cfmaster) [EMAIL PROTECTED] wrote: Thomas Chiverton wrote: Incidentally, it looks more like a takeover of MM by Adobe, looking at the board make-up etc. PDF FAQ http://snipurl.com/abodemacromediaFAQ ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203180 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: macromedia and Adobe?!
Talk about canned answers heh search for this Adobe and Macromedia are committed to serving the needs of our combined customers. The companies are largely complementary, and thus the amount of competition between us is limited. Post closing, we believe the industry will remain as dynamic and competitive as it is today. Until the close of transaction, the companies will continue to operate business and usual. The combined company will not be able to create a joint product roadmap until after the transaction is closed. I know its in there atleast twice from skimming the document. Anyways happy monday to everyone :) Adam H On 4/18/05, Stephen Moretti (cfmaster) [EMAIL PROTECTED] wrote: Thomas Chiverton wrote: Incidentally, it looks more like a takeover of MM by Adobe, looking at the board make-up etc. PDF FAQ http://snipurl.com/abodemacromediaFAQ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203181 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: macromedia and Adobe?!
That's got to be on their hitlist, must break the MM developers hearts -Original Message- From: Adam Haskell [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 11:59 To: CF-Talk Subject: Re: macromedia and Adobe?! Great say goodbye to flash paper... Adam H On 4/18/05, Stephen Moretti (cfmaster) [EMAIL PROTECTED] wrote: Thomas Chiverton wrote: Incidentally, it looks more like a takeover of MM by Adobe, looking at the board make-up etc. PDF FAQ http://snipurl.com/abodemacromediaFAQ ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203182 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: macromedia and Adobe?!
It is too early (and too dangerous for your organization) for making assumptions which products will live or stop to exist. Let's hope Adobe doesn't make Spectra decisions damaging businesses in a serious way and it respects their customers and user base. Ofcourse you will see more integration, and yes, it might be that a superior product like Photoshop CS 2 will be leading instead of the much smaller Fireworks. To spice some up, it might well Adobe tries to deploy a light version of Photoshop CS 2 based on FireWorks. The chances products get integrated is high, the chances products are cancelled is high. What products could be cancelled; products that are too young and too immature, products which are difficult to combine, products which are difficult to sell due to high competition, products who just do not fit in the strategy of the company. Like this news, some future press releases will come as a shock also I guess. I don't believe ColdFusion is one of them in terms of negative aspects. I see a lot of options for ColdFusion integration with Adobe products like PDF conversion, Document Management, etc. Time will tell. I wonder what the name might be ... Macrobe ? Micha Schopman Project Manager Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203183 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: macromedia and Adobe?!
Time will tell. I wonder what the name might be ... Macrobe ? the name is in the PDF What will be the name of the combined company? Adobe Systems Incorporated. Adam H On 4/18/05, Micha Schopman [EMAIL PROTECTED] wrote: It is too early (and too dangerous for your organization) for making assumptions which products will live or stop to exist. Let's hope Adobe doesn't make Spectra decisions damaging businesses in a serious way and it respects their customers and user base. Ofcourse you will see more integration, and yes, it might be that a superior product like Photoshop CS 2 will be leading instead of the much smaller Fireworks. To spice some up, it might well Adobe tries to deploy a light version of Photoshop CS 2 based on FireWorks. The chances products get integrated is high, the chances products are cancelled is high. What products could be cancelled; products that are too young and too immature, products which are difficult to combine, products which are difficult to sell due to high competition, products who just do not fit in the strategy of the company. Like this news, some future press releases will come as a shock also I guess. I don't believe ColdFusion is one of them in terms of negative aspects. I see a lot of options for ColdFusion integration with Adobe products like PDF conversion, Document Management, etc. Time will tell. I wonder what the name might be ... Macrobe ? Micha Schopman Project Manager Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203184 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Last ID inserted
One table will insert into the tableUsers and then I will insert into tableQuestions. In tableQuestions i will want to put the contents of the userID which i just inserted into tableUsers. Can anyone tell me how I can get the exact userID which I just inserted so I can put into my tableQuestions table? I use stored procedures for most of the SQL Server stuff so I build in the @@Identity function into the procedures. Hatton ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203185 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: macromedia and Adobe?!
It is too early (and too dangerous for your organization) for making assumptions which products will live or stop to exist. Let's hope Adobe doesn't make Spectra decisions damaging businesses in a serious way and it respects their customers and user base. This is 100% true the actual aquisistion is not set to go down until 4th quater and a lot can not be disclosed or really even decided until that merger is finalized. I do find it funny though that less than a Month ago we had adobe in here talking about their Intellegent PDF documents and Falsh paper was brought up in questions and they barely knew anything about it... Adam H ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203186 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Last ID inserted
SELECT @@IDENTITY is all you need. -Original Message- From: JediHomer [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 11:53 To: CF-Talk Subject: Re: Last ID inserted SET NOCOUNT ON INSERT INTO tableUsers (blah) VALUES (moreblah) SELECT InsertedID = Scope_Identity() SET NOCOUNT OFF HTH On 4/18/05, Stuart Kidd [EMAIL PROTECTED] wrote: Hi guys, I am inserting to a few tables at once (ms-sql, cf7.0). One table will insert into the tableUsers and then I will insert into tableQuestions. In tableQuestions i will want to put the contents of the userID which i just inserted into tableUsers. Can anyone tell me how I can get the exact userID which I just inserted so I can put into my tableQuestions table? I know of MaxID (or something like that) but i am worried that in some cases there may be more than one person accessing the DB and I may grab the incorrect information. Any ideas would be appreciated. Thanks, Saturday ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203187 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Last ID inserted
Except that the @@IDENTITY is the last inserted ID, if you have any triggers setup that insert then this could be affected, Scope_Identity() locks the ID getting to the current scope/view so remains unaffected by triggers etc On 4/18/05, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: SELECT @@IDENTITY is all you need. -Original Message- From: JediHomer [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 11:53 To: CF-Talk Subject: Re: Last ID inserted SET NOCOUNT ON INSERT INTO tableUsers (blah) VALUES (moreblah) SELECT InsertedID = Scope_Identity() SET NOCOUNT OFF HTH On 4/18/05, Stuart Kidd [EMAIL PROTECTED] wrote: Hi guys, I am inserting to a few tables at once (ms-sql, cf7.0). One table will insert into the tableUsers and then I will insert into tableQuestions. In tableQuestions i will want to put the contents of the userID which i just inserted into tableUsers. Can anyone tell me how I can get the exact userID which I just inserted so I can put into my tableQuestions table? I know of MaxID (or something like that) but i am worried that in some cases there may be more than one person accessing the DB and I may grab the incorrect information. Any ideas would be appreciated. Thanks, Saturday ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203188 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Last ID inserted
Triggers...?! ;-) evil evil evil... -Original Message- From: JediHomer [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 12:36 To: CF-Talk Subject: Re: Last ID inserted Except that the @@IDENTITY is the last inserted ID, if you have any triggers setup that insert then this could be affected, Scope_Identity() locks the ID getting to the current scope/view so remains unaffected by triggers etc On 4/18/05, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: SELECT @@IDENTITY is all you need. -Original Message- From: JediHomer [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 11:53 To: CF-Talk Subject: Re: Last ID inserted SET NOCOUNT ON INSERT INTO tableUsers (blah) VALUES (moreblah) SELECT InsertedID = Scope_Identity() SET NOCOUNT OFF HTH On 4/18/05, Stuart Kidd [EMAIL PROTECTED] wrote: Hi guys, I am inserting to a few tables at once (ms-sql, cf7.0). One table will insert into the tableUsers and then I will insert into tableQuestions. In tableQuestions i will want to put the contents of the userID which i just inserted into tableUsers. Can anyone tell me how I can get the exact userID which I just inserted so I can put into my tableQuestions table? I know of MaxID (or something like that) but i am worried that in some cases there may be more than one person accessing the DB and I may grab the incorrect information. Any ideas would be appreciated. Thanks, Saturday ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203189 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Last ID inserted
Thanks for all your help on that everyone, the responses more than answered my question! :) When i get home i will put it into my code. Saturday From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] Sent: 18 April 2005 07:42 To: CF-Talk cf-talk@houseoffusion.com Subject: RE: Last ID inserted Triggers...?! ;-) evil evil evil... -Original Message- From: JediHomer [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 12:36 To: CF-Talk Subject: Re: Last ID inserted Except that the @@IDENTITY is the last inserted ID, if you have any triggers setup that insert then this could be affected, Scope_Identity() locks the ID getting to the current scope/view so remains unaffected by triggers etc On 4/18/05, Robertson-Ravo, Neil (RX) wrote: SELECT @@IDENTITY is all you need. -Original Message- From: JediHomer [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 11:53 To: CF-Talk Subject: Re: Last ID inserted SET NOCOUNT ON INSERT INTO tableUsers (blah) VALUES (moreblah) SELECT InsertedID = Scope_Identity() SET NOCOUNT OFF HTH On 4/18/05, Stuart Kidd wrote: Hi guys, I am inserting to a few tables at once (ms-sql, cf7.0). One table will insert into the tableUsers and then I will insert into tableQuestions. In tableQuestions i will want to put the contents of the userID which i just inserted into tableUsers. Can anyone tell me how I can get the exact userID which I just inserted so I can put into my tableQuestions table? I know of MaxID (or something like that) but i am worried that in some cases there may be more than one person accessing the DB and I may grab the incorrect information. Any ideas would be appreciated. Thanks, Saturday ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203190 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: macromedia and Adobe?!
I personally would not care much about Flash paper either. PDF has much more potential when you look at forms, security, workflow, portability, notes, and the open format. A bit harsh, but I think Macromedia should not have tried to reinvent the wheel with Flash paper while PDF was increasing their market share at a high rate. If I missed something with Flash paper, please tell. Too bad for the Flash paper team if the product gets the bin treatment, but sometimes sacrifices have to be made for improving the rest of the company. Those decisions are not easy to make, but that is where managers are for. Micha Schopman Project Manager Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203191 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: macromedia and Adobe?!
Flash paper is lightwieght and fast loading. Its very nice for presenting unsecure information on the web. I would not be suprised if both survive...after reading most of the PDF they are dissimular enough for both products to have a place in Adobe. Adam H On 4/18/05, Micha Schopman [EMAIL PROTECTED] wrote: I personally would not care much about Flash paper either. PDF has much more potential when you look at forms, security, workflow, portability, notes, and the open format. A bit harsh, but I think Macromedia should not have tried to reinvent the wheel with Flash paper while PDF was increasing their market share at a high rate. If I missed something with Flash paper, please tell. Too bad for the Flash paper team if the product gets the bin treatment, but sometimes sacrifices have to be made for improving the rest of the company. Those decisions are not easy to make, but that is where managers are for. Micha Schopman Project Manager Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203192 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
SQL Triggers (was Re: Last ID inserted)
Triggers...?! ;-) evil evil evil... Why do you say that? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203193 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: macromedia and Adobe?!
Let's hope so :-) -Original Message- From: Micha Schopman [mailto:[EMAIL PROTECTED] Sent: Monday, 18 April 2005 5:04 To: CF-Talk Subject: RE: macromedia and Adobe?! And GoLive absorbed into Dreamweaver. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203194 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Triggers (was Re: Last ID inserted)
Well, for one they can be hard to track / find if you are not the developer and have sufficient rights to look at them, they are also a performance drain when simple constraint should be enough. Most cases which use a trigger now are unnecessary. -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 13:27 To: CF-Talk Subject: SQL Triggers (was Re: Last ID inserted) Triggers...?! ;-) evil evil evil... Why do you say that? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203195 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Need Help
Thanks Justin. That is definitly the road I need to go down. I went along the same thoughts with the 96 blocks but I couldn't figure out how to handle the individual users having different block requirements each time and how to display the form. Frank ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203196 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Last ID inserted
Dont use @@Identity. Even the books on line (the online help for
SQLServer) says it's risky in many circumstances. That was from an
earlier version of SQLServer. The correct function to use is either
Scope_identity() or Ident_current() .
Dont take our word for it, read the books online entry. It seems the
more we say DONT use @@Identity, the more people say DO use
@@Identity.
It's not MY words saying dont use it, its MICROSOFT's own help file
that says @@Identity has risks of giving the wrong answer, especially
when you have many inserts going on simultaneously.
There'll no doubt be lots of people saying well I've been using
@@Identity and it's been fine for me. And the answer to that is
you're lucky. Read Books on line about it.
According to books on line, the correct query to use is:
cfquery name=insertquery datasource=#application.dsn#
SET NOCOUNT ON
INSERT into myTable (
fieldname1,
fieldname2,
fieldname3)
VALUES (
'#form.fieldname1#',
'#form.fieldname2#',
'#form.fieldname3#')
SELECT Ident_Current('myTable') as NewID
SET NOCOUNT OFF
/cfquery
pNew Identity is #insertquery.NewID#/p
Cheers
Mike Kear
Windsor, NSW, Australia
Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
On 4/18/05, Stuart Kidd [EMAIL PROTECTED] wrote:
Thanks for all your help on that everyone, the responses more than answered
my question! :)
When i get home i will put it into my code.
Saturday
From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED]
Sent: 18 April 2005 07:42
To: CF-Talk cf-talk@houseoffusion.com
Subject: RE: Last ID inserted
Triggers...?! ;-) evil evil evil...
-Original Message-
From: JediHomer [mailto:[EMAIL PROTECTED]
Sent: 18 April 2005 12:36
To: CF-Talk
Subject: Re: Last ID inserted
Except that the @@IDENTITY is the last inserted ID, if you have any
triggers setup that insert then this could be affected,
Scope_Identity() locks the ID getting to the current scope/view so
remains unaffected by triggers etc
On 4/18/05, Robertson-Ravo, Neil (RX)
wrote:
SELECT @@IDENTITY is all you need.
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203197
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Last ID inserted
Mike Kear wrote: Dont use @@Identity. Even the books on line (the online help for where exactly? Dont take our word for it, read the books online entry. It seems the again where exactly? It's not MY words saying dont use it, its MICROSOFT's own help file that says @@Identity has risks of giving the wrong answer, especially when you have many inserts going on simultaneously. oh my, where does BoL say that? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203198 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Last ID inserted
Cheers for the heads up Mike.
-Original Message-
From: Mike Kear [mailto:[EMAIL PROTECTED]
Sent: 18 April 2005 14:10
To: CF-Talk
Subject: Re: Last ID inserted
Dont use @@Identity. Even the books on line (the online help for
SQLServer) says it's risky in many circumstances. That was from an
earlier version of SQLServer. The correct function to use is either
Scope_identity() or Ident_current() .
Dont take our word for it, read the books online entry. It seems the
more we say DONT use @@Identity, the more people say DO use
@@Identity.
It's not MY words saying dont use it, its MICROSOFT's own help file
that says @@Identity has risks of giving the wrong answer, especially
when you have many inserts going on simultaneously.
There'll no doubt be lots of people saying well I've been using
@@Identity and it's been fine for me. And the answer to that is
you're lucky. Read Books on line about it.
According to books on line, the correct query to use is:
cfquery name=insertquery datasource=#application.dsn#
SET NOCOUNT ON
INSERT into myTable (
fieldname1,
fieldname2,
fieldname3)
VALUES (
'#form.fieldname1#',
'#form.fieldname2#',
'#form.fieldname3#')
SELECT Ident_Current('myTable') as NewID
SET NOCOUNT OFF
/cfquery
pNew Identity is #insertquery.NewID#/p
Cheers
Mike Kear
Windsor, NSW, Australia
Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
On 4/18/05, Stuart Kidd [EMAIL PROTECTED] wrote:
Thanks for all your help on that everyone, the responses more than
answered my question! :)
When i get home i will put it into my code.
Saturday
From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED]
Sent: 18 April 2005 07:42
To: CF-Talk cf-talk@houseoffusion.com
Subject: RE: Last ID inserted
Triggers...?! ;-) evil evil evil...
-Original Message-
From: JediHomer [mailto:[EMAIL PROTECTED]
Sent: 18 April 2005 12:36
To: CF-Talk
Subject: Re: Last ID inserted
Except that the @@IDENTITY is the last inserted ID, if you have any
triggers setup that insert then this could be affected,
Scope_Identity() locks the ID getting to the current scope/view so
remains unaffected by triggers etc
On 4/18/05, Robertson-Ravo, Neil (RX)
wrote:
SELECT @@IDENTITY is all you need.
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203199
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Last ID inserted
From: Paul Hastings [mailto:[EMAIL PROTECTED]
Mike Kear wrote:
Dont use @@Identity. Even the books on line (the online help for
where exactly?
Dont take our word for it, read the books online entry. It
seems the
again where exactly?
It's not MY words saying dont use it, its MICROSOFT's own help file
that says @@Identity has risks of giving the wrong answer,
especially
when you have many inserts going on simultaneously.
oh my, where does BoL say that?
Given the lack of quotes in Mike's post, I would venture to guess he was
summarizing and drawing a conclusion which is correct.
@@IDENTITY
Returns the last-inserted identity value.
Syntax
@@IDENTITY
Return Types
numeric
Remarks
After an INSERT, SELECT INTO, or bulk copy statement completes, @@IDENTITY
contains the last identity value generated by the statement. If the
statement did not affect any tables with identity columns, @@IDENTITY
returns NULL. If multiple rows are inserted, generating multiple identity
values, @@IDENTITY returns the last identity value generated. If the
statement fires one or more triggers that perform inserts that generate
identity values, calling @@IDENTITY immediately after the statement returns
the last identity value generated by the triggers. The @@IDENTITY value does
not revert to a previous setting if the INSERT or SELECT INTO statement or
bulk copy fails, or if the transaction is rolled back.
@@IDENTITY, SCOPE_IDENTITY, and IDENT_CURRENT are similar functions in that
they return the last value inserted into the IDENTITY column of a table.
@@IDENTITY and SCOPE_IDENTITY will return the last identity value generated
in any table in the current session. However, SCOPE_IDENTITY returns the
value only within the current scope; @@IDENTITY is not limited to a specific
scope.
IDENT_CURRENT is not limited by scope and session; it is limited to a
specified table. IDENT_CURRENT returns the identity value generated for a
specific table in any session and any scope. For more information, see
IDENT_CURRENT.
Examples
This example inserts a row into a table with an identity column and uses
@@IDENTITY to display the identity value used in the new row.
INSERT INTO jobs (job_desc,min_lvl,max_lvl)
VALUES ('Accountant',12,125)
SELECT @@IDENTITY AS 'Identity'
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203200
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Last ID inserted
I cannot see in BOL where it says not to use it (I am on BOL SQL 2000
(Updated)). I certainly know that @@IDENTITY will give you the last known
identity for any table / scope.
I don't use SCOPE_IDENTITY much but have done.
-Original Message-
From: Mike Kear [mailto:[EMAIL PROTECTED]
Sent: 18 April 2005 14:10
To: CF-Talk
Subject: Re: Last ID inserted
Dont use @@Identity. Even the books on line (the online help for
SQLServer) says it's risky in many circumstances. That was from an
earlier version of SQLServer. The correct function to use is either
Scope_identity() or Ident_current() .
Dont take our word for it, read the books online entry. It seems the
more we say DONT use @@Identity, the more people say DO use
@@Identity.
It's not MY words saying dont use it, its MICROSOFT's own help file
that says @@Identity has risks of giving the wrong answer, especially
when you have many inserts going on simultaneously.
There'll no doubt be lots of people saying well I've been using
@@Identity and it's been fine for me. And the answer to that is
you're lucky. Read Books on line about it.
According to books on line, the correct query to use is:
cfquery name=insertquery datasource=#application.dsn#
SET NOCOUNT ON
INSERT into myTable (
fieldname1,
fieldname2,
fieldname3)
VALUES (
'#form.fieldname1#',
'#form.fieldname2#',
'#form.fieldname3#')
SELECT Ident_Current('myTable') as NewID
SET NOCOUNT OFF
/cfquery
pNew Identity is #insertquery.NewID#/p
Cheers
Mike Kear
Windsor, NSW, Australia
Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
On 4/18/05, Stuart Kidd [EMAIL PROTECTED] wrote:
Thanks for all your help on that everyone, the responses more than
answered my question! :)
When i get home i will put it into my code.
Saturday
From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED]
Sent: 18 April 2005 07:42
To: CF-Talk cf-talk@houseoffusion.com
Subject: RE: Last ID inserted
Triggers...?! ;-) evil evil evil...
-Original Message-
From: JediHomer [mailto:[EMAIL PROTECTED]
Sent: 18 April 2005 12:36
To: CF-Talk
Subject: Re: Last ID inserted
Except that the @@IDENTITY is the last inserted ID, if you have any
triggers setup that insert then this could be affected,
Scope_Identity() locks the ID getting to the current scope/view so
remains unaffected by triggers etc
On 4/18/05, Robertson-Ravo, Neil (RX)
wrote:
SELECT @@IDENTITY is all you need.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203201
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: macromedia and Adobe?!
Heh, I never even said hello. I think I'm going to reinstall CF Studio 4.5 just so I can have some Allaire back in my life. Ah, those were the days, back before their stock took a dump... Pete On 4/18/05, Adam Haskell [EMAIL PROTECTED] wrote: Great say goodbye to flash paper... Adam H ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203202 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: macromedia and Adobe?!
I predict a new tag cfpsd Oh dear. Kevin. -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Monday, April 18, 2005 9:21 AM To: CF-Talk Subject: Re: macromedia and Adobe?! Heh, I never even said hello. I think I'm going to reinstall CF Studio 4.5 just so I can have some Allaire back in my life. Ah, those were the days, back before their stock took a dump... Pete On 4/18/05, Adam Haskell [EMAIL PROTECTED] wrote: Great say goodbye to flash paper... Adam H ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203203 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: macromedia and Adobe?!
http://tinyurl.com/dhg3f g --- On Monday, April 18, 2005 3:57 AM, Kym Kovan scribed: --- The macromedia Home Page looks interesting.. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203204 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Last ID inserted
Michael T. Tangorre wrote: Given the lack of quotes in Mike's post, I would venture to guess he was summarizing and drawing a conclusion which is correct. no, it's not correct. as far as i can see no where does BoL say not to use @@IDENTITY nor does it says it's dangerous under load. the other IDENTITY functions give finer/coarser control over what gets returned but to make those kinds of statements based on saying BOL said so when it doesn't, isn't in any sense of the word, correct. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203205 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Bloomberg article
While looking at news articles about the buyout, I noticed a few interesting things in the Bloomberg news... Paragraph one of the article: April 18 (Bloomberg) -- Adobe Systems Inc., the world's largest maker of graphic-design software, agreed to buy Macromedia Inc. for about $3.4 billion to add Flash Web-design programs to its offerings. Wow.. $3.4 billion seems like a lot to pay for Flash, doesn't it? Paragraph 3: Macromedia's Flash Player, which displays moving images and sound on Web pages, is installed in more than 98 percent of Internet-connected desktop computers. By buying Macromedia, Adobe Chief Executive Bruce Chizen, 49, is reducing reliance on his flagship Acrobat software, used by graphics professionals. Aside from the ridiculous oversimplification of the flash player, no other macromedia products are mentioned in the article. http://quote.bloomberg.com/apps/news?pid=1006sid=axwg53VQvr0Urefer=home - Rick ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203206 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: macromedia and Adobe?!
Even better Ben Forta's new book, Photoshop CS2 in 21 days Kevin. -Original Message- From: Kazmierczak, Kevin [mailto:[EMAIL PROTECTED] Sent: Monday, April 18, 2005 9:26 AM To: CF-Talk Subject: RE: macromedia and Adobe?! I predict a new tag cfpsd Oh dear. Kevin. -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Monday, April 18, 2005 9:21 AM To: CF-Talk Subject: Re: macromedia and Adobe?! Heh, I never even said hello. I think I'm going to reinstall CF Studio 4.5 just so I can have some Allaire back in my life. Ah, those were the days, back before their stock took a dump... Pete On 4/18/05, Adam Haskell [EMAIL PROTECTED] wrote: Great say goodbye to flash paper... Adam H ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203207 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Last ID inserted
Michael got the extract right. True, books on line doesnt say NOT to
use @@identity, but it does say it's risky if there are several
inserts going on at once.
@@IDENTITY gives you the identity from the last insert in the
database, whereever it was. Which might or might not be the one you
want. If your insert triggers other inserts in other tables, you'll
get the ident of the last insert in the last table of your triggered
inserts. If there are multiple threads inserting elsewhere in the
database, you'll get whatever was the last one, which might be
someone else's insert in a completely different transactoin.If you
use Ident_current('tablename') you get the last insert on the table
you're looking at. It's far more specific and far less prone to
giving you misleading results.
Cheers
Mike Kear
Windsor, NSW, Australia
Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
On 4/18/05, Robertson-Ravo, Neil (RX)
[EMAIL PROTECTED] wrote:
I cannot see in BOL where it says not to use it (I am on BOL SQL 2000
(Updated)). I certainly know that @@IDENTITY will give you the last known
identity for any table / scope.
I don't use SCOPE_IDENTITY much but have done.
-Original Message-
From: Mike Kear [mailto:[EMAIL PROTECTED]
Sent: 18 April 2005 14:10
To: CF-Talk
Subject: Re: Last ID inserted
Dont use @@Identity. Even the books on line (the online help for
SQLServer) says it's risky in many circumstances. That was from an
earlier version of SQLServer. The correct function to use is either
Scope_identity() or Ident_current() .
Dont take our word for it, read the books online entry. It seems the
more we say DONT use @@Identity, the more people say DO use
@@Identity.
It's not MY words saying dont use it, its MICROSOFT's own help file
that says @@Identity has risks of giving the wrong answer, especially
when you have many inserts going on simultaneously.
There'll no doubt be lots of people saying well I've been using
@@Identity and it's been fine for me. And the answer to that is
you're lucky. Read Books on line about it.
According to books on line, the correct query to use is:
cfquery name=insertquery datasource=#application.dsn#
SET NOCOUNT ON
INSERT into myTable (
fieldname1,
fieldname2,
fieldname3)
VALUES (
'#form.fieldname1#',
'#form.fieldname2#',
'#form.fieldname3#')
SELECT Ident_Current('myTable') as NewID
SET NOCOUNT OFF
/cfquery
pNew Identity is #insertquery.NewID#/p
Cheers
Mike Kear
Windsor, NSW, Australia
Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
On 4/18/05, Stuart Kidd [EMAIL PROTECTED] wrote:
Thanks for all your help on that everyone, the responses more than
answered my question! :)
When i get home i will put it into my code.
Saturday
From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED]
Sent: 18 April 2005 07:42
To: CF-Talk cf-talk@houseoffusion.com
Subject: RE: Last ID inserted
Triggers...?! ;-) evil evil evil...
-Original Message-
From: JediHomer [mailto:[EMAIL PROTECTED]
Sent: 18 April 2005 12:36
To: CF-Talk
Subject: Re: Last ID inserted
Except that the @@IDENTITY is the last inserted ID, if you have any
triggers setup that insert then this could be affected,
Scope_Identity() locks the ID getting to the current scope/view so
remains unaffected by triggers etc
On 4/18/05, Robertson-Ravo, Neil (RX)
wrote:
SELECT @@IDENTITY is all you need.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203208
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: macromedia and Adobe?!
W...T...F On 4/18/05, Stephen Moretti (cfmaster) [EMAIL PROTECTED] wrote: Thomas Chiverton wrote: Incidentally, it looks more like a takeover of MM by Adobe, looking at the board make-up etc. PDF FAQ http://snipurl.com/abodemacromediaFAQ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203209 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Last ID inserted
From: Paul Hastings [mailto:[EMAIL PROTECTED] no, it's not correct. as far as i can see no where does BoL say not to use @@IDENTITY nor does it says it's dangerous under load. the other IDENTITY functions give finer/coarser control over what gets returned but to make those kinds of statements based on saying BOL said so when it doesn't, isn't in any sense of the word, correct. Fine, don't use it. The point from the post is that @@IDENTITY is not the best option. That's all... ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203210 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Last ID inserted
I didn't see where it says that using @@IDENTITY is risky though you are entirely correct that it's not the only solution. BOL points out three different tools that can be used to select the identity of the last record inserted into a table: IDENT_CURRENT returns the last identity value generated for a specific table in any session and any scope. @@IDENTITY returns the last identity value generated for any table in the current session, across all scopes. SCOPE_IDENTITY returns the last identity value generated for any table in the current session and the current scope. HTH Hatton ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203211 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: macromedia and Adobe?!
Or the Coldfusion CS WACK. Maybe that's the underlying motive here. MX is s much cooler sounding than CS. -e -Original Message- From: Kazmierczak, Kevin [mailto:[EMAIL PROTECTED] Sent: Monday, April 18, 2005 9:33 AM To: CF-Talk Subject: RE: macromedia and Adobe?! Even better Ben Forta's new book, Photoshop CS2 in 21 days Kevin. -Original Message- From: Kazmierczak, Kevin [mailto:[EMAIL PROTECTED] Sent: Monday, April 18, 2005 9:26 AM To: CF-Talk Subject: RE: macromedia and Adobe?! I predict a new tag cfpsd Oh dear. Kevin. -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Monday, April 18, 2005 9:21 AM To: CF-Talk Subject: Re: macromedia and Adobe?! Heh, I never even said hello. I think I'm going to reinstall CF Studio 4.5 just so I can have some Allaire back in my life. Ah, those were the days, back before their stock took a dump... Pete On 4/18/05, Adam Haskell [EMAIL PROTECTED] wrote: Great say goodbye to flash paper... Adam H ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203212 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Last ID inserted
I enjoy using ident_current. No problems yet. Kevin. -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Monday, April 18, 2005 9:35 AM To: CF-Talk Subject: RE: Last ID inserted From: Paul Hastings [mailto:[EMAIL PROTECTED] no, it's not correct. as far as i can see no where does BoL say not to use @@IDENTITY nor does it says it's dangerous under load. the other IDENTITY functions give finer/coarser control over what gets returned but to make those kinds of statements based on saying BOL said so when it doesn't, isn't in any sense of the word, correct. Fine, don't use it. The point from the post is that @@IDENTITY is not the best option. That's all... ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203213 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Last ID inserted
Mike Kear wrote: Michael got the extract right. True, books on line doesnt say NOT to use @@identity, but it does say it's risky if there are several inserts going on at once. again, where exactly does it say that? @@IDENTITY gives you the identity from the last insert in the database, whereever it was. Which might or might not be the one you that is an urban myth or a lack of understanding of how IDENTITY works, take your pick. but repeatedly saying that sort of thing based on the BoL as reference when it obviously isn't, doesn't make any sense to me. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203214 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Last ID inserted
Ok Paul please yourself I dont care a *^$. Life's too short to argue. You do whatever the hell you like. Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203215 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SQL Triggers (was Re: Last ID inserted)
What about triggers for audits? Adam H On 4/18/05, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Well, for one they can be hard to track / find if you are not the developer and have sufficient rights to look at them, they are also a performance drain when simple constraint should be enough. Most cases which use a trigger now are unnecessary. -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 13:27 To: CF-Talk Subject: SQL Triggers (was Re: Last ID inserted) Triggers...?! ;-) evil evil evil... Why do you say that? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203216 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: macromedia and Adobe?!
On Monday 18 Apr 2005 12:08 pm, Mark Smyth wrote: That's got to be on their hitlist, must break the MM developers hearts Unless FlashPaper becomes sort of PDF-lite for displaying PDF documents in a web browser without the hassle of loading up the full blown Acrobat. -- Tom Chiverton Advanced ColdFusion Programmer ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203217 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Last ID inserted
Mike Kear wrote: Ok Paul please yourself I dont care a *^$. Life's too short to argue. who's arguing? i was just asking you to clarify your opinions. which you aren't doing. so i guess that's the end of that. You do whatever the hell you like. well i do *like* facts to be factual. how about you? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203218 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Last ID inserted
@@IDENTITY gives you the identity from the last insert in the database hmmm, BOL says: @@IDENTITY contains the last value generated in any table in the current session Anyone know what SQL defines as a session? i.e. is it just that query? If so, then @@IDENTITY is 100% safe where I am doing single inserts per query (no triggers in DB)... -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 15:00 To: CF-Talk Subject: Re: Last ID inserted Mike Kear wrote: Michael got the extract right. True, books on line doesnt say NOT to use @@identity, but it does say it's risky if there are several inserts going on at once. again, where exactly does it say that? @@IDENTITY gives you the identity from the last insert in the database, whereever it was. Which might or might not be the one you that is an urban myth or a lack of understanding of how IDENTITY works, take your pick. but repeatedly saying that sort of thing based on the BoL as reference when it obviously isn't, doesn't make any sense to me. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203219 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: macromedia and Adobe?!
Homesite has been gone... -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, April 18, 2005 5:01 AM To: CF-Talk Subject: RE: macromedia and Adobe?! Yep, say goodbye to... Freehand, Fireworks, Homesite etc It is not a good omen for CF. -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 09:59 To: CF-Talk Subject: RE: macromedia and Adobe?! Say goodbye to Freehand then. Just as Coldfusion Studio was absorbed into Dreamweaver when Macromedia purchased Allaire, it is highly unlikely that Adobe will continue to produce both Illustrator and Freehand. We might even find Fireworks absorbed into Photoshop... -- Jay -Original Message- From: Kym Kovan [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 08:58 To: CF-Talk Subject: macromedia and Adobe?! The macromedia Home Page looks interesting.. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203220 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: macromedia and Adobe?!
More Potential...??? True, except when you look at how much pdf sucks. There's nothing worse than clicking on a link without noticing it was a link to a pdf file and then not being able to stop it from opening up that nasty program, which you've tried s hard not be forced into downloading in the first place. I really fear this type of change. --Ferg -Original Message- From: Micha Schopman [mailto:[EMAIL PROTECTED] Sent: Monday, April 18, 2005 6:45 AM To: CF-Talk Subject: RE: macromedia and Adobe?! I personally would not care much about Flash paper either. PDF has much more potential when you look at forms, security, workflow, portability, notes, and the open format. A bit harsh, but I think Macromedia should not have tried to reinvent the wheel with Flash paper while PDF was increasing their market share at a high rate. If I missed something with Flash paper, please tell. Too bad for the Flash paper team if the product gets the bin treatment, but sometimes sacrifices have to be made for improving the rest of the company. Those decisions are not easy to make, but that is where managers are for. Micha Schopman Project Manager Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203223 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Last ID inserted
I already spelled it out twice, and with the quote of Michael's (who beat me to the punch there by about 4 minutes) there are the references from the BoL. A lot of people have the wrong idea about what @@IDENTITY does, and as a result are open to risk. If you can't see that in what I wrote, I dont know how you got to where you are in this business. My absolute last on this subject. Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 4/19/05, Paul Hastings [EMAIL PROTECTED] wrote: Mike Kear wrote: Ok Paul please yourself I dont care a *^$. Life's too short to argue. who's arguing? i was just asking you to clarify your opinions. which you aren't doing. so i guess that's the end of that. You do whatever the hell you like. well i do *like* facts to be factual. how about you? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203221 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: macromedia and Adobe?!
The delays of PDF are not format related. They are software program related. It is the set of extensions in Acrobat which makes PDF look like a fat pig. The PDF format has potential, but lacks good software for mobile devices. For phones, I don't give PDF nor Flash paper any good chances on the small displays. For the Windows CE devices they have, but it would be more profitable creating a lightweight rendering device for mobile PDF than to market Flash paper as the next gen mobile device (lightweight) digital paper. And even then, I don't see people having any difficulties on the offices whatsoever with the new Acrobat and PDF. The format is used more and more, and several printer/scanner brands already introduced enterprise scanning and archiving with PDF files. Micha Schopman Project Manager Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203222 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Triggers (was Re: Last ID inserted)
Just in case my thinking has been wrong for the last few years, how are triggers a performance drain??? If I can make one query to a database and then have the db handle some of the other operations I need to run, that sounds like a pretty efficient way to handle it to me. --Ferg -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, April 18, 2005 7:54 AM To: CF-Talk Subject: RE: SQL Triggers (was Re: Last ID inserted) Well, for one they can be hard to track / find if you are not the developer and have sufficient rights to look at them, they are also a performance drain when simple constraint should be enough. Most cases which use a trigger now are unnecessary. -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 13:27 To: CF-Talk Subject: SQL Triggers (was Re: Last ID inserted) Triggers...?! ;-) evil evil evil... Why do you say that? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203224 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Last ID inserted
You enjoy using it?! Hmmm, just thinking if there's ever been a bit of code I've enjoyed using... cfpop, no... alert(), no... cfchart, hell no... o, a couple weeks back I had some fun with cfmail! :OD Sorry :OP -Original Message- From: Kazmierczak, Kevin [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 14:40 To: CF-Talk Subject: RE: Last ID inserted I enjoy using ident_current. No problems yet. Kevin. -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.16 - Release Date: 18/04/2005 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203225 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Last ID inserted
Yes, using @@Identity will send you back the LAST inserted ID in that query/stored proc... Which means, if you do 2 inserts in a stored proc and you do a Select @@Identity as RetId, RetId will be from the last insert. I just did this on SQL Server 7 and it produced this result... I can try on SQL 2000 later if I need to... On 4/18/05, Kerry [EMAIL PROTECTED] wrote: @@IDENTITY gives you the identity from the last insert in the database hmmm, BOL says: @@IDENTITY contains the last value generated in any table in the current session Anyone know what SQL defines as a session? i.e. is it just that query? If so, then @@IDENTITY is 100% safe where I am doing single inserts per query (no triggers in DB)... -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 15:00 To: CF-Talk Subject: Re: Last ID inserted Mike Kear wrote: Michael got the extract right. True, books on line doesnt say NOT to use @@identity, but it does say it's risky if there are several inserts going on at once. again, where exactly does it say that? @@IDENTITY gives you the identity from the last insert in the database, whereever it was. Which might or might not be the one you that is an urban myth or a lack of understanding of how IDENTITY works, take your pick. but repeatedly saying that sort of thing based on the BoL as reference when it obviously isn't, doesn't make any sense to me. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203226 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: macromedia and Adobe?!
It is interesting that Adobe stock is down and Macromedia stock is up as of 10:12 am. I thought this would be bad for Macromedia and good for Adobe, but apparently the stock holders don't think so. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203227 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Last ID inserted
Then there is no problem AFAIK can see from using it. -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 15:15 To: CF-Talk Subject: Re: Last ID inserted Yes, using @@Identity will send you back the LAST inserted ID in that query/stored proc... Which means, if you do 2 inserts in a stored proc and you do a Select @@Identity as RetId, RetId will be from the last insert. I just did this on SQL Server 7 and it produced this result... I can try on SQL 2000 later if I need to... On 4/18/05, Kerry [EMAIL PROTECTED] wrote: @@IDENTITY gives you the identity from the last insert in the database hmmm, BOL says: @@IDENTITY contains the last value generated in any table in the current session Anyone know what SQL defines as a session? i.e. is it just that query? If so, then @@IDENTITY is 100% safe where I am doing single inserts per query (no triggers in DB)... -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 15:00 To: CF-Talk Subject: Re: Last ID inserted Mike Kear wrote: Michael got the extract right. True, books on line doesnt say NOT to use @@identity, but it does say it's risky if there are several inserts going on at once. again, where exactly does it say that? @@IDENTITY gives you the identity from the last insert in the database, whereever it was. Which might or might not be the one you that is an urban myth or a lack of understanding of how IDENTITY works, take your pick. but repeatedly saying that sort of thing based on the BoL as reference when it obviously isn't, doesn't make any sense to me. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203228 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Last ID inserted
Mike Kear wrote: I already spelled it out twice, and with the quote of Michael's (who beat me to the punch there by about 4 minutes) there are the references from the BoL. A lot of people have the wrong idea about that was a reference about @@IDENTITY which did not in any way support your opinions. nothing risky, nothing about not using it, etc. see that in what I wrote, I dont know how you got to where you are in this business. oh my, that's kind of insulting and nothing to do w/what you've been stating as facts backed by the BoL. but as they say here, i have pretty thick face so i'm not going to get mad or remember this in a few more minutes ;-) ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203229 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: macromedia and Adobe?!
The delays of PDF are not format related. They are software program related. It is the set of extensions in Acrobat which makes PDF look like a fat pig. The PDF format has potential, but lacks good software for mobile devices. The rendering software is huge bulky and slow b/c of the PDF format. A PDF docuemnt contain nothing, but XML. This forces everything to be in the reader which cuases it to be a pig... Could the reader be re-written in a more streamline fashion and still provide all the functionality..maybe..time will tell. Adam H ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203230 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Last ID inserted
Whoah there horsey - both of your last posts were unnecessary. Paul is exactly correct - the BOL does *NOT* say or advise or warn against using any method. As you will have seen from posts over the years he is a very advanced developer who offers educated and informed technological insights (just don't get him started on Unicode) - he asked a question - as did I about where BOL mentioned this oddity, I have used SQL Server for a long time and never once see or had a behaviour where I was not to use @@. Take this case If I am running an SP which does an insert and I have a @@IDENTITY after the insert then it will ALWAYS give me the correct entry for that last run insert in that scope - i.e. the SP, not matter how many people run it at the same time. -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 15:08 To: CF-Talk Subject: Re: Last ID inserted I already spelled it out twice, and with the quote of Michael's (who beat me to the punch there by about 4 minutes) there are the references from the BoL. A lot of people have the wrong idea about what @@IDENTITY does, and as a result are open to risk. If you can't see that in what I wrote, I dont know how you got to where you are in this business. My absolute last on this subject. Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 4/19/05, Paul Hastings [EMAIL PROTECTED] wrote: Mike Kear wrote: Ok Paul please yourself I dont care a *^$. Life's too short to argue. who's arguing? i was just asking you to clarify your opinions. which you aren't doing. so i guess that's the end of that. You do whatever the hell you like. well i do *like* facts to be factual. how about you? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203231 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Triggers (was Re: Last ID inserted)
Why would you need a trigger for that other than laziness ;-) -Original Message- From: Adam Haskell [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 14:56 To: CF-Talk Subject: Re: SQL Triggers (was Re: Last ID inserted) What about triggers for audits? Adam H On 4/18/05, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Well, for one they can be hard to track / find if you are not the developer and have sufficient rights to look at them, they are also a performance drain when simple constraint should be enough. Most cases which use a trigger now are unnecessary. -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 13:27 To: CF-Talk Subject: SQL Triggers (was Re: Last ID inserted) Triggers...?! ;-) evil evil evil... Why do you say that? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203232 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SQL Triggers (was Re: Last ID inserted)
Triggers are not a performance drain, in and of themselves. If they are well written, and well managed, they can be perfectly acceptable ways of performing important tasks. The problem lies in that often times, they are NOT well written and NOT well managed. They can be pretty easily overused and abused.at which point they can become a performance drain. Just in case my thinking has been wrong for the last few years, how are triggers a performance drain??? If I can make one query to a database and then have the db handle some of the other operations I need to run, that sounds like a pretty efficient way to handle it to me. --Ferg -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, April 18, 2005 7:54 AM To: CF-Talk Subject: RE: SQL Triggers (was Re: Last ID inserted) Well, for one they can be hard to track / find if you are not the developer and have sufficient rights to look at them, they are also a performance drain when simple constraint should be enough. Most cases which use a trigger now are unnecessary. -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 13:27 To: CF-Talk Subject: SQL Triggers (was Re: Last ID inserted) Triggers...?! ;-) evil evil evil... Why do you say that? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203234 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Last ID inserted
That will work if you only need that first @@Identity... but if you need both of the inserts just returning @@Identity will not work... you will have to set it after each insert... my 2 cents... On 4/18/05, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Whoah there horsey - both of your last posts were unnecessary. Paul is exactly correct - the BOL does *NOT* say or advise or warn against using any method. As you will have seen from posts over the years he is a very advanced developer who offers educated and informed technological insights (just don't get him started on Unicode) - he asked a question - as did I about where BOL mentioned this oddity, I have used SQL Server for a long time and never once see or had a behaviour where I was not to use @@. Take this case If I am running an SP which does an insert and I have a @@IDENTITY after the insert then it will ALWAYS give me the correct entry for that last run insert in that scope - i.e. the SP, not matter how many people run it at the same time. -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 15:08 To: CF-Talk Subject: Re: Last ID inserted I already spelled it out twice, and with the quote of Michael's (who beat me to the punch there by about 4 minutes) there are the references from the BoL. A lot of people have the wrong idea about what @@IDENTITY does, and as a result are open to risk. If you can't see that in what I wrote, I dont know how you got to where you are in this business. My absolute last on this subject. Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 4/19/05, Paul Hastings [EMAIL PROTECTED] wrote: Mike Kear wrote: Ok Paul please yourself I dont care a *^$. Life's too short to argue. who's arguing? i was just asking you to clarify your opinions. which you aren't doing. so i guess that's the end of that. You do whatever the hell you like. well i do *like* facts to be factual. how about you? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203234 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Triggers (was Re: Last ID inserted)
Trust me. Triggers in the DB world are not looked on as good practive. OK, from experience, knowledge and docs... The code that is included inside an UPDATE trigger runs every time its related table is updated. In most UPDATE triggers, the code in the trigger affects only certain columns, not all of them. Because of this, it is pointless (and a waste of SQL Server resources) to run all of the code in the trigger if the column or columns you are interested in have not been updated. In other words, even if a column you are not interested in is updated, the UPDATE trigger will fire and run its code. To help reduce the unnecessary running of code in an UPDATE trigger, you can take advantage of one of two different functions: UPDATE() (available in SQL Server 2000) or COLUMNS_UPDATED() (available in SQL Server 7.0 and 2000). Either function can be used to test to see if a particular column you are interested in has changed or not. Because of this, you can write code in your trigger to only run if the column you are interested in has changed, otherwise you can prevent the code from running if the column you are interested in has not changed. This can reduce the amount of work the trigger needs to do, boosting overall performance of your database. The UPDATE() function is used to check only one column at a time. The COLUMNS_UPDATED() function can be used to check multiple columns at a time. If you must use triggers, keep em small. The amount of time that a trigger takes to run is mostly a function of the number of tables referenced in the trigger and the number of rows affected by the code inside the trigger. Because of this, always try to minimize the number of tables referenced in a trigger, and minimize the number of rows being affected. In addition, keep the code in your triggers to the very minimum to reduce overhead. This is important because triggers typically fire during INSERTs, UPDATEs, and DELETEs, all of which can be common occurrences in OLTP applications. The more code that runs in the trigger, the slower each INSERT, UPDATE, and DELETE that fires it will be. If you need to implement cascading referential integrity (such as cascading deletes) in your SQL 2000 databases, use the cascading referential integrity constraint instead of triggers to perform the cascading delete, as they are much more efficient and can boost performance. If you have an older (7.0 and older) application that you have moved to SQL Server 2000, and it used triggers to perform cascading deletes, consider removing the triggers and using cascading referential integrity instead. Don't use a trigger to enforce referential integrity if you have the option to use SQL Server's built-in referential integrity instead. Using SQL Server's built-in referential integrity is much faster than using a trigger to perform the same task. If you have a choice between using a trigger or a CHECK constraint to enforce rules or defaults within your SQL Server databases, you will generally want to choose a CHECK constraint as they are faster than using triggers when performing the same task. Try to avoid rolling back triggers because of the overhead involved. Instead of letting the trigger find a problem and rolling back a transaction, instead catch the error before it can get to the trigger (if possible based on your code). Catching an error early (before the trigger fires) consumes much fewer server resources than letting the trigger roll back. Just a few snippets. (sic/) -Original Message- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 15:13 To: CF-Talk Subject: RE: SQL Triggers (was Re: Last ID inserted) Just in case my thinking has been wrong for the last few years, how are triggers a performance drain??? If I can make one query to a database and then have the db handle some of the other operations I need to run, that sounds like a pretty efficient way to handle it to me. --Ferg -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, April 18, 2005 7:54 AM To: CF-Talk Subject: RE: SQL Triggers (was Re: Last ID inserted) Well, for one they can be hard to track / find if you are not the developer and have sufficient rights to look at them, they are also a performance drain when simple constraint should be enough. Most cases which use a trigger now are unnecessary. -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 13:27 To: CF-Talk Subject: SQL Triggers (was Re: Last ID inserted) Triggers...?! ;-) evil evil evil... Why do you say that? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message:
Re: SQL Triggers (was Re: Last ID inserted)
I think there is more to it than lazieness it seems like a natural fit...not to mention you can achieve a higher degree of polymorphism this way than you could with even CFCs. Also have slgihtly tighter transaction control...just my thoughts. As for the argument thats triggers make things hard to track down...thats a sign of bad documentation, or an incomplete understnading of a system. But thats a fact of life generally so I do somewhat agree with that :) Adam H On 4/18/05, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Why would you need a trigger for that other than laziness ;-) -Original Message- From: Adam Haskell [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 14:56 To: CF-Talk Subject: Re: SQL Triggers (was Re: Last ID inserted) What about triggers for audits? Adam H On 4/18/05, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Well, for one they can be hard to track / find if you are not the developer and have sufficient rights to look at them, they are also a performance drain when simple constraint should be enough. Most cases which use a trigger now are unnecessary. -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 13:27 To: CF-Talk Subject: SQL Triggers (was Re: Last ID inserted) Triggers...?! ;-) evil evil evil... Why do you say that? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203237 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Triggers (was Re: Last ID inserted)
OK, from experience, knowledge and docs... The code that is included inside an UPDATE trigger runs every time its related table is updated. In most UPDATE triggers, the code in the trigger affects only certain columns, not all of them. Because of this, it is pointless (and a waste of SQL Server resources) to run all of the code in the trigger if the column or columns you are interested in have not been updated. In other words, even if a column you are not interested in is updated, the UPDATE trigger will fire and run its code. To help reduce the unnecessary running of code in an UPDATE trigger, you can take advantage of one of two different functions: UPDATE() (available in SQL Server 2000) or COLUMNS_UPDATED() (available in SQL Server 7.0 and 2000). Either function can be used to test to see if a particular column you are interested in has changed or not. Because of this, you can write code in your trigger to only run if the column you are interested in has changed, otherwise you can prevent the code from running if the column you are interested in has not changed. This can reduce the amount of work the trigger needs to do, boosting overall performance of your database. The UPDATE() function is used to check only one column at a time. The COLUMNS_UPDATED() function can be used to check multiple columns at a time. If you must use triggers, keep em small. The amount of time that a trigger takes to run is mostly a function of the number of tables referenced in the trigger and the number of rows affected by the code inside the trigger. Because of this, always try to minimize the number of tables referenced in a trigger, and minimize the number of rows being affected. In addition, keep the code in your triggers to the very minimum to reduce overhead. This is important because triggers typically fire during INSERTs, UPDATEs, and DELETEs, all of which can be common occurrences in OLTP applications. The more code that runs in the trigger, the slower each INSERT, UPDATE, and DELETE that fires it will be. If you need to implement cascading referential integrity (such as cascading deletes) in your SQL 2000 databases, use the cascading referential integrity constraint instead of triggers to perform the cascading delete, as they are much more efficient and can boost performance. If you have an older (7.0 and older) application that you have moved to SQL Server 2000, and it used triggers to perform cascading deletes, consider removing the triggers and using cascading referential integrity instead. Don't use a trigger to enforce referential integrity if you have the option to use SQL Server's built-in referential integrity instead. Using SQL Server's built-in referential integrity is much faster than using a trigger to perform the same task. If you have a choice between using a trigger or a CHECK constraint to enforce rules or defaults within your SQL Server databases, you will generally want to choose a CHECK constraint as they are faster than using triggers when performing the same task. Try to avoid rolling back triggers because of the overhead involved. Instead of letting the trigger find a problem and rolling back a transaction, instead catch the error before it can get to the trigger (if possible based on your code). Catching an error early (before the trigger fires) consumes much fewer server resources than letting the trigger roll back. Just a few snippets. -Original Message- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 15:13 To: CF-Talk Subject: RE: SQL Triggers (was Re: Last ID inserted) Just in case my thinking has been wrong for the last few years, how are triggers a performance drain??? If I can make one query to a database and then have the db handle some of the other operations I need to run, that sounds like a pretty efficient way to handle it to me. --Ferg This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203238 Archives:
RE: Last ID inserted
Exactamundo Clint, Which is what I do... one insert - one @@identity grab -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 15:35 To: CF-Talk Subject: Re: Last ID inserted That will work if you only need that first @@Identity... but if you need both of the inserts just returning @@Identity will not work... you will have to set it after each insert... my 2 cents... On 4/18/05, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Whoah there horsey - both of your last posts were unnecessary. Paul is exactly correct - the BOL does *NOT* say or advise or warn against using any method. As you will have seen from posts over the years he is a very advanced developer who offers educated and informed technological insights (just don't get him started on Unicode) - he asked a question - as did I about where BOL mentioned this oddity, I have used SQL Server for a long time and never once see or had a behaviour where I was not to use @@. Take this case If I am running an SP which does an insert and I have a @@IDENTITY after the insert then it will ALWAYS give me the correct entry for that last run insert in that scope - i.e. the SP, not matter how many people run it at the same time. -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 15:08 To: CF-Talk Subject: Re: Last ID inserted I already spelled it out twice, and with the quote of Michael's (who beat me to the punch there by about 4 minutes) there are the references from the BoL. A lot of people have the wrong idea about what @@IDENTITY does, and as a result are open to risk. If you can't see that in what I wrote, I dont know how you got to where you are in this business. My absolute last on this subject. Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 4/19/05, Paul Hastings [EMAIL PROTECTED] wrote: Mike Kear wrote: Ok Paul please yourself I dont care a *^$. Life's too short to argue. who's arguing? i was just asking you to clarify your opinions. which you aren't doing. so i guess that's the end of that. You do whatever the hell you like. well i do *like* facts to be factual. how about you? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203237 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: macromedia and Adobe?!
I love itthey sue each other...then merge!!!and I finally thought MM was getting CF heading in the right direction...now what??? Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203239 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SQL Triggers (was Re: Last ID inserted)
Trust me. Triggers in the DB world are not looked on as good practive. I will second that in the DBA world Triggers are not looked upon fondly in most circumstances...they have thier use though and to blindly say they are completely useless is well blind. Triggers in the database world are like Ritalin in the real world...over valued, over used, and generally used when something else could be done; but there are some cases where it is genuinely useful and perfectly appropriate to be used. :) Adam H ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203240 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Bloomberg article
-Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Monday, April 18, 2005 9:32 AM To: CF-Talk Subject: Bloomberg article While looking at news articles about the buyout, I noticed a few interesting things in the Bloomberg news... Paragraph one of the article: April 18 (Bloomberg) -- Adobe Systems Inc., the world's largest maker of graphic-design software, agreed to buy Macromedia Inc. for about $3.4 billion to add Flash Web-design programs to its offerings. Wow.. $3.4 billion seems like a lot to pay for Flash, doesn't it? Perhaps - but it's a good deal since if I remember correctly Macromedia acquired FutureSplash (which it renamed Flash) for something like 10 million (or less). That's a pretty good mark up. ;^) So this will be the third company to own Flash... the third to own ColdFusion... the fourth to own Homesite... Jim Davis ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203241 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Triggers (was Re: Last ID inserted)
Trust me. Triggers in the DB world are not looked on as good practive. The Microsoft SQL Server world is not the DB world. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203242 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: macromedia and Adobe?!
I personally would not care much about Flash paper either. PDF has much more potential when you look at forms, security, workflow, portability, notes, and the open format. A bit harsh, but I think Macromedia should not have tried to reinvent the wheel with Flash paper while PDF was increasing their market share at a high rate. If I missed something with Flash paper, please tell. Micha...it's all about speed...Flash Paper loads WAY faster than PDFfor me that's a huge plus...especially for low bandwidth users or those with old systems. Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203243 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: macromedia and Adobe?!
The delays of PDF are not format related. They are software program related. It is the set of extensions in Acrobat which makes PDF look like a fat pig. The PDF format has potential, but lacks good software for mobile devices. Michathat may be truebut find me an end user that cares about the semantics ;-) ...they want it fast and they want it now!! Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203246 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SQL Triggers (was Re: Last ID inserted)
You know a DBA who recommends and actively promotes using triggers? I don't. Trust me. Triggers in the DB world are not looked on as good practive. The Microsoft SQL Server world is not the DB world. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203244 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: macromedia and Adobe?!
Why not? Adobe doesn't have a competitive server product? It seems good to me. Adobe has better design programs any way. I'd love to get Dreamweaver, Photoshop, Illustrator and flash bundled together instead of Fireworks, Freehand, etc. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, April 18, 2005 5:01 AM To: CF-Talk Subject: RE: macromedia and Adobe?! Yep, say goodbye to... Freehand, Fireworks, Homesite etc It is not a good omen for CF. -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 09:59 To: CF-Talk Subject: RE: macromedia and Adobe?! Say goodbye to Freehand then. Just as Coldfusion Studio was absorbed into Dreamweaver when Macromedia purchased Allaire, it is highly unlikely that Adobe will continue to produce both Illustrator and Freehand. We might even find Fireworks absorbed into Photoshop... -- Jay -Original Message- From: Kym Kovan [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 08:58 To: CF-Talk Subject: macromedia and Adobe?! The macromedia Home Page looks interesting.. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203245 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Triggers (was Re: Last ID inserted)
So, I'm talking about a web application. My concern is not whether there is a minor performance hit on the db. My concern is that the web app is lightning fast. If I can use triggers to avoid hitting the server multiple times, that's what sounds like the best idea to me. Also, why is it that I only ever hear SQL Server guys talking about this? Oracle dbas don't seem to have any problem at all with triggers being used. --Ferg -Original Message- From: Adam Haskell [mailto:[EMAIL PROTECTED] Sent: Monday, April 18, 2005 9:48 AM To: CF-Talk Subject: Re: SQL Triggers (was Re: Last ID inserted) Trust me. Triggers in the DB world are not looked on as good practive. I will second that in the DBA world Triggers are not looked upon fondly in most circumstances...they have thier use though and to blindly say they are completely useless is well blind. Triggers in the database world are like Ritalin in the real world...over valued, over used, and generally used when something else could be done; but there are some cases where it is genuinely useful and perfectly appropriate to be used. :) Adam H ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203248 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Triggers (was Re: Last ID inserted)
-Original Message- From: Robertson-Ravo, Neil (RX) [mailto:Neil.Robertson- [EMAIL PROTECTED] Sent: Monday, April 18, 2005 8:54 AM To: CF-Talk Subject: RE: SQL Triggers (was Re: Last ID inserted) Well, for one they can be hard to track / find if you are not the developer and have sufficient rights to look at them, they are also a performance drain when simple constraint should be enough. Most cases which use a trigger now are unnecessary. Sounds to me like you're not so much against triggers as for using the right tool for the job. (I've just had my career path review and been told to try and be more positive...) ;^) Jim ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203247 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
recurring dates
Does anyone have a code snippet for adding recurring dates into a database? (ie weekly, bi weekly, monthly) Thanks, -e ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203249 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Triggers (was Re: Last ID inserted)
Exactly...personally I avoid them and I go out of my way to not use them - but you are correct, if you find a need - go for it.. -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 15:56 To: CF-Talk Subject: RE: SQL Triggers (was Re: Last ID inserted) -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:Neil.Robertson- [EMAIL PROTECTED] Sent: Monday, April 18, 2005 8:54 AM To: CF-Talk Subject: RE: SQL Triggers (was Re: Last ID inserted) Well, for one they can be hard to track / find if you are not the developer and have sufficient rights to look at them, they are also a performance drain when simple constraint should be enough. Most cases which use a trigger now are unnecessary. Sounds to me like you're not so much against triggers as for using the right tool for the job. (I've just had my career path review and been told to try and be more positive...) ;^) Jim ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203250 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Last ID inserted
Is there any difference then between scope_identity() and @@Identity? Is one faster? -Original Message- From: Robertson-Ravo, Neil (RX) [ Exactamundo Clint, Which is what I do... one insert - one @@identity grab -Original Message- From: Clint Tredway That will work if you only need that first @@Identity... but if you need both of the inserts just returning @@Identity will not work... you will have to set it after each insert... my 2 cents... On 4/18/05, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Whoah there horsey - both of your last posts were unnecessary. Paul is exactly correct - the BOL does *NOT* say or advise or warn against using any method. As you will have seen from posts over the years he is a very advanced developer who offers educated and informed technological insights (just don't get him started on Unicode) - he asked a question - as did I about where BOL mentioned this oddity, I have used SQL Server for a long time and never once see or had a behaviour where I was not to use @@. Take this case If I am running an SP which does an insert and I have a @@IDENTITY after the insert then it will ALWAYS give me the correct entry for that last run insert in that scope - i.e. the SP, not matter how many people run it at the same time. -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 15:08 To: CF-Talk Subject: Re: Last ID inserted I already spelled it out twice, and with the quote of Michael's (who beat me to the punch there by about 4 minutes) there are the references from the BoL. A lot of people have the wrong idea about what @@IDENTITY does, and as a result are open to risk. If you can't see that in what I wrote, I dont know how you got to where you are in this business. My absolute last on this subject. Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 4/19/05, Paul Hastings [EMAIL PROTECTED] wrote: Mike Kear wrote: Ok Paul please yourself I dont care a *^$. Life's too short to argue. who's arguing? i was just asking you to clarify your opinions. which you aren't doing. so i guess that's the end of that. You do whatever the hell you like. well i do *like* facts to be factual. how about you? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203251 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: fyi: Adobe to aquire Macromedia
On 4/18/05, Thomas Chiverton [EMAIL PROTECTED] wrote: On Monday 18 Apr 2005 11:33 am, Dwayne Cole wrote: separate way maybe even ColdFusion. What makes you think that ? So they can focus on their core products. In this case I would suspect that Flash+PDF is going to go somewhere. Its something they specifically mentioned in the release. And if CF moved to MM -- which is a graphics-first company, what would you call Adobe? Conversely, CF has done well under MM's stewardship, I think. But I have to ask myself whether Adobe was looking to acquire a server technology company or a graphics technology company. Anyone? Anyone? Bueller? -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203252 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: macromedia and Adobe?!
On Monday 18 Apr 2005 15:52 pm, Bryan Stevenson wrote: me that's a huge plus...especially for low bandwidth users or those with old systems. or low power systems - count the number of times 'mobile' is mentioned :-) -- Tom Chiverton Advanced ColdFusion Programmer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203253 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: macromedia and Adobe?!
On Monday 18 Apr 2005 15:50 pm, Burns, John D wrote: Why not? Adobe doesn't have a competitive server product? It seems good to me. Adobe has better design programs any way. I'd love to get Dreamweaver, Photoshop, Illustrator and flash bundled together instead of Fireworks, Freehand, etc. I'd rather they were kept separate (i.e. cheap). -- Tom Chiverton Advanced ColdFusion Programmer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203254 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: macromedia and Adobe?!
I am cancelling my Wednesday afternoon Fireworks lessons and am going take piano instead. -James On 4/18/05, Thomas Chiverton [EMAIL PROTECTED] wrote: On Monday 18 Apr 2005 15:50 pm, Burns, John D wrote: Why not? Adobe doesn't have a competitive server product? It seems good to me. Adobe has better design programs any way. I'd love to get Dreamweaver, Photoshop, Illustrator and flash bundled together instead of Fireworks, Freehand, etc. I'd rather they were kept separate (i.e. cheap). -- Tom Chiverton Advanced ColdFusion Programmer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203255 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: macromedia and Adobe?!
The delays of PDF are not format related. They are software program related. And the delays are not the worse. What I hate in Accrobat is it's non conformity to windows standard key stoke. One can't use Ctrl-F to search, 3 to continue a search, etc... -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203256 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: macromedia and Adobe?!
Well, if it hits the fan, there's always BlueDragon. :o) Rey... - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, April 18, 2005 10:42 AM Subject: Re: macromedia and Adobe?! I love itthey sue each other...then merge!!!and I finally thought MM was getting CF heading in the right direction...now what??? Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203257 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Bloomberg article
Rick Root wrote: Macromedia's Flash Player, which displays moving images and sound on Web pages, is installed in more than 98 percent of Internet-connected desktop computers. By buying Macromedia, Adobe Chief Executive Bruce Chizen, 49, is reducing reliance on his flagship Acrobat software, used by graphics professionals. Aside from the ridiculous oversimplification of the flash player, no other macromedia products are mentioned in the article. I'm just hoping that this will mean the end to the awful pointless abortion of an idea that is FlashPaper. Now that Macromedia as been consumed by PDF's creators, there's no need for an Acrobat killer. K. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203258 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
