-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
You'll actually need to add an order by new_id clause at the end of that
statement to consistently return a random record (otherwise you just get the
first record in the table).
SELECT TOP 1 employee_id, newid() as new_id
FROM yourtable
ORDER BY
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hey, BT.
If you're just interested in a random 5 items from a straight SELECT statement,
try:
SELECT TOP 5 item_id
FROM base_table
ORDER BY NEWID()
:)
Or, a more ANSI-SQL compliant syntax:
SELECT TOP 5 item_id, newid() as new_id
FROM
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Unfortunately, missing from the Bulletin is a roll-back procedure, and a list
of files that are replaced.
Oh well...I guess we'll have to trust the Macromedia Powers-that-be.
:)
Joe
Joseph Cruz
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Check out xp_cmdshell and the dtsrun command-line tool.
That might get you where you want to be.
:)
Joe
==
Joseph Cruz
Programmer/Analyst
Wharton Computing
3620 Locust Walk, Suite 400
Philadelphia, PA
UPDATE mytable
SET DATE1 = (SELECT DATE1
FROM mytable
WHERE REFNO = 123
ANDID = 1)
WHERE DATE1 IS NULL
That should do it for you. As long as the subquery returns only one row, this will
work.
HTH!
:)
Joe
-Original Message-
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Yes!
Check out xp_cmdshell and the dtsrun command-line executable.
:)
Joe
-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 5:29 PM
To: CF-Talk
Subject: Stored Procedure
Is it
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
There's also some great example code at www.cfcomet.com under SQL Server on how
to do it with CFOBJECT and COM. We've used it pretty extensively here since
CFEXECUTE and xp_cmdshell are highly secured processes in our environment
(anal-retentive
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, all.
By way of background, we've created an application that keeps tracks of a
user's click stream within a site.
We've run into a curious problem; when the following query is executed in Cold
Fusion Ent 4.5.1 SP2 on Win2K SP1, CF's memory
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On the second question, you could install the Data Transformation Services(part
of the SQL Client tools) on the Web Server and use it to connect the local SQL
Server with the remote. You won't be able to store and run the DTS package on
the local
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hey, all. I was wondering if it were possible to stream CF-rendered HTML,
etc., directly to a printer queue. I.e., CF does some background database
processing and HTML outputting, and we want to direct the output to a printer
instead of to a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, all.
According to Microsoft (http://www.microsoft.com/data), ODBC is in "Quick-Fix
Engineering" mode...meaning that only fixes for serious bugs are being
introduced into the standard. OLE-DB is their preferred method for accessing
SQL Server
Hey, all.
I was just wondering if there was any way to access and output the client's NT
system/user environment variables (i.e. %username% or %windir%) and have them
accessible to a CF template.
Any ideas would be greatly appreciated!
Joe
~~
,
basically, I think you're out of luck...
Regards,
Howie
- Original Message -
From: "Cruz, Joseph" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Saturday, February 24, 2001 4:01 PM
Subject: How to access client's NT system/user environment vars?
CGI.REMOTE_USER doesn't seem to be available unless the user authenticates against the
web server (in our case, IIS on Win2K).
What we were thinking of doing was bypassing that step entirely since they
authenticate to the workstation to begin with (which is where the idea of using the NT
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, all. We've got this great COM object that we use to generate dynamic
Excel
Spreadsheets (as opposed to invoking the Excel.Application Object which is
really taxing and slow). We can use it in ASP, but we'd like to use it in
some
of our Cold
Hi, all.
I believe this is fixed(Is it a feature or a bug?) in 4.5...I definitely
remember the headaches in 4.0.1 when trying to secure our servers.
:)
Joe
-Original Message-
From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 14, 2001 9:12 PM
To: CF-Talk
Hey, y'all.
Do you know if there is a "native Driver" interface between SQL Server and
ORACLE? What we're hoping to do is bypass the ODBC layer entirely between
the two DBs.
Thanks!
Joe
Joseph Cruz
Wharton Computing and Information Technology
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi!
Try using NULL instead of the blank space.
i.e.
UPDATE dbo.table
SET phone = NULL
WHERE phone = 'n/a'
:)
Hope this helps.
Joe
-Original Message-
From: Bosky, Dave [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 29, 2001 1:57
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi!
A new feature of CFERROR in Cold Fusion 4.5 allows you to use any CFML
construct in the Custom Error handler.
All you need to do is specify type="exception" in the CFERROR tag.
For example,
cferror type="exception" exception="any"
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi!
Write a batch file with the following contents:
net stop "Cold Fusion Application Server"
net start "Cold Fusion Application Server"
Schedule a job (in the Control Panel). Just for assurance's sake, use a login
that has the privileges to stop
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
It actually does work in our installation. We aren't using a Windows2000-only
network, so an authoritative Time Server is not currently configured. However,
the w32Time service is compatible with any SNTP server (we have one at the
University
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
We've had similar problems. If you have a static number of database
connections to your datasource (under the Limit Conections section of the CF
Settings for datasources), and you don't have a connection timeout, then those
connections remain open
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
What version of SQL Server?
Also, I don't think Cold Fusion would be the best tool for designing the
database, although I'm sure you can execute DDL statements through Cold Fusion.
If 7.0, try Query Analyzer (it's one of the client tools that is
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi!
Try NET TIME /SETSNTP:timeserver.domain.com
This sets a registry entry.
Check out
http://support.microsoft.com/support/kb/articles/Q223/1/84.ASP?LN=EN-USSD=gnFR
=0qry=w32timernk=1src=DHCS_MSPSS_gn_SRCHSPR=WIN2000 for more information.
:)
Joe
24 matches
Mail list logo
