OT: Printing Database Structure
I did this once before, but forgot how I did it, and can't figure out how I found the answer either. Do any of you know how I can print all the table names, columns in the tables, and data types of the columns from within MS SQL Server Mgmnt Studio? Thanks. ~Steve http://lanctr.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304264 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: Printing Database Structure
Do any of you know how I can print all the table names, columns in the tables, and data types of the columns from within MS SQL Server Mgmnt Studio? Could creating a diagram with all the tables on it help here? This can show all tables, column data and relationships. Diagrams can be printed.. Dominic On 25/04/2008, Steve Good [EMAIL PROTECTED] wrote: I did this once before, but forgot how I did it, and can't figure out how I found the answer either. Do any of you know how I can print all the table names, columns in the tables, and data types of the columns from within MS SQL Server Mgmnt Studio? Thanks. ~Steve http://lanctr.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304267 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: Printing Database Structure
Do you can try this statement: SELECT TABLE_CATALOG, TABLE_NAME,COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, NUMERIC_SCALE, IS_NULLABLE, COLUMNPROPERTY(OBJECT_ID(TABLE_NAME), COLUMN_NAME, 'IsIdentity') AS IS_AUTOINCREMENT, COLUMN_DEFAULT FROM INFORMATION_SCHEMA.COLUMNS ORDER BY 2,3 Cheers Marco Antonio On Fri, Apr 25, 2008 at 5:43 PM, Steve Good [EMAIL PROTECTED] wrote: I did this once before, but forgot how I did it, and can't figure out how I found the answer either. Do any of you know how I can print all the table names, columns in the tables, and data types of the columns from within MS SQL Server Mgmnt Studio? Thanks. ~Steve http://lanctr.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304268 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: Printing Database Structure
Diagrams can do this, but I don't have the time to sit down and arrange all the little boxes so that they fit on pages. I was able, some time ago, to make a list of my tables with their columns and the column's data types through a query (I think). Afterwards I was able to copy and paste it into excel for printing. Again, I THINK I did it this way, but who knows, I've slept since then. ~Steve http://lanctr.com/ -Original Message- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: Friday, April 25, 2008 4:02 PM To: CF-Talk Subject: Re: OT: Printing Database Structure Do any of you know how I can print all the table names, columns in the tables, and data types of the columns from within MS SQL Server Mgmnt Studio? Could creating a diagram with all the tables on it help here? This can show all tables, column data and relationships. Diagrams can be printed.. Dominic On 25/04/2008, Steve Good [EMAIL PROTECTED] wrote: I did this once before, but forgot how I did it, and can't figure out how I found the answer either. Do any of you know how I can print all the table names, columns in the tables, and data types of the columns from within MS SQL Server Mgmnt Studio? Thanks. ~Steve http://lanctr.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304269 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: Printing Database Structure
AHA! This looks familiar... I'll give it a whirl. Thanks! ~Steve http://lanctr.com/ -Original Message- From: Web Specialist [mailto:[EMAIL PROTECTED] Sent: Friday, April 25, 2008 4:13 PM To: CF-Talk Subject: Re: OT: Printing Database Structure Do you can try this statement: SELECT TABLE_CATALOG, TABLE_NAME,COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, NUMERIC_SCALE, IS_NULLABLE, COLUMNPROPERTY(OBJECT_ID(TABLE_NAME), COLUMN_NAME, 'IsIdentity') AS IS_AUTOINCREMENT, COLUMN_DEFAULT FROM INFORMATION_SCHEMA.COLUMNS ORDER BY 2,3 Cheers Marco Antonio On Fri, Apr 25, 2008 at 5:43 PM, Steve Good [EMAIL PROTECTED] wrote: I did this once before, but forgot how I did it, and can't figure out how I found the answer either. Do any of you know how I can print all the table names, columns in the tables, and data types of the columns from within MS SQL Server Mgmnt Studio? Thanks. ~Steve http://lanctr.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304270 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: OT: Printing Database Structure
Yep, that did the trick. You rock! This time I saved the query ;) ~Steve http://lanctr.com/ -Original Message- From: Web Specialist [mailto:[EMAIL PROTECTED] Sent: Friday, April 25, 2008 4:13 PM To: CF-Talk Subject: Re: OT: Printing Database Structure Do you can try this statement: SELECT TABLE_CATALOG, TABLE_NAME,COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, NUMERIC_SCALE, IS_NULLABLE, COLUMNPROPERTY(OBJECT_ID(TABLE_NAME), COLUMN_NAME, 'IsIdentity') AS IS_AUTOINCREMENT, COLUMN_DEFAULT FROM INFORMATION_SCHEMA.COLUMNS ORDER BY 2,3 Cheers Marco Antonio On Fri, Apr 25, 2008 at 5:43 PM, Steve Good [EMAIL PROTECTED] wrote: I did this once before, but forgot how I did it, and can't figure out how I found the answer either. Do any of you know how I can print all the table names, columns in the tables, and data types of the columns from within MS SQL Server Mgmnt Studio? Thanks. ~Steve http://lanctr.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304271 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: Printing Database Structure
If you're on CF8, cfdbinfo is all you need. -Original Message- From: Steve Good [mailto:[EMAIL PROTECTED] Sent: Friday, April 25, 2008 4:16 PM To: CF-Talk Subject: RE: OT: Printing Database Structure AHA! This looks familiar... I'll give it a whirl. Thanks! ~Steve http://lanctr.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304272 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: Printing Database Structure
Cool. Anyway I'll suggest you to know about DataMgr. DataMgr do this job so easy. http://datamgr.riaforge.org/ With getDatabaseTables method and looping over calling getDBTableStruct method. Cheers Marco Antonio On Fri, Apr 25, 2008 at 6:19 PM, Steve Good [EMAIL PROTECTED] wrote: Yep, that did the trick. You rock! This time I saved the query ;) ~Steve http://lanctr.com/ -Original Message- From: Web Specialist [mailto:[EMAIL PROTECTED] Sent: Friday, April 25, 2008 4:13 PM To: CF-Talk Subject: Re: OT: Printing Database Structure Do you can try this statement: SELECT TABLE_CATALOG, TABLE_NAME,COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, NUMERIC_SCALE, IS_NULLABLE, COLUMNPROPERTY(OBJECT_ID(TABLE_NAME), COLUMN_NAME, 'IsIdentity') AS IS_AUTOINCREMENT, COLUMN_DEFAULT FROM INFORMATION_SCHEMA.COLUMNS ORDER BY 2,3 Cheers Marco Antonio On Fri, Apr 25, 2008 at 5:43 PM, Steve Good [EMAIL PROTECTED] wrote: I did this once before, but forgot how I did it, and can't figure out how I found the answer either. Do any of you know how I can print all the table names, columns in the tables, and data types of the columns from within MS SQL Server Mgmnt Studio? Thanks. ~Steve http://lanctr.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304273 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: Printing Database Structure
Cool, thanks for the tip, I'll look into it. ~Steve http://lanctr.com/ -Original Message- From: Web Specialist [mailto:[EMAIL PROTECTED] Sent: Friday, April 25, 2008 4:30 PM To: CF-Talk Subject: Re: OT: Printing Database Structure Cool. Anyway I'll suggest you to know about DataMgr. DataMgr do this job so easy. http://datamgr.riaforge.org/ With getDatabaseTables method and looping over calling getDBTableStruct method. Cheers Marco Antonio On Fri, Apr 25, 2008 at 6:19 PM, Steve Good [EMAIL PROTECTED] wrote: Yep, that did the trick. You rock! This time I saved the query ;) ~Steve http://lanctr.com/ -Original Message- From: Web Specialist [mailto:[EMAIL PROTECTED] Sent: Friday, April 25, 2008 4:13 PM To: CF-Talk Subject: Re: OT: Printing Database Structure Do you can try this statement: SELECT TABLE_CATALOG, TABLE_NAME,COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, NUMERIC_SCALE, IS_NULLABLE, COLUMNPROPERTY(OBJECT_ID(TABLE_NAME), COLUMN_NAME, 'IsIdentity') AS IS_AUTOINCREMENT, COLUMN_DEFAULT FROM INFORMATION_SCHEMA.COLUMNS ORDER BY 2,3 Cheers Marco Antonio On Fri, Apr 25, 2008 at 5:43 PM, Steve Good [EMAIL PROTECTED] wrote: I did this once before, but forgot how I did it, and can't figure out how I found the answer either. Do any of you know how I can print all the table names, columns in the tables, and data types of the columns from within MS SQL Server Mgmnt Studio? Thanks. ~Steve http://lanctr.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304275 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: Printing Database Structure
In CF 8 cfset MyDSN = YourDSN cfdbinfo type=tables datasource=#MyDSN# name=tableMetaData table cfoutput query=tableMetaData cfdbinfo type=columns datasource=#MyDSN# name=ColumnMetaData table = #TABLE_NAME# tr tdstrong#TABLE_NAME#/strong/td td /td td /td td /td td /td /tr cfloop query=ColumnMetaData tr td#COLUMN_NAME#/td td#TYPE_NAME# /td td#COLUMN_SIZE#/td td#IS_PRIMARYKEY#/td td#COLUMN_DEFAULT_VALUE#/td /tr /cfloop /cfoutput /table On Fri, Apr 25, 2008 at 4:43 PM, Steve Good [EMAIL PROTECTED] wrote: I did this once before, but forgot how I did it, and can't figure out how I found the answer either. Do any of you know how I can print all the table names, columns in the tables, and data types of the columns from within MS SQL Server Mgmnt Studio? Thanks. ~Steve http://lanctr.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304277 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: Printing Database Structure
Any way to get number of rows in each table? That would be REALLY useful -Original Message- From: Gerald Guido [mailto:[EMAIL PROTECTED] Sent: Friday, April 25, 2008 2:56 PM To: CF-Talk Subject: Re: OT: Printing Database Structure In CF 8 cfset MyDSN = YourDSN cfdbinfo type=tables datasource=#MyDSN# name=tableMetaData table cfoutput query=tableMetaData cfdbinfo type=columns datasource=#MyDSN# name=ColumnMetaData table = #TABLE_NAME# tr tdstrong#TABLE_NAME#/strong/td td /td td /td td /td td /td /tr cfloop query=ColumnMetaData tr td#COLUMN_NAME#/td td#TYPE_NAME# /td td#COLUMN_SIZE#/td td#IS_PRIMARYKEY#/td td#COLUMN_DEFAULT_VALUE#/td /tr /cfloop /cfoutput /table On Fri, Apr 25, 2008 at 4:43 PM, Steve Good [EMAIL PROTECTED] wrote: I did this once before, but forgot how I did it, and can't figure out how I found the answer either. Do any of you know how I can print all the table names, columns in the tables, and data types of the columns from within MS SQL Server Mgmnt Studio? Thanks. ~Steve http://lanctr.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304278 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: Printing Database Structure
Cfdbinfo doesnt supply that You can sniff out the ID and so something like this: Select Count(#ID#) as NumberofRecords From #TABLE_NAME# Or some such. On Fri, Apr 25, 2008 at 6:11 PM, Colman, Richard [EMAIL PROTECTED] wrote: Any way to get number of rows in each table? That would be REALLY useful -Original Message- From: Gerald Guido [mailto:[EMAIL PROTECTED] Sent: Friday, April 25, 2008 2:56 PM To: CF-Talk Subject: Re: OT: Printing Database Structure In CF 8 cfset MyDSN = YourDSN cfdbinfo type=tables datasource=#MyDSN# name=tableMetaData table cfoutput query=tableMetaData cfdbinfo type=columns datasource=#MyDSN# name=ColumnMetaData table = #TABLE_NAME# tr tdstrong#TABLE_NAME#/strong/td td /td td /td td /td td /td /tr cfloop query=ColumnMetaData tr td#COLUMN_NAME#/td td#TYPE_NAME# /td td#COLUMN_SIZE#/td td#IS_PRIMARYKEY#/td td#COLUMN_DEFAULT_VALUE#/td /tr /cfloop /cfoutput /table On Fri, Apr 25, 2008 at 4:43 PM, Steve Good [EMAIL PROTECTED] wrote: I did this once before, but forgot how I did it, and can't figure out how I found the answer either. Do any of you know how I can print all the table names, columns in the tables, and data types of the columns from within MS SQL Server Mgmnt Studio? Thanks. ~Steve http://lanctr.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304279 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: Printing Database Structure
SELECT so.name as tableName ,MAX(SIX.rows) as rowCounter FROM sysobjects SO INNER JOIN sysindexes SIX ON SIX.id = OBJECT_ID(SO.name) WHERE SO.xtype = 'U' GROUP BY SO.name ORDER BY 2 DESC On Fri, Apr 25, 2008 at 7:11 PM, Colman, Richard [EMAIL PROTECTED] wrote: Any way to get number of rows in each table? That would be REALLY useful -Original Message- From: Gerald Guido [mailto:[EMAIL PROTECTED] Sent: Friday, April 25, 2008 2:56 PM To: CF-Talk Subject: Re: OT: Printing Database Structure In CF 8 cfset MyDSN = YourDSN cfdbinfo type=tables datasource=#MyDSN# name=tableMetaData table cfoutput query=tableMetaData cfdbinfo type=columns datasource=#MyDSN# name=ColumnMetaData table = #TABLE_NAME# tr tdstrong#TABLE_NAME#/strong/td td /td td /td td /td td /td /tr cfloop query=ColumnMetaData tr td#COLUMN_NAME#/td td#TYPE_NAME# /td td#COLUMN_SIZE#/td td#IS_PRIMARYKEY#/td td#COLUMN_DEFAULT_VALUE#/td /tr /cfloop /cfoutput /table On Fri, Apr 25, 2008 at 4:43 PM, Steve Good [EMAIL PROTECTED] wrote: I did this once before, but forgot how I did it, and can't figure out how I found the answer either. Do any of you know how I can print all the table names, columns in the tables, and data types of the columns from within MS SQL Server Mgmnt Studio? Thanks. ~Steve http://lanctr.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304280 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: OT: Printing Database Structure
ER/Studio auto-arranges tables quite well. But, you pay a pretty price for it. m!ke -Original Message- From: Steve Good [mailto:[EMAIL PROTECTED] Sent: Friday, April 25, 2008 4:15 PM To: CF-Talk Subject: RE: OT: Printing Database Structure Diagrams can do this, but I don't have the time to sit down and arrange all the little boxes so that they fit on pages. I was able, some time ago, to make a list of my tables with their columns and the column's data types through a query (I think). Afterwards I was able to copy and paste it into excel for printing. Again, I THINK I did it this way, but who knows, I've slept since then. ~Steve http://lanctr.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304286 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
OT: Printing issues
Okay, another off topic. I'm not one for printing out HTML documents, so I don't know if this is normal or not. This page: https://www.cfr.duke.edu/DukeFacultyandStaffSeekingFoundationFunding.cfm (I didn't make that file name, don't blame me!) When I print it (and it shows up in print preview too), a line at the bottm of the second page actually gets cut off and the rest of it prints on the third page. I don't mean some of the words, I mean the top half of each letter appears at the end of page 2, and the bottom half of each letter appears on the bottom of page 3. I thought browsers were smart enough to *NOT* do this kind of thing. It's even worse in Firefox. Firefox doesn't even have the sense to print multiple pages. It just trails off the bottom and doesn't bother printing the second or third pages. Rick ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250051 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT : Printing without the Dialog
Anyone know of a way to stop the Select Printer Dialog appearing when using the following command: I can't seem to find an API anywhere. rundll32.exe C:\WINDOWS\System32\mshtml.dll,PrintHTML %1 %2 %3 %4 ideally passing the printer will help! At least to use as default. N This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185808 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
OT: printing from web
this is sort of off topic but i hope u can help. does anyone know how to programmatically remove the header and footer from a web page when you print? thanks for your help bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: printing from web
You can use CSS to define a different style sheet for printing. Or you can create a printer friendly template that you can use as well. - Original Message - From: Jones, Becky [EMAIL PROTECTED] Date: Thursday, January 22, 2004 1:00 pm Subject: OT: printing from web this is sort of off topic but i hope u can help. does anyone know how to programmatically remove the header and footer from a web page when you print? thanks for your help bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: printing mailing labels
Hey All, I'm just putting out a call to anyone that may have some experience printing mailing labels from a web app. I know printing from the web sucks, but any suggestions would be great. Of the top of my head I would guess that creating a PDF on the fly and forcing a download of that file would produce the best printed results, but it would tend to lose control as part of a mutli-step web app process (i..e flag orders to be shippedcreate PDF and hope they print the labelsflag those orders as shipped). TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: printing mailing labels
Hey All, I'm just putting out a call to anyone that may have some experience printing mailing labels from a web app. I know printing from the web sucks, but any suggestions would be great. Of the top of my head I would guess that creating a PDF on the fly and forcing a download of that file would produce the best printed results, but it would tend to lose control as part of a mutli-step web app process (i..e flag orders to be shippedcreate PDF and hope they print the labelsflag those orders as shipped). TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: printing mailing labels
Dana, are you replying at the bottom. I've gotten a couple of empty replies today and I'm guessing that Michaels footer monster is eating your replies since they fall below the message footer. dana tierney wrote: Hey All, I'm just putting out a call to anyone that may have some experience printing mailing labels from a web app. I know printing from the web sucks, but any suggestions would be great. Of the top of my head I would guess that creating a PDF on the fly and forcing a download of that file would produce the best printed results, but it would tend to lose control as part of a mutli-step web app process (i..e flag orders to be shippedcreate PDF and hope they print the labelsflag those orders as shipped). TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
WAY OT: Printing a form field with javascript
Hi all. Sorry for the OT post. I've been searching and cannot find an answer, and I'm not a javascript guru by any stretch. I'm showing a long block of text in a textarea field. I'd like the user to be able to click a button and print only what is in that field. I'd prefer to do it without opening a new window, but if I have to I have to. Thanks a bunch. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: Printing Crystal Report from web page?
We have a number of crystal reports which get rendered to a web page. The developer that set this stuff up has left us, leaving me to fix some minor issues. For the most part, I don't have a problem working with the reports themselves. However, using a Crystal report in a web page leaves me with a few questions. The biggest of which is printing. The problem I'm seeing right now is that when we print a report (from the web page), it will occasionally print half a line on one page, and the other half on the next page. I modified the reports to leave some space in the page footer, and to reserve space for the page footer, but I still see the splitting of lines. Further digging shows that the print function is doing a javascript window.print(); - so it's printing the web page, not the report itself. Any suggestions how to deal with this issue? Thanks in advance. Shawn Grover ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
OT: Printing
Hey All, I'm just in the beginning phases of figuring out how I am going to make it hard (not bulletproof) for a user to print and image more than once. Now I'm open to how that image gets sent to the printer (as an image...in a Word fileother ideas...just not in a PDF). Requirements: Netscape or IE (version 4 and up) CF Server 5 Enterprise Currently using CFX_Image to add text to a blank image file (gif of jpeg...doesn't matter to me). My thoughts so far: I've looked at CF Comet and found a few methods of sending a Word file to the printer. That means I could drop the edited image into a Word doc and fire that to the printer. Now I suppose that if that method brings up the printer dialogue box then the user could simply up the number of copies (thoughts...comments). I was thinking of having the image (or thumbnail of it...with right clicking disabled) display in a pop-up window with a print link which would send the proper file to the client's printerclose the pop-upnavigate the main window to a new page and disable it's back button (not sure if I can disable it in IE and Netscape). That would take care of most average users. There may be folks that would try to work around it, but ultimately it's not too big of an issue if someone did. Thoughts? Comments? Cross browser crud? Links? Custom Tags? Thanks in advance Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT - printing across a network, but the output disappears
Hi everybody, I have a CF application that prints reports via a Word COM object to one of four printers located on the network. I have successfully set up all four printers on the server, from which I can print test pages and print documents created manually without problem. One of the things involved in this process is to add these printers to the system account by manipulating the registry. My problem is that the CF application can print out to only three of these printers. On the fourth, the executing page works normally, throws no errors, and the generated document appears in the printers documents queue both on the server and the machine where the printer resides. However, I don't get anything from that printer. Does anybody have any idea where this document disappears to? Thank you for all your help, Matthew Small __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Printing anchor code
All, OK, my brain is about to explode for not being able to remember a simple command from HTML 3.2, if I want to display the text "a href="..."Blah, blah, blah/a" in a browser, how do I do that. BTW: pre/pre is not it. Please help before my brain goes on permanant vacation. -Kevin -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
