RE: [KCFusion] Assigning unique ID's

2002-01-24 Thread Ramphal, Ron
Robin, No joy it just sets all values to timestamp when the query started UPDATE STImport SET uid = '#timeformat(Now(),"hh:mm:sstt")#' Other thoughts appreciated Thanks, Ron. -Original Message- From: Greenhagen, Robin [mailto:[EMAIL

RE: [KCFusion] JavaScript Question

2002-01-24 Thread Keith Purtell
Ditto! I've been using JavaScripts from irt.org for years, and they all work great. Keith Purtell, Web/Network Administrator VantageMed Operations (Kansas City) Email: [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole use of the intended re

RE: [KCFusion] JavaScript Question

2002-01-24 Thread Laire Josh
Thank you, This looks like what I needed -Original Message- From: Greenhagen, Robin [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 24, 2002 10:45 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] JavaScript Question http://www.coolnerds.com/jscript/delaycode.htm Thanks, Robin Greenh

RE: [KCFusion] JavaScript Question

2002-01-24 Thread Ryan Hartwich
Check out www.irt.org, they have a 'faq' section with hundreds of code samples for javascript. You could use the 'onload' event and have the pause built into a function __ The KCFusion.org list and website is hosted by Huma

RE: [KCFusion] JavaScript Question

2002-01-24 Thread Greenhagen, Robin
http://www.coolnerds.com/jscript/delaycode.htm Thanks, Robin Greenhagen President GSI (GreenSoft Solutions, Inc.) http://www.gsi-kc.com/ > -Original Message- > From: Laire Josh [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 24, 2002 10:41 AM > To: [EMAIL PROTECTED] > Subject: [KCF

[KCFusion] JavaScript Question

2002-01-24 Thread Laire Josh
I don't know JavaScript that well. I'm looking to have a pop-up window open 3 seconds after a page is loaded. I've found how to pop-up a window for a duration of 3 seconds...but not how to have a delayed pop-up. Any suggestions?

RE: [KCFusion] Assigning unique ID's

2002-01-24 Thread Greenhagen, Robin
Title: RE: [KCFusion] Assigning unique ID's Maybe you shouldn't use a GUID, use a timestamp of some sort (whatever VFP gives you with the finest precision).  It will still free up your "two records that look exactly alike" issue.   Just a thought. Thanks, Robin Greenhagen Preside

RE: [KCFusion] Assigning unique ID's

2002-01-24 Thread Ramphal, Ron
Robin & Ryan, I am using Visual Foxpro database for this app, don't believe I have any of the operators/functions you mentioned available thru ODBC... :( Thanks for the swift replies, Ron. -Original Message- From: Greenhagen, Robin [mailto:[EMAIL PROTECTED

RE: [KCFusion] Assigning unique ID's

2002-01-24 Thread Greenhagen, Robin
What about running a query like this in SQL Ent Mgr. UPDATE table_name SET new_guid_fld=NEWID() Now you will have a new Unique GUID on each record, and you can fix your IDENTITY/INDEX issue. Thanks, Robin Greenhagen President GSI (GreenSoft Solutions, Inc.) http://www.gsi-kc.com/

RE: [KCFusion] Assigning unique ID's

2002-01-24 Thread Ryan Hartwich
I believe you can use the Set NoCount On and Set NoCount Off commands in MS SQL to nest multiple sql commands into the same CF Query. SET NOCOUNT ON BEGIN TRAN INSERT INTO Members (UserName, CreateDate)

[KCFusion] Assigning unique ID's

2002-01-24 Thread Ramphal, Ron
Hello, Might be real simple but it eludes me at this moment... I have a table in which the app somehow managed to assign duplicate id's to different records, to fix I decided to add an extra field and propagate with a guid using CF's CreateUUID function, can anyone explain how to do the wh