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
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/
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:
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
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
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
Robin,
No joy it just sets all values to timestamp when the query started
CFQUERY NAME=AssignNewID DATASOURCE = #ODBC_DSN#
UPDATE STImport
SET uid = '#timeformat(Now(),hh:mm:sstt)#'
/CFQUERY
Other thoughts appreciated
Thanks,
Ron.
-Original
