Hey, what's wrong with the colors?
I designed them, but *my* desinger approved them after the fact. ;)
I'm really sorry... I can't just distribute the code. My intention was
to set Nick up with a demo... which got away from me. :) However, it's
fantastic to know that you like it... it's one of th
Jared, that's a good application! (I think my designer would take
issue with some of your colour choices but what the hey).
I would also really like to have a look at how you've done it. Any
chance of getting the code too please? Please?
Cheers
Mike Kear
Windsor, NSW, Australia
Certified
Nice. Can you email me the code off-line?
Andy
-Original Message-
From: Jared Rypka-Hauer -
OK, then...
For purposes of demonstration, I have removed the cflogin restriction
to the application. Since it's just hitting the Northwind datasource,
I'm not terribly concerned.
SO, without f
Thanks. I've got to change my site!
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Monday, January 31, 2005 11:27 AM
To: CF-Talk
Subject: RE: MS SQL 2000 Table Structure Print out
> Unfortunately, I don't think that CF/MX actually saves a
> ses
OK, then...
For purposes of demonstration, I have removed the cflogin restriction
to the application. Since it's just hitting the Northwind datasource,
I'm not terribly concerned.
SO, without further ado, please use this URL:
http://w2ksrv1.neo.servequake.com/dbanalyzer/index.cfm
NO USERNAME, NO
> Unfortunately, I don't think that CF/MX actually saves a
> session cookie, but saves a "permanent" cookie.
By default, if you're using CF session management, CF will set two
persistent cookies, CFID and CFTOKEN. If you're using J2EE session
management, CF will set a single session cookie, JSESS
Unfortunately, I don't think that CF/MX actually saves a session cookie, but
saves a "permanent" cookie. Or, perhaps I've got IE set up wrong :-)
-Original Message-
From: Jared Rypka-Hauer
Hmmm... I'm using cflogin with session storage... it shouldn't.
I'll post the info again...
http
ry 31, 2005 8:21 AM
> To: CF-Talk
> Subject: Re: MS SQL 2000 Table Structure Print out
>
> Correction, a demo of the application can be viewed here:
> http://w2ksrv1.neo.servequake.com/dbanalyzer/index.cfm
>
> This is using the SQL Server Northwind sample application.
>
Jared,
I can't log in. Does your app require cookies to be enabled?
Andy
-Original Message-
From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED]
Sent: Monday, January 31, 2005 8:21 AM
To: CF-Talk
Subject: Re: MS SQL 2000 Table Structure Print out
Correction, a demo o
Correction, a demo of the application can be viewed here:
http://w2ksrv1.neo.servequake.com/dbanalyzer/index.cfm
This is using the SQL Server Northwind sample application.
The userID/Password are admin/admin.
Have a good one.
J
On Mon, 31 Jan 2005 08:11:03 -0600, Jared Rypka-Hauer - CMG, LLC
I've written a small app that parses the SQL Server metadata stored
procedures. It will display all the relevant data for any SQL Server
table, view, or sproc, including indexes, columns and datatypes, and
sproc CREATE text.
It also generates lists of columns names in several formats,
CFARGUMENT t
DESCRIBE is an SQL Plus command, if i recall. You could easily enough
make a stored procedure to do it in MS SQL I suppose though...heck
someone may have already done it. You could just use Neil's SQL
statement he posted and put it into a cursor and output it all nifty
dandy like SQL Plus does, bu
= sysobjects.id
inner join systypes on systypes.type = syscolumns.type
where sysobjects.type = 'U'
and sysobjects.name ='yourtablename'
-Original Message-
From: Nick Baker [mailto:[EMAIL PROTECTED]
Sent: 31 January 2005 06:49
To: CF-Talk
Subject: MS SQL 2000 Table Structu
MS SQL 2000
I want to show a table structure, and tried the following
DESCRIBE Pumpparts
This only throws an error "Could not find stored procedure 'DESCRIBE'."
What am I missing? Or, am I using the wrong thing here?
DESCRIBE table_name
This command provides information about the
14 matches
Mail list logo
