Printer ESCAPE codes
Is there any way to send escape codes to the printer in HTML or CFM scripting? I need to select a paper size and tray for each page of a printout on an intranet application with IE 5.5 as the browser. Terry Troxel ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Browser Size Favorites
While this might be a little off topic I thought I would share it as we all have to see what our stuff looks like on other peoples screens. I added the following 3 javascript statements to my favorites to enable me to resize my browser IE or NS to each size to see if I need to do any formatting. For 640x480 add: javascript:void(window.resizeTo( 640 - (screen.width - screen.availWidth) + 8, 480 - (screen.height - screen.availHeight) + 8)); For 800x600 add: javascript:void(window.resizeTo( 800 - (screen.width - screen.availWidth) + 8, 600 - (screen.height - screen.availHeight) + 8)); For 1024x768 add: javascript:void(window.resizeTo(1024 - (screen.width - screen.availWidth) + 8, 768 - (screen.height - screen.availHeight) + 8)); Terry ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cftransaction and Access autonumber
I think there is more to what you stated then Jon Hall mentioned. Why not lose the autonumber field and do autonumber yourself by incrementing MAX(id) + 1 and using that as your unique id. This way your related link from the line items to the order header is something YOU created and can RECREATE at will. With an autonumber field if you ever lose any data you cannot create an accurate reproduction as the autonumber field when regenerated will fill in the gaps and there goes your relationship accurracy. I recently had a datasource that would not open in Access, but was still able to be viewed using the odbc driver. I wrote a file that exported all the fields of all the tables in the datasource and then imported them into an empty copy of the database. I was able to get it all back because my indexes were not autonumber. Just a thought to ponder, as it worked for me. - Original Message - From: Bud [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, February 17, 2001 12:26 PM Subject: Re: cftransaction and Access autonumber On 2/17/01, Jon Hall penned: Yup, that is exactly what is happening. Once you insert a new record the autonumber index gets incremented. If you delete that record as happens in case of an error with cftransaction. The next time a new record is inserted it just continues on to the next highest number. I figured that's what it must be. Thanks for the confirmation. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Crystal Reports - Active X Viewer
Ok I confess I am lost. I have been working with Crystal Reports for almost 5 years now and Cold Fusion for since version 1.5 or maybe it was 2 and until yesterday was never concerned with the active-x viewer in a web environment. Could someone post some example code, steps necessary to get this enabled on a website to allow users to view reports with that viewer, or at least lets start a discussion on that topic. The site in question is running on O'Reilly Pro on NT4 with Cold Fusion 4.01 and Seagate Crystal Reports v 7 installed on the server. I do not know anything about what options he chose when he installed Crystal. If it requires version 8 I will get him to upgrade and if it requires him to do a re-install to change anything in his Crystal configuration he will do that as well. The reason I am lost here is in all the reading I have done regarding this it seems everything is pointed towards ASP as the development language and IIS as the http server. Please help me here so I can get a good nights sleep again. Oh, I already tried the CF_CR_ACTX tag from the Allaire Tag Archive and it says it cannot load the object and I have been unable to get past that. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Crystal Reports - Active X Viewer
Ok I confess I am lost. I have been working with Crystal Reports for almost 5 years now and Cold Fusion for since version 1.5 or maybe it was 2 and until yesterday was never concerned with the active-x viewer in a web environment. Could someone post some example code, steps necessary to get this enabled on a website to allow users to view reports with that viewer, or at least lets start a discussion on that topic. The site in question is running on O'Reilly Pro on NT4 with Cold Fusion 4.01 and Seagate Crystal Reports v 7 installed on the server. I do not know anything about what options he chose when he installed Crystal. If it requires version 8 I will get him to upgrade and if it requires him to do a re-install to change anything in his Crystal configuration he will do that as well. The reason I am lost here is in all the reading I have done regarding this it seems everything is pointed towards ASP as the development language and IIS as the http server. Please help me here so I can get a good nights sleep again. Oh, I already tried the CF_CR_ACTX tag from the Allaire Tag Archive and it says it cannot load the object and I have been unable to get past that. Terry ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Dynamic Image Resizing
Try this link to CF_AUTORESIZE on Allaire's site. It does exactly what you asked and then some. http://devex.allaire.com/developer/gallery/info.cfm?ID=CA3475C6-2830-11D4-AA 9700508B94F380method=Full Terry - Original Message - From: National Camps (Alan) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, February 09, 2001 12:08 PM Subject: Dynamic Image Resizing Is there a way to dynamically resize an image other than custom CF tags? I have a site that builds a dynamic web page for each member. Image URLs are stored in the database and are called to the page. Some of the stored images are larger that I would like and I trying to get any image over 400 pixels wide to resize. Any help would be appreciated. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: how to retrieve excel data and to put into DB
How about this as a solution: Create an access datasource with an external link to an Excel spreadsheet. Then write a CF template that allows the spreadshhet to be uploaded, overwrites the existing file (one nice side of this technique is the Excel file is not locked like the Access file), and then runs a query that either appends, or updates the table accordingly. After this process is complete the Excel file is not used until the next time one is uploaded. Terry Troxel - Original Message - From: ramesh deva [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, January 13, 2001 3:23 AM Subject: how to retrieve excel data and to put into DB Hi all, How can you retrieve the excel sheet data and to put in to database.. Is there any tag avaialble,, Thanx in advace Ramesh ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFGrid, select box?
You might want to look at cf_JSgrid in the developers area of Allaire. It has everything cfgrid has and then some. - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 18, 2000 10:07 AM Subject: CFGrid, select box? Anyone know this? I don't see it in the documentation, so I suspect the answer is no... When using CFGrid, is it possible to have some cells display in the format of a HTML select box? Would be very cool Brian ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Crystal Reports Version 8
I would like someone to enlighten me a little here about Crystal Reports Version 8. I currently have version 6 and am considering upgrading to version 8, but would like to know if we can utilize the activex stuff with CF. If we can could someone post an example snippet as to how they call it and what is required on the server so I can get my providor to throw any switches as he has already upgraded to version 8, but is in the same boat as me as to what is required. Terry Troxel Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Detecting search engine robots
This is not a flame, but I think that you have triggered the 0.01% of the people who want to do what the search engines claim 1,000% of people who use interactive programming on the internet sole purpose is ie: to redirect them to a bogus page. I think that the search engine community is slowing the growth of the internet especially where interactivity is concerned and using reasons like the one above is backward thinking. I do not think a small group of search engines should control the internet with noone controlling them or their ethics. Just a thought that bothers me from time to time, when a potential client says, "Oh is this Cold Fusion going to hurt my position in the search engines?" PS, I personally don't think there is anything wrong in what you are asking Sebastian, but using it to make a point to mull over. Terry - Original Message - From: sebastian palmigiani [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 17, 2000 8:09 PM Subject: Detecting search engine robots on 10/17/00 6:19 PM, Peter Tilbrook at [EMAIL PROTECTED] wrote: Or even: cfif cgi.http_user_agent contains "MSIE" How about detecting that it's a search engine spider making the request. I want to develop a script that identifies which search engine is requesting the page and then give it a page optimized for that search engine and give the browser the regular page. Does http.user_agent identify robots? And if so what is the string that is used in http.user_agent? -- Sebastian -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Reading a file one line at a time with CFfile?
I have a text file that is 1315 characters wide, which is an exported Cobol database that I reed to go through one record/line at a time and do some mid() calls to retreive certain fields and insert them into an Access table. I am unsure how to walk thru the file line by line. I do know how to use mid() though. I could sure use some help here. Terry Troxel -- 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.
Re: Reading a file one line at a time with CFfile?
Jim, Thanks for the lightening quick reply. I totally forgot about the carraige return. I will work with your method as it sure looks sound. Thanks again Terry Troxel - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Cc: "Terry - it-werks.com" [EMAIL PROTECTED] Sent: Saturday, September 30, 2000 2:55 PM Subject: Re: Reading a file one line at a time with CFfile? With CFFILE you're only able to read the entire file into a variable. Treat the file contents as a list, using carriage returns and/or line feeds as delimiters. Because of the way CF handles lists and delimiters, the following code works regardless of whether carriage returns, line feeds or any comibination of the two were used between lines. cffile action="read" file="c:\myfile.txt" variable="x" cfloop index="line" list="#x#" delimiters="#Chr(13)##Chr(10)#" !--- do whatever you need with 'line' --- ... /cfloop Jim - Original Message - From: "Terry - it-werks.com" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, September 30, 2000 3:33 PM Subject: Reading a file one line at a time with CFfile? I have a text file that is 1315 characters wide, which is an exported Cobol database that I reed to go through one record/line at a time and do some mid() calls to retreive certain fields and insert them into an Access table. I am unsure how to walk thru the file line by line. I do know how to use mid() though. I could sure use some help here. Terry Troxel -- 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. -- 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.
handling single and double quotes in a SQL insert
This is a multi-part message in MIME format.
--=_NextPart_000_001B_01BFA156.90B36AC0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Here's my problem: I populate a listbox with a query that returns part =
descriptions from a text field in an Access database. The user selects a =
description and submits the form. I then do the following in the next =
template:
cfquery name=3D"addnew" datasource=3D"sourcename"
insert into parts(partnumber,description) =
values('#partnumber#','#description#')
/cfquery
I receive various errors ie: syntax, access, column doesn't exist or =
data mismatch error, but ONLY when the record I am truying to insert has =
single or double quotes or commas in it.
Example: "Stock Length, 14' 6", with bronze anodizing." or "Bolt, 6 1/2" =
- Stainless Steel" either of these two will cause an error, while "Bolt =
- Long Threads" will insert without a hitch.
I cannot do anything about the way the parts descriptions are added as =
it is in another application that uses that shares the database.
Any suggestions will be appreciated
Terry Troxel
--=_NextPart_000_001B_01BFA156.90B36AC0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
HTMLHEAD
META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type
META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR
STYLE/STYLE
/HEAD
BODY bgColor=3D#ff
DIVFONT size=3D2Here's my problem: I populate a listbox with a query =
that=20
returns part descriptions from a text field in an Access database. The =
user=20
selects a description and submits the form. I then do the following in =
the next=20
template:/FONT/DIV
DIVnbsp;/DIV
DIVFONT size=3D2lt;cfquery name=3D"addnew"=20
datasource=3D"sourcename"gt;BRnbsp;nbsp;nbsp; insert into=20
parts(partnumber,description)=20
values('#partnumber#','#description#')/FONT/DIV
DIVFONT size=3D2lt;/cfquerygt;/FONT/DIV
DIVnbsp;/DIV
DIVFONT size=3D2I receive various errors ie: syntax, access, column =
doesn't=20
exist or data mismatch error, but ONLY when thenbsp;record I am truying =
to=20
insert has single or double quotes or commas in it./FONT/DIV
DIVFONT size=3D2/FONTnbsp;/DIV
DIVFONT size=3D2Example:nbsp;"Stock Length, 14' 6", with bronze =
anodizing."=20
or "Bolt, 6 1/2" - Stainless Steel" either of these two will cause an =
error,=20
while "Bolt - Long Threads" will insert without a hitch./FONT/DIV
DIVnbsp;/DIV
DIVFONT size=3D2I cannot do anything about the way the parts =
descriptions are=20
added as it is in another application that uses that shares the=20
database./FONT/DIV
DIVnbsp;/DIV
DIVFONT size=3D2Any suggestions will be appreciated/FONT/DIV
DIVnbsp;FONT size=3D2Terry Troxel/FONT/DIV/BODY/HTML
--=_NextPart_000_001B_01BFA156.90B36AC0--
--
Archives: http://www.eGroups.com/list/cf-talk
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.
