Re: MS SQL 2000 Table Structure Print out
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 the handiest things I've ever written. I built it specifically because I got sick of having to have Enterprise Manager or QA open during my projects... just to look at table metadata. BUT, here's the gotcha. It's planned for release it for sale for between $20-$30 (US) within the next month or so and it's company property so I can't just hand it out. Being a small firm we need to leverage what opportunities we can, and this is sort of patterned after WinZip, WinAmp, etc., inexpensive software widgets that improve the day. Small projects like this can keep a small company afloat, and we've got high hopes pinned on this one. Personally, I think that for what it does, $25 is a steal... it's the fastest, easiest quick-reference-copy/paste tools I've ever had. The views print just beautifully (and the colors work perfectly in grayscale), so for offline analysis or hardcopy documentation, it's the best. And you know your queries and sproc tags are going to be right because it gens them right from the tables' own metadata. Eventually I'm going to add connectors for it to deliver the same data from Oracle, MySQL, and any other relevant databases that people ask for, a customizable interface for the View Queries screen, and after Blackstone comes out I may rework it with full reports, tabbed views, and skins. I don't want to make it too fancy because one of its strong suits is its LIMITED functionality. If you're still interested, drop me an email to [EMAIL PROTECTED] and I'll add you to the distribution list we've got going for interested parties. I'm also thinking about opening a Google Group or a Yahoo Group (or maybe SmartGroups since they're built in CF...) for support and information. I will be leaving the demo up and running since I've had a positive response... I hope that it works our for all of us. You get an inexpensive but cool tool, I get to eat next week. :) Laterz, J On Tue, 1 Feb 2005 10:58:28 +1100, Mike Kear <[EMAIL PROTECTED]> wrote: > 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 Advanced ColdFusion Developer > AFP Webworks > http://afpwebworks.com > ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month > > On Mon, 31 Jan 2005 12:06:53 -0600, Andy Ousterhout > <[EMAIL PROTECTED]> wrote: > > 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 further ado, please use this URL: > > http://w2ksrv1.neo.servequake.com/dbanalyzer/index.cfm > > NO USERNAME, NO PASSWORD... (sheesh... it must be monday! ;) ) > > > > To view the demo version of the application. > > > > > > ~| 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:192508 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: MS SQL 2000 Table Structure Print out
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 Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Mon, 31 Jan 2005 12:06:53 -0600, Andy Ousterhout <[EMAIL PROTECTED]> wrote: > 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 further ado, please use this URL: > http://w2ksrv1.neo.servequake.com/dbanalyzer/index.cfm > NO USERNAME, NO PASSWORD... (sheesh... it must be monday! ;) ) > > To view the demo version of the application. > > ~| 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:192486 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: MS SQL 2000 Table Structure Print out
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 further ado, please use this URL: http://w2ksrv1.neo.servequake.com/dbanalyzer/index.cfm NO USERNAME, NO PASSWORD... (sheesh... it must be monday! ;) ) To view the demo version of the application. ~| 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:192367 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: MS SQL 2000 Table Structure Print out
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 > 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, JSESSIONID. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:192366 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: MS SQL 2000 Table Structure Print out
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 PASSWORD... (sheesh... it must be monday! ;) ) To view the demo version of the application. Yours in patience, hard work, and virtue... (hehe) J On Mon, 31 Jan 2005 10:50:16 -0600, Andy Ousterhout <[EMAIL PROTECTED]> wrote: > 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://w2ksrv1.neo.servequake.com/dbanalyzer/ > userID/pwd is admin/admin > > That SHOULD get you in, if it doesn't let me know and I'll try something > else... > > Laterz, > J > > > ~| 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:192361 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: MS SQL 2000 Table Structure Print out
> 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, JSESSIONID. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:192360 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: MS SQL 2000 Table Structure Print out
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://w2ksrv1.neo.servequake.com/dbanalyzer/ userID/pwd is admin/admin That SHOULD get you in, if it doesn't let me know and I'll try something else... Laterz, J ~| 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:192346 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: MS SQL 2000 Table Structure Print out
Hmmm... I'm using cflogin with session storage... it shouldn't. I'll post the info again... http://w2ksrv1.neo.servequake.com/dbanalyzer/ userID/pwd is admin/admin That SHOULD get you in, if it doesn't let me know and I'll try something else... Laterz, J On Mon, 31 Jan 2005 09:58:48 -0600, Andy Ousterhout <[EMAIL PROTECTED]> wrote: > 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 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 > <[EMAIL PROTECTED]> wrote: > > 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 tags, and CFSTOREDPROC/CFPROCPARAM tags for the relevant DB > > object type. > > > > I can set you up with a demo if you'd like... > > > > Let me know, > > J > > > > > > -- > Continuum Media Group LLC > Burnsville, MN 55337 > http://www.web-relevant.com > http://cfobjective.blogspot.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:192344 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: MS SQL 2000 Table Structure Print out
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 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 <[EMAIL PROTECTED]> wrote: > 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 tags, and CFSTOREDPROC/CFPROCPARAM tags for the relevant DB > object type. > > I can set you up with a demo if you'd like... > > Let me know, > J > > -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.blogspot.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:192331 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: 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. 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 <[EMAIL PROTECTED]> wrote: > 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 tags, and CFSTOREDPROC/CFPROCPARAM tags for the relevant DB > object type. > > I can set you up with a demo if you'd like... > > Let me know, > J > > -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.blogspot.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:192317 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: MS SQL 2000 Table Structure Print out
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 tags, and CFSTOREDPROC/CFPROCPARAM tags for the relevant DB object type. I can set you up with a demo if you'd like... Let me know, J On Mon, 31 Jan 2005 06:58:34 -0500, Adam Haskell <[EMAIL PROTECTED]> wrote: > 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, but personally I rather just read it table > format like it is output in query analyzer ;) Oh I also like to use > DBDesigner 4 its nice to use to print off the table info. > > Adam H > > > On Mon, 31 Jan 2005 00:49:00 -0600, Nick Baker <[EMAIL PROTECTED]> wrote: > > 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 columns of the table. It shows > > the column names, the type / size and scale (if applicable) and other > > useful information. > > > > Thanks, > > > > Nick > > > > > > ~| 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:192315 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: MS SQL 2000 Table Structure Print out
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, but personally I rather just read it table format like it is output in query analyzer ;) Oh I also like to use DBDesigner 4 its nice to use to print off the table info. Adam H On Mon, 31 Jan 2005 00:49:00 -0600, Nick Baker <[EMAIL PROTECTED]> wrote: > 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 columns of the table. It shows > the column names, the type / size and scale (if applicable) and other > useful information. > > Thanks, > > Nick > > ~| 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:192305 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: MS SQL 2000 Table Structure Print out
This is incorrect use of DESCRIBE. If you want a table struct you should use a select query which cross references the sysobjects table. This should give you what you need. select syscolumns.name,systypes.name,syscolumns.length from sysobjects inner join syscolumns on syscolumns.id = 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 Structure Print out 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 columns of the table. It shows the column names, the type / size and scale (if applicable) and other useful information. Thanks, Nick ~| 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:192304 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