Re: Help needed with CFCONTENT
Bruce, Rodney wrote: The problem with using application/octet-stream, is that the user doesn't get the option to save the file. I want the user to be able to save the file just not open it in the browser. The purpose is for the user to save as PowerPoint slide, to be added to presentations later. Forgot to mention that you will also need a content-disposition header. cfheader name=Content-disposition value=attachment; filename=#filename# cfcontent type=application/octet-stream file=#filename# If this doesn't work, shoot the customer for using a browser that does not adhere to the suggestions made in RFC 2616, paragraph 19.5.1, which is still the formal definition of the HTTP protocol. Jochem ~~ 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: GROUP BY gives an error?
Should have been: SELECT modelname, modeldescription, makename, year FROM MODELS WHERE rating = 'Very Compatible' GROUP BY makename, modeldescription, modelname, year -Original Message- From: Darryl Lyons [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 9:18 AM To: CF-Talk Subject: RE: GROUP BY gives an error? you need to include all of the columns in the SELECT in the GROUP BY also. e.g. SELECT modelname, modeldescription, makename, year FROM MODELS WHERE rating = 'Very Compatible' GROUP BY makename, modeldescription, modelname, year -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 9:31 AM To: CF-Talk Subject: GROUP BY gives an error? Hello cf-Talk, I have a simple query. cfquery name=best datasource=#Application.dsn# SELECT modelname, modeldescription, makename, year FROM MODELS WHERE rating = 'Very Compatible' GROUP BY makename /cfquery It keeps giving me this error:ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that does not include the specified expression 'modelname' as part of an aggregate function. What the heck am I missing here? The makename field is a lookup field in an Access database, would this have anything to do with it? So far the lookup has worked fine in queries. Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] Internet Guns For Hire (603) 356-0768 ~~ 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: cffile error
Weird, I'm getting the same error when I ran out of ram or restart the cf-server (while trying to view a .cfm file), maybe the file you are uploading is very big? try uploading a simple 10Kb TXT file, see what happens. also - try changing upload2.cfm to include only 1 task (file upload OR db insert) this way you can figure out what is maxing the server (or generating this unique error). make sure you have enough space on h:\ and that you have write/modify rights on this directory - as the best practice, I suggest again to upload a 10kb txt file to c:\cfusion or somewhere easier. Let me know, Michael. - Original Message - From: Parra, Fernando [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, July 07, 2001 1:58 AM Subject: cffile error Can anyone help me? I am trying to set an upload form and I am getting the following error: Error Occurred While Processing Request Error Diagnostic Information Request canceled or ignored by serverServer busy or unable to fulfill request. The server is unable to fulfill your request due to extremely high traffic or an unexpected internal error. Please attempt your request again (if you are repeatedly unsuccessful you should notify the site administrator). (Location Code: 26) Please inform the site administrator mailto:[EMAIL PROTECTED] that this error has occurred (be sure to include the contents of this page in your message to the administrator). Here is the code: FORM: form action=upload2.cfm method=post enctype=multipart/form-data input type=hidden name=doc_cat value= table border=0 align=center style=font-size: xx-small; font-family: Arial; font-weight: bold tr tdPlease Choose a File to Uploadbrinput type=File name=NewFile size=20/td tdName of Documentbrinput type=text name=doc_title/td /tr tr td !--- Nested table --- table border=0 style=font-size: xx-small; font-family: Arial; font-weight: bold cellpadding=0 cellspacing=0 tr tdUpload Date/td td width=40nbsp;/td !--- tdNumber of Pages/td --- /tr tr tdinput type=text name=doc_date value=mm/dd/ size=10/td tdnbsp;/td !--- tdinput type=text name=doc_pags size=5/td --- /tr /table /td tdAuthorbrinput type=text name=doc_author/td /tr tr td colspan=2Document's Descriptionbrtextarea name=doc_description cols=45 rows=5 wrap=virtual/textarea/td /tr tr tdnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;input type=Submit value=Upload File/td /tr /table /form ACTION:: :: cffile action=UPLOAD filefield=form.NewFile destination=h:\web\content nameconflict=ERROR accept=text/html !--- cffile action=UPLOAD filefield=doc_title destination=\\P2\P2Web\web\NewIM3\Content nameconflict=SKIP accept=text/html --- cfinsert datasource=im3 tablename=documents formfields=doc_title, doc_date, doc_author, doc_description, doc_cat !--- /cfif --- ** Thanks, Fernando 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: Update Statement
Not sure why you would want to do this. It wouldn't make sense in any db I've ever come across. If there should be a match between primary keys, then should there not be a value of pdfid in table2 to match the orderno you want to use to set the value in table1? Is it not also possible that it might already exist in table1? If this is part of a working system I would think a bit more about your db structure. If it's just a one off then, depends what db you are doing it in. In access you could do it like this UPDATE Table1 INNER JOIN Table2 ON Table1.pdfid = Table2.pdifd SET Table1.pdfid = [orderno]; In sql server you would need to create aview first create view doupdate as select table1.pdfid, table2.orderno from table1, table2 where table1.pdfid=table2.pdfid) Then you can do an update on it as if it was a table update doupdate set pdfid=orderno Not sure how you'd do it in Oracle -Original Message- From: David Clay [mailto:[EMAIL PROTECTED]] Sent: 09 July 2001 23:54 To: CF-Talk Subject: Update Statement Need help updating table1 PDFID value with table2 orderno value where primary key in table1 equals primary key in table2. table1 primarykey=PDFID field=country Table2 primarykey=PDFID field=orderno Any help with the SQL statement or CF code would be appreciated. Thank you Dave Clay Internet Facilitator Trus Joist, A Weyerhaeuser Business 5995 Greenwood Plaza Blvd, Suite 100 Greenwood Village, CO 80111 303.770.8506 303.770.8506 ~~ 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: [Oracle Full text search]
That's interesting, I should have asked before I said it didn't. Have you used it with CF? Since as Paul says it's the same base software then can I assume there's not much between it and the MS product. -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: 04 July 2001 14:34 To: CF-Talk Subject: Re: [Oracle Full text search] yes. intermedia it's on the oracle CD [EMAIL PROTECTED] wrote: Does Oracle have any full text search facility? I can't find any mention of it anywhere. ** The opinions expressed in this E-mail are those of the individual and not necessarily the company. This E-mail and any files transmitted with it are confidential and solely for the use of the intended recipients ** ~~ 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
CF Studio database problem
When viewing my SQL server database through CF studio on my machine (RDS: localhost), the databases listed are old ones - some have actually been deleted, new ones don't show up. I've tried refreshing the view, installing SP4.5.2, etc and still no joy. Any takers on what's wrong?? Thanks Steve Development Manager Vardus Internet Solutions (SA) Tel: (+27) 21 670 9880 Fax: (+27) 21 674 4549 Email: [EMAIL PROTECTED] Website: www.vardus.com ~~ 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
Using a text file as a datasource
Hi all I'm trying to set up a text or csv file as a datasource in the CF administrator. Each time I try to set up an ODBC datasource with the Microsoft text driver, the connection to the datasource fails. Does anybody know how to get this to work? The server is an NT box. Cheers Paul --- Any opinions expressed in this message are those of the individual and not necessarily the company. This message and any files transmitted with it are confidential and solely for the use of the intended recipient. If you are not the intended recipient or the person responsible for delivering to the intended recipient, be advised that you have received this message in error and that any use is strictly prohibited. Sapphire Technologies Ltd http://www.sapphire.net ~~ 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: URL Hacks - Solution
I tried this kind of attack on a test page hooked up to a Access Database, and could not get Access to drop the table. Does Access not recognize the Drop Table SQL command? Im also wonder what other SQL commands could be passed other than DROP that could cause damage. Im really glad this subject has come up. At 05:42 PM 7/9/2001 -0400, you wrote: I think the script is a good first attempt and seems to address the URL hack threads previously that have gone around. so programatically (SQL wise) what else might one post in the string to pickup further data???... May the SQL gods speak... ~~ 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: MSXML, XML, outputting attributes?
Thanks, Brett! That worked pefect. Carl - Original Message - From: Brett Suwyn [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, July 09, 2001 3:31 PM Subject: RE: MSXML, XML, outputting attributes? You can access them directly with XPath or the GetNamedItem method called on the node. For example (using XPath): cfscript iBookID = xmlDoc.selectSingleNode(//book/@id); /cfscript Brett Suwyn mailto:[EMAIL PROTECTED] http://forums.siteobjects.com | -Original Message- | From: Carl [mailto:[EMAIL PROTECTED]] | Sent: Monday, July 09, 2001 3:08 PM | To: CF-Talk | Subject: MSXML, XML, outputting attributes? | | | Hi, | How do I output attributes from an XML document? I have | tried using the following example on Microsofts website. | | MS EXAMPLE: | var xmlDoc = new ActiveXObject(Msxml2.DOMDocument); | var nodeBook, sIdValue; | xmlDoc.async = false; | xmlDoc.load(books.xml); | nodeBook = xmlDoc.selectSingleNode(//book); | sIdValue = nodeBook.getAttribute(id) | alert(sIdValue); | | Thanks!! | Carl | ~~ 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: Using a text file as a datasource
I'm trying to set up a text or csv file as a datasource in the CF administrator. Each time I try to set up an ODBC datasource with the Microsoft text driver, the connection to the datasource fails. Does anybody know how to get this to work? The server is an NT box. Text ODBC datasources are actually set to directories, not the file, then in the query you use; select field1, field2 from myFile.txt where myFile.txt is the name of the file I've used them before - not particularly quick, but they work Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 Websites for the real world ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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: URL Hacks - Solution
I might be wrong, but I think that Access will only allow one SQL statement per query, that's why the ; DROP TABLE attack won't work. As for other SQL commands that could cause damage - how about exec xp_cmdshell which allows you to execute DOS commands on the server? You don't need to think very much before seeing the damage THAT one could do. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: 10 July 2001 14:48 To: CF-Talk Subject: RE: URL Hacks - Solution I tried this kind of attack on a test page hooked up to a Access Database, and could not get Access to drop the table. Does Access not recognize the Drop Table SQL command? Im also wonder what other SQL commands could be passed other than DROP that could cause damage. Im really glad this subject has come up. At 05:42 PM 7/9/2001 -0400, you wrote: I think the script is a good first attempt and seems to address the URL hack threads previously that have gone around. so programatically (SQL wise) what else might one post in the string to pickup further data???... May the SQL gods speak... ~~ 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
Announcement: CF_ResendUndeliverableMail3 released
In addition to the capabilities of the V2 of this tag, V3 adds the following functionalities: - Respool undelivered mail to a list of different SMTP servers. - Move (not delete) perpetually failing mail after X days. - Admin notification of perpetually failing mail, including number of messages failed, a copy of each failed message, the name of the machine on which they failed, and the directory failed messages were moved into. - Multiple email addresses can be notified on failures. - Ability to scrub bare linefeeds off messages which have been refused by SMTP programs such as Qmail's. - Ability to eliminate zero length files from the spool (CF4.5 bug) - Two new columns on the query returned from this tag Action and Reason, which describe the action taken on the file (moved, deleted, etc) and the reason this action was taken. You can download it here: http://devex.allaire.com/developer/gallery/info.cfm?ID=05D90D06-6C6B-11D5-83 F100508B94F85A -Cameron Cameron Childress elliptIQ Inc. p.770.460.7277.232 f.770.460.0963 -- http://www.neighborware.com America's Leading Community Network Software ~~ 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: Using a text file as a datasource
Thanks chaps...spot on. -Original Message- From: Philip Arnold - ASP [SMTP:[EMAIL PROTECTED]] Sent: 10 July 2001 14:49 To: CF-Talk Subject: RE: Using a text file as a datasource I'm trying to set up a text or csv file as a datasource in the CF administrator. Each time I try to set up an ODBC datasource with the Microsoft text driver, the connection to the datasource fails. Does anybody know how to get this to work? The server is an NT box. Text ODBC datasources are actually set to directories, not the file, then in the query you use; select field1, field2 from myFile.txt where myFile.txt is the name of the file I've used them before - not particularly quick, but they work Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 Websites for the real world ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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: MSXML, XML, outputting attributes?
Just a note, try to avoid using // in xpath - its has serious performance problem potential. Its essentially saying, scan the whole DOM and look for any 'book' nodes. I don't think that this is what you want. In your real code, you are already in the Service_Availability node, so you don't need to use //Offer_ID Just use Offer_ID, as its a direct child node of the Service Availability. This will prevent the parser from starting at the top of the DOM again. Also, on my MSXML 3 SP1, if you use //Offer_ID for the xpath statement, I always get the first offer_id, which makes sense, since it matches the first one it finds in the DOM, every time. So, the bit of code would be: cfscript i=i+1; nodeOffer_Id = service.selectSingleNode(Offer_Id); Offer_Id = nodeOffer_Id.text; Offer_Code = nodeOffer_Id.getAttribute(Offer_Code); /cfscript Merging in the previous suggestion: cfscript i=i+1; nodeOffer_Id = service.selectSingleNode(Offer_Id/@Offer_Code); Offer_Code = nodeOffer_Id.text; /cfscript Carl wrote: Thanks, Brett! That worked pefect. Carl - Original Message - From: Brett Suwyn [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, July 09, 2001 3:31 PM Subject: RE: MSXML, XML, outputting attributes? You can access them directly with XPath or the GetNamedItem method called on the node. For example (using XPath): cfscript iBookID = xmlDoc.selectSingleNode(//book/@id); /cfscript Brett Suwyn mailto:[EMAIL PROTECTED] http://forums.siteobjects.com | -Original Message- | From: Carl [mailto:[EMAIL PROTECTED]] | Sent: Monday, July 09, 2001 3:08 PM | To: CF-Talk | Subject: MSXML, XML, outputting attributes? | | | Hi, | How do I output attributes from an XML document? I have | tried using the following example on Microsofts website. | | MS EXAMPLE: | var xmlDoc = new ActiveXObject(Msxml2.DOMDocument); | var nodeBook, sIdValue; | xmlDoc.async = false; | xmlDoc.load(books.xml); | nodeBook = xmlDoc.selectSingleNode(//book); | sIdValue = nodeBook.getAttribute(id) | alert(sIdValue); | | Thanks!! | Carl | ~~ 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
Temporarily disabling DB constraints
Hello, I'm using MS SQL2000 and need to replicate data from one box to another. The process is failing because of certain constraints. Is there a non-hack workaround to this issue? Thanks. ~~ 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
RESERVED/KEYWORDS
Hey Everyone, I wanted to know if there is somewhere on the web that lists reserved and keywords to prevent me from using them in my database by accidently. James ~~ 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: RESERVED/KEYWORDS
And for Access 2000 http://support.microsoft.com/support/kb/articles/q209/1/87.asp Chris -- Chris Lomvardias [EMAIL PROTECTED] Syscom, Inc. 400 E. Pratt Street, Suite 300 Baltimore, MD 21202 (410)539-3737 x1722 voice (410)539-7302 fax [EMAIL PROTECTED] (pager via email) http://www.syscom.com/ -- -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 11:01 AM To: CF-Talk Subject: RESERVED/KEYWORDS Hey Everyone, I wanted to know if there is somewhere on the web that lists reserved and keywords to prevent me from using them in my database by accidently. James ~~ 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: RESERVED/KEYWORDS
Don't think so because each poece of database software will have a different list of keywords as a keyword in one db may not be one in another. Your best bet would be to look at documentation pertaining to your database product. -- Andrew Ewings Project Manager Certified Advanced Coldfusion Developer Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: 10 July 2001 16:01 To: CF-Talk Subject: RESERVED/KEYWORDS Hey Everyone, I wanted to know if there is somewhere on the web that lists reserved and keywords to prevent me from using them in my database by accidently. James ~~ 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: RESERVED/KEYWORDS
Ben Forta SQL in 10 minutes lists them all at the back Very very usfull if you've accidently called a field date... Not sure of a web resource tho Mike -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 16:01 To: CF-Talk Subject: RESERVED/KEYWORDS Hey Everyone, I wanted to know if there is somewhere on the web that lists reserved and keywords to prevent me from using them in my database by accidently. James ~~ 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
? about CF and Sybase
I am trying to get CF to use the Sybase native drivers and whenever CF tries to verify the connection to the Sybase server it fails. here is what i have in the CF administrator in case maybe im overlooking something or im doing something wrong. Data Source Name: abc123 Description: description Server: 123.123.123.123:1234 (is that how it should be to specify a port number? or should i use a comma?) Default Database: DefaultDB the rest is pretty self explanatory...im just curious to know if i have entered in the Server correctly? thanks for any help -chris ~~ 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: RESERVED/KEYWORDS
Access Reserved words can be found at: http://support.microsoft.com/support/kb/articles/q109/3/12.asp SQL Server Reserved words can be found in the SQL Server Books Online. Chris -- Chris Lomvardias [EMAIL PROTECTED] Syscom, Inc. 400 E. Pratt Street, Suite 300 Baltimore, MD 21202 (410)539-3737 x1722 voice (410)539-7302 fax [EMAIL PROTECTED] (pager via email) http://www.syscom.com/ -- -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 11:01 AM To: CF-Talk Subject: RESERVED/KEYWORDS Hey Everyone, I wanted to know if there is somewhere on the web that lists reserved and keywords to prevent me from using them in my database by accidently. James ~~ 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: Temporarily disabling DB constraints
In enterprise manager, you can go into the table properties, find the constraint in the dropdown box and uncheck 'ENABLE CONSTRAINT FOR REPLICATION'. That works in SQL 7, I don't know about 2000 -Original Message- From: stas [mailto:[EMAIL PROTECTED]] Sent: 10 July 2001 16:00 To: CF-Talk Subject: Temporarily disabling DB constraints Hello, I'm using MS SQL2000 and need to replicate data from one box to another. The process is failing because of certain constraints. Is there a non-hack workaround to this issue? Thanks. ~~ 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
SOT: Regex?
Hi all, Sorry for this slightly off topic post - I have exceedingly stupid (and cheap) clients and need to know if this is possible. This client has created a huge site himself, incorporating gallery pages with hundreds of images, both thumnails and high quality versions. Considering everything, he hasn't done too bad a job - it looks fairly good. Except the image files are named in a variety of ways - uppercase, lowercase and mixed case - and the links to the images do not necessarily match up with the image filenames with regard to case. This is going to be deployed on a linux box, so that is obviously not going to work. Rather than cross-check each filename with the links, I am going to use a utility to rename all the image files with all lower case. That's no problem. What I am not sure about how to do is this: I want to use extended find and replace in Studio to convert everything to lower case that is inside a tag. Is this even possible? Not being a regex guru, I'm hoping it is, because manually editing links in about 500 files does not sound like my idea of a fun Wednesday afternoon, and something I'm sure the client does not want to pay for. If anyone can help, I'd really appreciate it! K. ~~ 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: MSXML, XML, outputting attributes?
So, // should probably be used once to get at the root node? What other methods are faster than using the // xpath statement? In my code I used the following effectively: cfscript nodeOffer_Id = service.selectSingleNode(Offer_Id); Offer_Code = service.selectSingleNode(Offer_Id/@Offer_Code); Offer_Code = Offer_Code.text; /cfscript Your code also worked the same. Thanks! Carl - Original Message - From: Edward Smith [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 10:43 AM Subject: Re: MSXML, XML, outputting attributes? Just a note, try to avoid using // in xpath - its has serious performance problem potential. Its essentially saying, scan the whole DOM and look for any 'book' nodes. I don't think that this is what you want. In your real code, you are already in the Service_Availability node, so you don't need to use //Offer_ID Just use Offer_ID, as its a direct child node of the Service Availability. This will prevent the parser from starting at the top of the DOM again. Also, on my MSXML 3 SP1, if you use //Offer_ID for the xpath statement, I always get the first offer_id, which makes sense, since it matches the first one it finds in the DOM, every time. So, the bit of code would be: cfscript i=i+1; nodeOffer_Id = service.selectSingleNode(Offer_Id); Offer_Id = nodeOffer_Id.text; Offer_Code = nodeOffer_Id.getAttribute(Offer_Code); /cfscript Merging in the previous suggestion: cfscript i=i+1; nodeOffer_Id = service.selectSingleNode(Offer_Id/@Offer_Code); Offer_Code = nodeOffer_Id.text; /cfscript Carl wrote: Thanks, Brett! That worked pefect. Carl - Original Message - From: Brett Suwyn [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, July 09, 2001 3:31 PM Subject: RE: MSXML, XML, outputting attributes? You can access them directly with XPath or the GetNamedItem method called on the node. For example (using XPath): cfscript iBookID = xmlDoc.selectSingleNode(//book/@id); /cfscript Brett Suwyn mailto:[EMAIL PROTECTED] http://forums.siteobjects.com | -Original Message- | From: Carl [mailto:[EMAIL PROTECTED]] | Sent: Monday, July 09, 2001 3:08 PM | To: CF-Talk | Subject: MSXML, XML, outputting attributes? | | | Hi, | How do I output attributes from an XML document? I have | tried using the following example on Microsofts website. | | MS EXAMPLE: | var xmlDoc = new ActiveXObject(Msxml2.DOMDocument); | var nodeBook, sIdValue; | xmlDoc.async = false; | xmlDoc.load(books.xml); | nodeBook = xmlDoc.selectSingleNode(//book); | sIdValue = nodeBook.getAttribute(id) | alert(sIdValue); | | Thanks!! | Carl | ~~ 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: ? about CF and Sybase
you *must* have the sybase open client installed on the machine you're connecting with if you want to use the native drivers. and you need version 11.1.0 with update 11.1.1 applied. ODBC does *not* require the sybase open client though. we connect to a remote sybase DS using ODBC. works great. -Original Message- From: Chris Alvarado [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 8:09 AM To: CF-Talk Subject: ? about CF and Sybase I am trying to get CF to use the Sybase native drivers and whenever CF tries to verify the connection to the Sybase server it fails. here is what i have in the CF administrator in case maybe im overlooking something or im doing something wrong. Data Source Name: abc123 Description: description Server: 123.123.123.123:1234 (is that how it should be to specify a port number? or should i use a comma?) Default Database: DefaultDB the rest is pretty self explanatory...im just curious to know if i have entered in the Server correctly? thanks for any help -chris ~~ 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: RESERVED/KEYWORDS
Depends on the database, since most vendors have extensions to standard SQL. For MS Access, see reserved words in the online Help index. The Oracle SQL Reference (http://helios.a.tu-berlin.de:8000/wg73-doc/server/sql73/ch201.html) lists Oracle- and ANSI-reserved words. -David On Tuesday, July 10, 2001 8:01 AM, James Taavon [SMTP:[EMAIL PROTECTED]] wrote: I wanted to know if there is somewhere on the web that lists reserved and keywords to prevent me from using them in my database by accidently. ~~ 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: cfloop and group
Bryan Love wrote: wow. First of all it looks like you've forgotten to use #innerloop# anywhere in your code. The query is hard-coded to use [1] and [2] from the second dimension of your array. Perhaps each item in the first dimension contains a sub-array of only two items (documentID and headingID). If this is the case then why are you looping over the second dimension? This would cause the exact same query to be run twice, outputting the same single record each time. If this is the case then just eliminate the inner CFLOOP and remove GROUP= from the CFOUTPUT. The innerloop was a leftover from the code in Chapter 9 of the Developing Web Applications with ColdFusion book. Where I hard coded the 1 and 2 had been where innerloop would've been. I knew that column 1 was headingids and column 2 was docids, but I needed to loop through all the pairs of ids to find and output the actual names of documents and headings. I took the innerloop and group out and got the same result was before. Secondly, putting a query inside a double nested loop is not a very good idea. CFOUTPUT was given a GROUP attribute to avoid this kind of situation; it's just a matter of learning to use it correctly. It looks like you are basically trying to print the collection of documents stored in the original array. The only reason the query is inside the loop is so I can refer to the elements inside the array in my query. I'm not trying to use cfloop to group it, just use it to retreive the ids for the array so the query can use them to get the names (and other associated information). I don't know how else to retreive the information in the array without looping. a query like this would be much more efficient: SELECT ... FROM ... WHERE document.documentid IN (...docID list...) AND headingid IN (...headingID list...) AND (join document and heading somehow here so ensure the proper records are related to each other) and document.nameno=articlenames.nameno and document.documentid=article.documentid order by headingname, articlename Then you can use the GROUP attribute in your CFOUTPUT to control the output FYI: GROUPs can be nested... cfoutput query=myQuery group=group1 cfoutput group=group2 cfoutput That last AND (join document and heading somehow here so ensure the proper records are related to each other) is the problem. I can't figure out how to do it without cfloop. The two columns of the array were originally 2 query-driven lists that I converted into an array. So I thought I'd use listgetat to synchronize the position in the lists, but that would require using a loop to go through the lists. Any ideas on how to sync the lists without looping? Thanks! Jen ~~ 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: Help needed with CFCONTENT
Jochem Thanks for your suggestions so far. I like to shoot the web browser developers, tho not the customer :o) But I think I have not explained very well, or am not understanding. I am on an NT 4.0/SP6a server, using ColdFusion 4.5.1.(hopefully to upgrade to 5.0 soon) When I add the filename, CFCONTENT is looking for the file to already exist, which it does not, the user will be creating it at the time of viewing, saving it on their drive. Maybe I am doing something else wrong. here is a simple look at the process. User is given options to create the graph from, this information is then sent to a custom tag CF_graph (I down loaded from tag gallery, uses tables to build bar graphs). on the action page I place the call to the CF_graph tag, with CFCONTENT at the top of page: !--page comments--- CFcontent type=application/vnd.ms-powerpoint CF_graph attributes=#vals# with your suggestions looks like: !---page comments cfheader name=Content-disposition value=attachment;filename=#filename# cfcontent type=application/octet-stream file=#filename# !---I also added the relocation back CFlocation url=previouspage.cfm and as I said, when user chooses to save file, this works fine a PowerPoint file is saved that can be later view in PowerPoint, but when the user chooses to open from present location, it displays fine, just errors when user moves or clicks on scroll bar. I don't need it to display here, just save as a file, if there is another way to get this graph saved as a PowerPoint slide I could use that. I also do the same for creating Excel spreadsheets and Word Docs. I have no problems with them. CFcontent type=application/msword CFcontent type=application/msexcel again thanks for your help in working through this Rodney -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Monday, July 09, 2001 11:30 PM To: CF-Talk Subject: Re: Help needed with CFCONTENT Bruce, Rodney wrote: The problem with using application/octet-stream, is that the user doesn't get the option to save the file. I want the user to be able to save the file just not open it in the browser. The purpose is for the user to save as PowerPoint slide, to be added to presentations later. Forgot to mention that you will also need a content-disposition header. cfheader name=Content-disposition value=attachment; filename=#filename# cfcontent type=application/octet-stream file=#filename# If this doesn't work, shoot the customer for using a browser that does not adhere to the suggestions made in RFC 2616, paragraph 19.5.1, which is still the formal definition of the HTTP protocol. Jochem ~~ 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: Regex?
I'd use a cfm template for this... I'm assuming you have CF running on the server where the image files are at. Do a CFDIRECTORY to get the files. Loop over the file list and to a CFSET lowername = Lcase(name) followed by cffile action=RENAME source=directory/#name# destination=#lowername# This should effectively take care of your problem. Jeff Garza Lead Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 4:54 PM To: CF-Talk Subject: SOT: Regex? Hi all, Sorry for this slightly off topic post - I have exceedingly stupid (and cheap) clients and need to know if this is possible. This client has created a huge site himself, incorporating gallery pages with hundreds of images, both thumnails and high quality versions. Considering everything, he hasn't done too bad a job - it looks fairly good. Except the image files are named in a variety of ways - uppercase, lowercase and mixed case - and the links to the images do not necessarily match up with the image filenames with regard to case. This is going to be deployed on a linux box, so that is obviously not going to work. Rather than cross-check each filename with the links, I am going to use a utility to rename all the image files with all lower case. That's no problem. What I am not sure about how to do is this: I want to use extended find and replace in Studio to convert everything to lower case that is inside a tag. Is this even possible? Not being a regex guru, I'm hoping it is, because manually editing links in about 500 files does not sound like my idea of a fun Wednesday afternoon, and something I'm sure the client does not want to pay for. If anyone can help, I'd really appreciate it! K. ~~ 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
Debug output
Is there a way to capture CFAS's debug output and format it? My problem is that if I develop a site that has a dark background, I can't see any debug information because the text is dark too. I am mainly interested in looking at SQL statements, I know you can see most other information (passed vars, etc) using many of the custom tags. Thanks ~~ 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
CFFTP
Anyone have example code for sending a file via CFFTP? Thanks! ~~ 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
Column names containing a # sign
Hi I've been given a database containing column names such as Product# and Registration# I've tried using aliases and backticks on these columns in my query to no effect - the # sign throws CF each time. Changing the column names isn't an option unfortunately. Any suggestions greatfully received. Tristram Charnley ~~ 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: Column names containing a # sign
Try doing Product## and Registration## HTH -- Original Message -- From: Tristram Charnley [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 10 Jul 2001 17:17:58 +0100 Hi I've been given a database containing column names such as Product# and Registration# I've tried using aliases and backticks on these columns in my query to no effect - the # sign throws CF each time. Changing the column names isn't an option unfortunately. Any suggestions greatfully received. Tristram Charnley ~~ 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: CFFTP
Here's a simple backup page I have to backup some files of ours daily. I use CF's Scheduler to run this every night. Richard Ramos Network Administrator Softitler Net, Inc. www.softitler.com [EMAIL PROTECTED] --- backup.cfm --- cfftp connection=sample action=open username=username password=password server=yourname.com port=23 stoponerror=yes cfftp connection=sample action=putfile localfile=DIR\you want it in remotefile=sample.file stoponerror=yes transfermode=binary cfftp connection=sample action=close --- End file --- - Original Message - From: Chad Gray [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 9:16 AM Subject: CFFTP Anyone have example code for sending a file via CFFTP? Thanks! ~~ 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: Column names containing a # sign
Two solutions: 1) Try escaping the names, as in Product##, in the CFQUERY and use a alias CFQUERY ... SELECT Product## AS ProductNum FROM whatever /CFQUERY 2) Create a view on your database server that assigns an alias to each offending column. Always access the table through the view. Craig -Original Message- From: Tristram Charnley [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 12:18 PM To: CF-Talk Subject: Column names containing a # sign Hi I've been given a database containing column names such as Product# and Registration# I've tried using aliases and backticks on these columns in my query to no effect - the # sign throws CF each time. Changing the column names isn't an option unfortunately. Any suggestions greatfully received. Tristram Charnley ~~ 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
CF-TALK
This list is acting strange... I am seeing some duplicate msgs posted. When I post, it doesn't show up (at least not after about an hour.) I didn't get any error msgs. What's up? ~~ 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: Debug output
View Source from the browser works for me. Regards, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server Join the DevCon community at www.coolfusion.com/devcon - Original Message - From: stas [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 12:26 PM Subject: Debug output Is there a way to capture CFAS's debug output and format it? My problem is that if I develop a site that has a dark background, I can't see any debug information because the text is dark too. I am mainly interested in looking at SQL statements, I know you can see most other information (passed vars, etc) using many of the custom tags. Thanks ~~ 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: Column names containing a # sign
You can always go back and smack the DB creator Not a solution, but may lower the stress level :o) but seriously, if the person that created the DB is still around, I hope someone explained to him, that you should NEVER put special chars in column names. -Original Message- From: Howarth, Craig (IBK-NY) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 9:41 AM To: CF-Talk Subject: RE: Column names containing a # sign Two solutions: 1) Try escaping the names, as in Product##, in the CFQUERY and use a alias CFQUERY ... SELECT Product## AS ProductNum FROM whatever /CFQUERY 2) Create a view on your database server that assigns an alias to each offending column. Always access the table through the view. Craig -Original Message- From: Tristram Charnley [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 12:18 PM To: CF-Talk Subject: Column names containing a # sign Hi I've been given a database containing column names such as Product# and Registration# I've tried using aliases and backticks on these columns in my query to no effect - the # sign throws CF each time. Changing the column names isn't an option unfortunately. Any suggestions greatfully received. Tristram Charnley ~~ 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: Debug output
Just change the font color as the last line in your template, like so: font color=red /body /html Be sure NOT to include a closing /font tag. The font color you set here will carry over to all the CF debug stuff at the bottom of the page. Ricq Pattay ~ [EMAIL PROTECTED] Senior Analyst/Programmer College of Veterinary Medicine University of Minnesota - Twin Cities - Original Message - From: stas [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 11:26 AM Subject: Debug output Is there a way to capture CFAS's debug output and format it? My problem is that if I develop a site that has a dark background, I can't see any debug information because the text is dark too. I am mainly interested in looking at SQL statements, I know you can see most other information (passed vars, etc) using many of the custom tags. Thanks ~~ 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: Column names containing a # sign
have you tried doubling your # ie product# = product## etc - cf should convert that to a single # before passing to db... -Original Message- From: Tristram Charnley [mailto:[EMAIL PROTECTED]] Sent: 10 July 2001 17:18 To: CF-Talk Subject: Column names containing a # sign Hi I've been given a database containing column names such as Product# and Registration# I've tried using aliases and backticks on these columns in my query to no effect - the # sign throws CF each time. Changing the column names isn't an option unfortunately. Any suggestions greatfully received. Tristram Charnley ~~ 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
Turn off double-spacing on rds xfer
Short version: Does anyone know where the setting is in CF Studio 4.5 for preventing my files (that are transfered via RDS) from being converted to double-spacing (the lines of code?) Long version? When I first loaded CF Studio 4.5 about a year ago, all was fine. But the last 4 months, when I xfer my single-spaced .cfm source code file from our development server (a Sun UNIX box) to our staging server (also a Sun UNIX box), the files end up double-spaced. I have to open the file on the staging server, remove double-spacing, and resave it to rid it of the every-other (blank) line. I thought this had to do with the OptionsSettings... and selecting File Settings where you can specify Unix file types. But mine is already set to Unix. Other teammate's CF Studio isn't behaving this way. Is a preference file corrupted or is there a logical explanation (and cure) for this problem??? - Bruce Holm - Web Programmer Lattice Semiconductor Corp. [EMAIL PROTECTED] - ~~ 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: Regex?
If you have linux, use sed. something like: cat something.cfm|sed -e \ 'y/ABCDEFGHIJKLMNOPQRSTUVWXYZ/abcdefghijklmnopqrstuvwxyz/' | \ somethingelse.cfm that will do a character by character transformation. Mike -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 4:54 PM To: CF-Talk Subject: SOT: Regex? Hi all, Sorry for this slightly off topic post - I have exceedingly stupid (and cheap) clients and need to know if this is possible. This client has created a huge site himself, incorporating gallery pages with hundreds of images, both thumnails and high quality versions. Considering everything, he hasn't done too bad a job - it looks fairly good. Except the image files are named in a variety of ways - uppercase, lowercase and mixed case - and the links to the images do not necessarily match up with the image filenames with regard to case. This is going to be deployed on a linux box, so that is obviously not going to work. Rather than cross-check each filename with the links, I am going to use a utility to rename all the image files with all lower case. That's no problem. What I am not sure about how to do is this: I want to use extended find and replace in Studio to convert everything to lower case that is inside a tag. Is this even possible? Not being a regex guru, I'm hoping it is, because manually editing links in about 500 files does not sound like my idea of a fun Wednesday afternoon, and something I'm sure the client does not want to pay for. If anyone can help, I'd really appreciate it! K. ~~ 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: Column names containing a # sign
Try replacing the single # with a double # in the column name... i.e. field#name would be field##name in your CFQuery block. -Original Message- From: Tristram Charnley [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 11:18 AM To: CF-Talk Subject: Column names containing a # sign Hi I've been given a database containing column names such as Product# and Registration# I've tried using aliases and backticks on these columns in my query to no effect - the # sign throws CF each time. Changing the column names isn't an option unfortunately. Any suggestions greatfully received. Tristram Charnley ~~ 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
Need db advice
Hey all, Need some advice here. I have an app that functions somewhat like an old library card catalog index. It allows users to input market studies with an abstract, as well as the location of the material. The customer (our marketing dept.) wants a reference number to be generated in the format of Continent/CompanySite/SequenceNumber so that when records are listed, the users can easily scan the reference numbers and see where the item is located (for example, a reference number of NA/ABH/21 would indicate that the document is located in Auburn Hills (North America). The 21 is simply the next sequence number from the Oracle DB. Okay, great. Now, when a user inputs a study they have to indicate the continent and the site. No problem. I use Nate's TwoSelectsRelated to populate the site list based on the continent selected. Buuut...if a site isn't listed in the picklist, we need to allow the user to add a new site. Okay, no problem. Buuut...here's the problem--our company has acronyms for each site, all over the world. So Auburn Hills might be ABH, Windsor might be WDR, etc. Because the reference numbers need to include the acronyms, those obviously need to be stored in the database. But, if we allow users to add their own locations, we run into the problem of users either A) using the wrong location acronym, or B) typing duplicate site names into the db. It would be nice if there was one central place where I could find all of the correct acronyms, but unfortunately, they aren't always standard. I thought of using just a numbering schema, but this does not prevent one person from adding location Auburn Hills and another from adding Aubern Hils. I'm a little stuck. Can anyone bring their winch and tow me out? Thanks! Terri ~~ 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
A page call in any IMG tag???
Hi all, I was looking at an email the other day and there was a .jsp page url in the src attribute of an image tag. example: img src=www.domain.com/thispage.jsp?param1=yesparam2=yes I figure that this is how they track if someone read the email, and would like to do something similar. Has anyone ever heard of, or done this? Or if anyone has any ideas on how to track if an email gets viewed, any info would be appreciated. btw I plan on calling a cfm page not jsp ;) Thanks for any info on the subject, Jeff ~~ 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
OT - Allaire website
Is anyone else getting *very* slow searches on the Dev-Exchange site? I've been doing searches for the last few days and routinely get results that take 2 to 3 minutes to return -- Zac Belado Application Developer Bayleaf Software #300 948 Homer Street, Vancouver, BC, V6B 2W7 Ph: 604.683.1288 x 116 ~~ 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: OT - Allaire website
Yes .. I was complaining about that just a few minutes ago. Moving between most of the pages in the devex section are slow .. not just the search. Todd - Original Message - From: Zac Belado [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 1:51 PM Subject: OT - Allaire website | Is anyone else getting *very* slow searches on the Dev-Exchange site? | | I've been doing searches for the last few days and routinely get results | that take 2 to 3 minutes to return | | | -- | | Zac Belado | Application Developer | | Bayleaf Software | #300 948 Homer Street, | Vancouver, BC, | V6B 2W7 | Ph: 604.683.1288 x 116 | | | ~~ 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: OT - Allaire website
Its been like that for a while. Rich -Original Message- From: Zac Belado [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 1:51 PM To: CF-Talk Subject: OT - Allaire website Is anyone else getting *very* slow searches on the Dev-Exchange site? I've been doing searches for the last few days and routinely get results that take 2 to 3 minutes to return -- Zac Belado Application Developer Bayleaf Software #300 948 Homer Street, Vancouver, BC, V6B 2W7 Ph: 604.683.1288 x 116 ~~ 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: CF-TALK
This msg showed up right away...my earlier post finally showed up, nearly 2 hrs after posting it. Strange... - Original Message - From: Bruce Holm [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 10:26 AM Subject: CF-TALK This list is acting strange... I am seeing some duplicate msgs posted. When I post, it doesn't show up (at least not after about an hour.) I didn't get any error msgs. What's up? ~~ 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: Turn off double-spacing on rds xfer
F8 - File Settings - Check Format When Saving = Unix HTH, Jeff Garza Lead Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Bruce Holm [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 8:53 AM To: CF-Talk Subject: Turn off double-spacing on rds xfer Short version: Does anyone know where the setting is in CF Studio 4.5 for preventing my files (that are transfered via RDS) from being converted to double-spacing (the lines of code?) Long version? When I first loaded CF Studio 4.5 about a year ago, all was fine. But the last 4 months, when I xfer my single-spaced .cfm source code file from our development server (a Sun UNIX box) to our staging server (also a Sun UNIX box), the files end up double-spaced. I have to open the file on the staging server, remove double-spacing, and resave it to rid it of the every-other (blank) line. I thought this had to do with the OptionsSettings... and selecting File Settings where you can specify Unix file types. But mine is already set to Unix. Other teammate's CF Studio isn't behaving this way. Is a preference file corrupted or is there a logical explanation (and cure) for this problem??? - Bruce Holm - Web Programmer Lattice Semiconductor Corp. [EMAIL PROTECTED] - ~~ 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: Debug output
Try putting font color=white after your /html at the end of your pages. Better yet, you could put it in onrequestend.cfm, then you wouldn't have to modify all your pages. Justin Hansen - [EMAIL PROTECTED] Web Application Developer Interactive Business Solutions, Inc 816-221-5200 ext. 1305 -Original Message- From: stas [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 11:26 AM To: CF-Talk Subject: Debug output Is there a way to capture CFAS's debug output and format it? My problem is that if I develop a site that has a dark background, I can't see any debug information because the text is dark too. I am mainly interested in looking at SQL statements, I know you can see most other information (passed vars, etc) using many of the custom tags. Thanks ~~ 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: OT - Allaire website
Can't say I've had that happen. Most of my Dev-Exchange searches take less than 20 seconds.. tops. Lee Fuller Chief Technical Officer PrimeDNA Corporation / AAA Web Hosting Corporation We ARE the net. http://www.aaawebhosting.com -Original Message- From: Zac Belado [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 10:51 AM To: CF-Talk Subject: OT - Allaire website Is anyone else getting *very* slow searches on the Dev-Exchange site? I've been doing searches for the last few days and routinely get results that take 2 to 3 minutes to return -- Zac Belado Application Developer Bayleaf Software #300 948 Homer Street, Vancouver, BC, V6B 2W7 Ph: 604.683.1288 x 116 ~~ 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
ONCR Cybercash
Howdy All Has anyone experienced any problems installing the ONCR-CyberCash tag in CF5? I'm getting errors in the install routine. I've tried contacting ONCR for SEVERAL days now, and I've been unable to reach anyone. Needless to say, I'm a bit miffed by their less-than-prompt response to my various forms of support request. Thanks! Todd A Dancer [EMAIL PROTECTED] http://www.turbosquid.com 504.468.7827 ~~ 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: Column names containing a # sign
I already tried double ## signs and aliasing - it doesn't work. I get the very strange error: Syntax error in date in query expression. There's no date type field anywhere in the table Tristram Charnley ~~ 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
QuerySetCell on CF 5
Have any of you had prolems with the QuerySetCell() function on CF Server 5. I just upgraded to CF 5EE this morning, and I am having problems on pages that use this function. Here is the error: snip Unhandled System exception ! The error occurred while processing an element with a general identifier of (CFSET), occupying document position (51:4) to (51:135) /snip Any help would be greatly appreciated! -- scott van vliet -- senior web engingeer juxt interactive 9497525898202 [EMAIL PROTECTED] www.juxtinteractive.com In uniqueness is the preservation of mankind... - Greg Graffin ~~ 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
Verity exclude sub-directories?
I'm working with Verity and have a questionis there a way to exclude certain sub-directories from being indexed in the collection? I have a few 'procedure' directories that I don't want coming up in the user search. Thanks for your help! Deborah ~~ 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
Verity exclude sub-directories?
I'm working with Verity and have a questionis there a way to exclude certain sub-directories from being indexed in the collection? I have a few 'procedure' directories that I don't want coming up in the user search. Thanks for your help! Deborah ~~ 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: Column names containing a # sign
Sometimes it takes forever for my e-mails to show up on cf-talk so Im forwarding this to you directly. Casey Cook -- Forwarded by Casey C Cook/TMG/CSC on 07/10/2001 02:23 PM --- Casey C Cook/TMG/CSC 07/10/2001 02:22 PM To: [EMAIL PROTECTED] cc: Subject: RE: Column names containing a # sign (Document link: Casey C Cook) Try: select [product#], [item#] from whatever Casey Cook Tristram Charnley [EMAIL PROTECTED] on 07/10/2001 02:09:08 PM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc: Subject: RE: Column names containing a # sign I already tried double ## signs and aliasing - it doesn't work. I get the very strange error: Syntax error in date in query expression. There's no date type field anywhere in the table Tristram Charnley ~~ 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
OT: HTML Question with Netscape 4 and 6
Can someone please tell me why these pages completely mess up in Netscape 4 and 6 besides the obvious fact that they are the most horrid browsers on the face of the earth. http://209.215.124.4/community/index.cfm If you have any problems on here let me know, I have a firewall on this machine. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire ~~ 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: Column names containing a # sign
Try: select [product#], [item#] from whatever Casey Cook Tristram Charnley [EMAIL PROTECTED] on 07/10/2001 02:09:08 PM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc: Subject: RE: Column names containing a # sign I already tried double ## signs and aliasing - it doesn't work. I get the very strange error: Syntax error in date in query expression. There's no date type field anywhere in the table Tristram Charnley ~~ 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: Column names containing a # sign
Try calling the # with its respectebly chr(num) I don't know which asacii code is # but try this (although it may sounds silly): (let's say the 19 ASCII code is #)... UPDATE Registration#chr(19)# SET . bla bla bla It might help because I've seen cases where the char itself and the chr(ASCII_char_num) performed diffrently. Michael. - Original Message - From: Daniel Lancelot [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 9:31 PM Subject: RE: Column names containing a # sign have you tried doubling your # ie product# = product## etc - cf should convert that to a single # before passing to db... -Original Message- From: Tristram Charnley [mailto:[EMAIL PROTECTED]] Sent: 10 July 2001 17:18 To: CF-Talk Subject: Column names containing a # sign Hi I've been given a database containing column names such as Product# and Registration# I've tried using aliases and backticks on these columns in my query to no effect - the # sign throws CF each time. Changing the column names isn't an option unfortunately. Any suggestions greatfully received. Tristram Charnley ~~ 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
dbtype=dynamic
Has anyone tried to connect to a database thru the new connection string method? I've successfully connected with ODBC DSNless connection strings, but when I try an OLE DB connection string, the cfquery fails. Does it work only with DSNLess connections? tom ~~ 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
file uploads without using CFFILE
If hosted at an outside hosting provider, and that provider has CFFILE turned off, what other alternatives are there for uploading files from the client to the server. CFFTP won't work because it's expected to work via FTP server to server. This is for CF 4.5. Is there perhaps a free COM object that could be accessed via CF to profide this functionality? I found a free one, but all the examples give ASP code, and relies on the REQUEST and FORM collections available in ASP. Ideas? Suggestions? ~~ 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: Column names containing a # sign
try CFQUERY name=test datasource=source SELECT tblone.[colum##] as colum from tblone; CFQUERY CFOUTPUT query=test #test.colum# /CFOUTPUT seems to work -Original Message- From: Tristram Charnley [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 12:09 PM To: CF-Talk Subject: RE: Column names containing a # sign I already tried double ## signs and aliasing - it doesn't work. I get the very strange error: Syntax error in date in query expression. There's no date type field anywhere in the table Tristram Charnley ~~ 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: Verity exclude sub-directories?
I did see a pathindex tag at CFHacker.com http://www.cfhacker.com/ I'm working with Verity and have a questionis there a way to exclude certain sub-directories from being indexed in the collection? I have a few 'procedure' directories that I don't want coming up in the user search. Thanks for your help! Deborah ~~ 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: A page call in any IMG tag???
I just want to give DJ a big thanks, this really helped alot! Oh and he ment to say CFContent not CFObject :) Jeff -Original Message- From: DJ Riebesell [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 11:18 AM To: '[EMAIL PROTECTED]' Subject: RE: A page call in any IMG tag??? Yep, just use a CFOBJECT on that page and send it back with a mime type of a JPG or GIF. -Original Message- From: Jeff Green [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 12:37 PM To: CF-Talk Subject: A page call in any IMG tag??? Hi all, I was looking at an email the other day and there was a .jsp page url in the src attribute of an image tag. example: img src=www.domain.com/thispage.jsp?param1=yesparam2=yes I figure that this is how they track if someone read the email, and would like to do something similar. Has anyone ever heard of, or done this? Or if anyone has any ideas on how to track if an email gets viewed, any info would be appreciated. btw I plan on calling a cfm page not jsp ;) Thanks for any info on the subject, Jeff ~~ 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: Column names containing a # sign
So much for directly to Tristram. Anyways try the below and then just alias them as another name to reference in your CF code select [product#] as productnumber, [item#] as itemnumber from whatever cfoutput #productnumber# #itemnumber# /cfoutput CC Casey C Cook/TMG/CSC@CSC on 07/10/2001 02:26:59 PM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc: Subject: RE: Column names containing a # sign Sometimes it takes forever for my e-mails to show up on cf-talk so Im forwarding this to you directly. Casey Cook -- Forwarded by Casey C Cook/TMG/CSC on 07/10/2001 02:23 PM --- Casey C Cook/TMG/CSC 07/10/2001 02:22 PM To: [EMAIL PROTECTED] cc: Subject: RE: Column names containing a # sign (Document link: Casey C Cook) Try: select [product#], [item#] from whatever Casey Cook Tristram Charnley [EMAIL PROTECTED] on 07/10/2001 02:09:08 PM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc: Subject: RE: Column names containing a # sign I already tried double ## signs and aliasing - it doesn't work. I get the very strange error: Syntax error in date in query expression. There's no date type field anywhere in the table Tristram Charnley ~~ 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
SOT: Form builder software
Hi all, I need to find a better solution than html forms to meet my clients needs. My client has a bunch of paper forms and documents that he wants to use online. I've tried creating these in html but the lack of formatting and print control is causing some problems. Not to mention the huge amount of time it's taking. Does anybody know of a better way to create these forms online. I need them to be able to except input from a database to populate the fields in the form and to be manually updateable online. I found one product that may work, it's called Liquid Forms and converts the forms to editable pdf versions. Any other solutions out there you guys can recommend? Thanks, Rick ~~ 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
Problem calling Oracle stored procedures (PL/SQL functions) by using CFSTOREDPROC
Hello folks, I'm trying to call an Oracle stored procedure (a PL/SQL function) from ColdFusion using CFSTOREDPROC and have been unable to do so. When I call the function, I get the following error: Oracle Error Code = 6550 ORA-06550: line 1, column 7: PLS-00221: 'FSELECTSTATE' is not a procedure or is undefined ORA-06550: line 1, column 7: PL/SQL: Statement ignored SQL = TestBed.fSelectState I have created a procedure similar to the function, saving that it does not return a value to the caller. Using that procedure with CFSTOREDPROC succeeds. Questions: 1) Does ColdFusion not support accessing Oracle stored *functions* using CFSTOREDPROC, only *procedures*? (I normally think of PL/SQL functions as a subset of Oracle stored procedures, which is why I'm asking about the distinction.) If it does, does anyone have any suggestions as to what I might be doing incorrectly? If it does not, then on to question #2: 2) I know that I can access Oracle stored functions using CFQUERY (because I've done it before), when they (a) take one argument and (b) return a value. However, the function in question returns a reference cursor as well as a function value, so does anyone have an idea as to the syntax required to access a reference cursor returned by a function using the CFQUERY tag, if it can be done at all (my own attempts having miserably failed)? I've appended the package spec code that I'm using as well as the CFSTOREDPROC statements for them below. The system we're using for ColdFusion is an NT 4.0 Server running CF 4.5.1 SP2, with the native Oracle 8i driver. Thanks again in advance, and Regards, Joel Parramore P.S. --- In the ColdFusion 4.0 Web Application Construction Kit, by Ben Forta, he states (page 474 of the third edition) that Oracle stored functions are not supported by the CFSTOREDPROC tag. He also states that you can't use the CFPROCRESULT tag with Oracle, either, However, I know that you can use CFPROCRESULT in CF 4.5 and above, so, presumably, these are limitations of 4.0. If someone from Allaire/Macromedia would care to clarify the situation vis-a-vis CFSTOREDPROC and Oracle stored functions, that'd be great. = PL/SQL spec code: CREATE OR REPLACE PACKAGE TestBed AS TYPE GenericCursorType IS REF CURSOR; PROCEDURE SelectStates (inStateAbbrev IN VARCHAR2, qSelectStatesList OUT GenericCursorType); PROCEDURE SelectState (inStateAbbrev IN VARCHAR2, outStateName OUT VARCHAR2); FUNCTION fSelectState (inStateAbbrev IN VARCHAR2, outStateName OUT VARCHAR2) RETURN VARCHAR2; FUNCTION fSelectStates (inStateAbbrev IN VARCHAR2, qSelectStatesList OUT GenericCursorType) RETURN VARCHAR2; END TestBed; / Example 1: No reference cursor returned !--- Select Abreviations, States --- CFSET StateAbbrev = FL *** SUCCEEDS *** CFSTOREDPROC PROCEDURE=TestBed.SelectState DATASOURCE=HomesCom RETURNCODE=No CFPROCPARAM TYPE=In CFSQLTYPE=CF_SQL_VARCHAR DBVARNAME=inStateAbbrev VALUE=#StateAbbrev# NULL=No CFPROCPARAM TYPE=Out CFSQLTYPE=CF_SQL_VARCHAR DBVARNAME=outStateName VARIABLE=CF_StateName NULL=No /CFSTOREDPROC *** FAILS *** CFSTOREDPROC PROCEDURE=TestBed.fSelectState DATASOURCE=HomesCom DEBUG=Yes RETURNCODE=No CFPROCPARAM TYPE=In CFSQLTYPE=CF_SQL_VARCHAR DBVARNAME=inStateAbbrev VALUE=#StateAbbrev# NULL=No CFPROCPARAM TYPE=Out CFSQLTYPE=CF_SQL_VARCHAR DBVARNAME=outStateName VARIABLE=CF_StateName NULL=No /CFSTOREDPROC Example 2: Reference cursor returned *** SUCCEEDS *** CFSTOREDPROC PROCEDURE=TestBed.SelectStates DATASOURCE=HomesCom RETURNCODE=No CFPROCPARAM TYPE=In CFSQLTYPE=CF_SQL_VARCHAR DBVARNAME=inStateAbbrev VALUE=#StateAbbrev# NULL=No CFPROCPARAM TYPE=Out CFSQLTYPE=CF_SQL_REFCURSOR DBVARNAME=qSelectStatesList VARIABLE=CF_qSelectStatesList NULL=No CFPROCRESULT NAME=qSelectStatesList /CFSTOREDPROC *** FAILS *** CFSTOREDPROC PROCEDURE=TestBed.fSelectStates DATASOURCE=HomesCom RETURNCODE=No CFPROCPARAM TYPE=In CFSQLTYPE=CF_SQL_VARCHAR DBVARNAME=inStateAbbrev VALUE=#StateAbbrev# NULL=No CFPROCPARAM TYPE=Out CFSQLTYPE=CF_SQL_REFCURSOR DBVARNAME=qSelectStatesList VARIABLE=CF_qSelectStatesList NULL=No CFPROCRESULT NAME=qSelectStatesList /CFSTOREDPROC ~~ 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
Protectiong an application
Hi, I am trying to protect an application using Advanced Security. I'm defining the resource as an Application. I followed various tutorials step by step but still it ignores the NT User group defined in the policy for the rule. I'm just wondering, how does it know which application to apply the policy? Is it the NAME attribute of the CFAPPLICATION tag? Thanks. Frank Mamone ~~ 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: HTML Question with Netscape 4 and 6
Like you said, you've got a firewall -- I get cannot find server with that URL. -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 12:17 PM To: CF-Talk Subject: OT: HTML Question with Netscape 4 and 6 Can someone please tell me why these pages completely mess up in Netscape 4 and 6 besides the obvious fact that they are the most horrid browsers on the face of the earth. http://209.215.124.4/community/index.cfm If you have any problems on here let me know, I have a firewall on this machine. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire ~~ 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: file uploads without using CFFILE
If your hosting provider allows CFX, there's a CFX_File in the Allaire dev exchange that would do the job. -Original Message- From: Joe Sheble aka Wizaerd [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 10:46 AM To: CF-Talk Subject: file uploads without using CFFILE If hosted at an outside hosting provider, and that provider has CFFILE turned off, what other alternatives are there for uploading files from the client to the server. CFFTP won't work because it's expected to work via FTP server to server. This is for CF 4.5. Is there perhaps a free COM object that could be accessed via CF to profide this functionality? I found a free one, but all the examples give ASP code, and relies on the REQUEST and FORM collections available in ASP. Ideas? Suggestions? ~~ 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: HTML Question with Netscape 4 and 6
and once again, i think we need to do something about that web developer extraordinaire in the signature file... -Original Message- From: Jann VanOver [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 1:21 PM To: CF-Talk Subject: RE: HTML Question with Netscape 4 and 6 Like you said, you've got a firewall -- I get cannot find server with that URL. -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 12:17 PM To: CF-Talk Subject: OT: HTML Question with Netscape 4 and 6 Can someone please tell me why these pages completely mess up in Netscape 4 and 6 besides the obvious fact that they are the most horrid browsers on the face of the earth. http://209.215.124.4/community/index.cfm If you have any problems on here let me know, I have a firewall on this machine. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire ~~ 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: Turn off double-spacing on rds xfer
But it is set to Unix already. Any other ideas? Bruce [EMAIL PROTECTED] - Original Message - From: Garza, Jeff [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 11:17 AM Subject: RE: Turn off double-spacing on rds xfer F8 - File Settings - Check Format When Saving = Unix HTH, Jeff Garza Lead Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Bruce Holm [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 8:53 AM To: CF-Talk Subject: Turn off double-spacing on rds xfer Short version: Does anyone know where the setting is in CF Studio 4.5 for preventing my files (that are transfered via RDS) from being converted to double-spacing (the lines of code?) Long version? When I first loaded CF Studio 4.5 about a year ago, all was fine. But the last 4 months, when I xfer my single-spaced .cfm source code file from our development server (a Sun UNIX box) to our staging server (also a Sun UNIX box), the files end up double-spaced. I have to open the file on the staging server, remove double-spacing, and resave it to rid it of the every-other (blank) line. I thought this had to do with the OptionsSettings... and selecting File Settings where you can specify Unix file types. But mine is already set to Unix. Other teammate's CF Studio isn't behaving this way. Is a preference file corrupted or is there a logical explanation (and cure) for this problem??? - Bruce Holm - Web Programmer Lattice Semiconductor Corp. [EMAIL PROTECTED] - ~~ 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: file uploads without using CFFILE
Hi Joe Does the host have ASP? If so, just incorporate it into your program flow as if you used a stand-alone CFTemplate to perform the upload and save the file: Template1.cfm... Present upload form - Action specifies ASP template Template2.asp... Upload, Save and rename the file invoke Template3.cfm Template3.cfm... Update database, etc and Present results to user I did things like this at the old iTool before the enabled cffile. HTH Dick At 12:45 PM -0500 7/10/01, Joe Sheble aka Wizaerd wrote: If hosted at an outside hosting provider, and that provider has CFFILE turned off, what other alternatives are there for uploading files from the client to the server. CFFTP won't work because it's expected to work via FTP server to server. This is for CF 4.5. Is there perhaps a free COM object that could be accessed via CF to profide this functionality? I found a free one, but all the examples give ASP code, and relies on the REQUEST and FORM collections available in ASP. Ideas? Suggestions? ~~ 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: dbtype=dynamic
Has anyone tried to connect to a database thru the new connection string method? I've successfully connected with ODBC DSNless connection strings, but when I try an OLE DB connection string, the cfquery fails. Does it work only with DSNLess connections? According to the docs, DBTYPE=DYNAMIC is only for use with ODBC. I haven't tried using it with OLEDB, but your problem might be that when you use DBTYPE=DYNAMIC, by default, CF uses some shared settings. I only vaguely recall exactly what gets shared, but remember reading about it in release notes for one of the betas. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ 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
Accessing outlook/exchange folders?
A client has asked if CF can access public folders in Outlook, word and excel documents are held in these folders and they would like them to be available on a private website. I have little experience of Outlook and Exchange so I am stumped on this, I was wondering if anyone had done it before - or if it just isn't possible? Regards, Wayne Putterill ~~ 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: Column names containing a # sign
Try tripleing your # signs. I know this sounds crazy, but had a similar instance and table_Name### worked like a charm. CW -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 12:50 PM To: CF-Talk Subject: Re: Column names containing a # sign Try calling the # with its respectebly chr(num) I don't know which asacii code is # but try this (although it may sounds silly): (let's say the 19 ASCII code is #)... UPDATE Registration#chr(19)# SET . bla bla bla It might help because I've seen cases where the char itself and the chr(ASCII_char_num) performed diffrently. Michael. - Original Message - From: Daniel Lancelot [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 9:31 PM Subject: RE: Column names containing a # sign have you tried doubling your # ie product# = product## etc - cf should convert that to a single # before passing to db... -Original Message- From: Tristram Charnley [mailto:[EMAIL PROTECTED]] Sent: 10 July 2001 17:18 To: CF-Talk Subject: Column names containing a # sign Hi I've been given a database containing column names such as Product# and Registration# I've tried using aliases and backticks on these columns in my query to no effect - the # sign throws CF each time. Changing the column names isn't an option unfortunately. Any suggestions greatfully received. Tristram Charnley ~~ 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
Text Field Size Limits?
Hi, I'm wondering about size limitations on text fields and/or memo fields. We are using Access to create our table and I was using a text field that I believe limited me to about 255 characters. The boss wanted more so I changed it to a memo field but it seem that the data is still truncating after about 400 or so characters. I am using textarea to populate the field but I don't think the textarea tag is truncating. It seem to truncate during insert into the table. Any info/help would be appreciated. Thanks, Eric Homa ~~ 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: Form builder software
I would just use adobe acrobat. Will do everything you want... CW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 2:10 PM To: CF-Talk Subject: SOT: Form builder software Hi all, I need to find a better solution than html forms to meet my clients needs. My client has a bunch of paper forms and documents that he wants to use online. I've tried creating these in html but the lack of formatting and print control is causing some problems. Not to mention the huge amount of time it's taking. Does anybody know of a better way to create these forms online. I need them to be able to except input from a database to populate the fields in the form and to be manually updateable online. I found one product that may work, it's called Liquid Forms and converts the forms to editable pdf versions. Any other solutions out there you guys can recommend? Thanks, Rick ~~ 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: HTML Question with Netscape 4 and 6
After your inner table end tag, put an ending row tag also, just a /td CW -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 3:29 PM To: CF-Talk Subject: RE: HTML Question with Netscape 4 and 6 and once again, i think we need to do something about that web developer extraordinaire in the signature file... -Original Message- From: Jann VanOver [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 1:21 PM To: CF-Talk Subject: RE: HTML Question with Netscape 4 and 6 Like you said, you've got a firewall -- I get cannot find server with that URL. -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 12:17 PM To: CF-Talk Subject: OT: HTML Question with Netscape 4 and 6 Can someone please tell me why these pages completely mess up in Netscape 4 and 6 besides the obvious fact that they are the most horrid browsers on the face of the earth. http://209.215.124.4/community/index.cfm If you have any problems on here let me know, I have a firewall on this machine. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire ~~ 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: HTML Question with Netscape 4 and 6
yep netscape doesn't forgive forgetting /td tags... geeezzz -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 3:17 PM To: CF-Talk Subject: OT: HTML Question with Netscape 4 and 6 Can someone please tell me why these pages completely mess up in Netscape 4 and 6 besides the obvious fact that they are the most horrid browsers on the face of the earth. http://209.215.124.4/community/index.cfm If you have any problems on here let me know, I have a firewall on this machine. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire ~~ 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: Accessing outlook/exchange folders?
It's possible takes a bit of programming though... I have a site that pulls all .msg files via cold fusion throws them in a verity collection, then sucks some additional information into a SQL database. Completely different from what you are trying to do but thought I would mention it http://www.nunya.com -Original Message- From: Wayne Putterill [mailto:[EMAIL PROTECTED]] Sent: Friday, July 06, 2001 8:40 AM To: CF-Talk Subject: Accessing outlook/exchange folders? A client has asked if CF can access public folders in Outlook, word and excel documents are held in these folders and they would like them to be available on a private website. I have little experience of Outlook and Exchange so I am stumped on this, I was wondering if anyone had done it before - or if it just isn't possible? Regards, Wayne Putterill ~~ 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: Text Field Size Limits?
Don't know why yours is truncating, I also use Access Memo fields and have some that are over 3,000 chars. I also use textarea to enter/edit these fields. Sorry no help, just info -Original Message- From: ehoma [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 2:20 PM To: CF-Talk Subject: Text Field Size Limits? Hi, I'm wondering about size limitations on text fields and/or memo fields. We are using Access to create our table and I was using a text field that I believe limited me to about 255 characters. The boss wanted more so I changed it to a memo field but it seem that the data is still truncating after about 400 or so characters. I am using textarea to populate the field but I don't think the textarea tag is truncating. It seem to truncate during insert into the table. Any info/help would be appreciated. Thanks, Eric Homa ~~ 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: dbtype=dynamic
You might be able to find something in this Microsoft article that might help. http://support.microsoft.com/support/kb/articles/q193/3/32.asp Debbie - Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 5:07 PM Subject: RE: dbtype=dynamic Has anyone tried to connect to a database thru the new connection string method? I've successfully connected with ODBC DSNless connection strings, but when I try an OLE DB connection string, the cfquery fails. Does it work only with DSNLess connections? According to the docs, DBTYPE=DYNAMIC is only for use with ODBC. I haven't tried using it with OLEDB, but your problem might be that when you use DBTYPE=DYNAMIC, by default, CF uses some shared settings. I only vaguely recall exactly what gets shared, but remember reading about it in release notes for one of the betas. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ 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
What are YOUR settings? (CF Security)
I'm not sure anyone wants the whole world to know what their CF servers are set to allow/disallow when it comes to tags. But I'm very interested in knowing the suggestions/feelings/examples of others when it comes to the tags that they allow on their servers. Specifically, ISPs/WHPs are my interest. I'm building a report for the board, and thought the input from others would help. Can you reply to me off-list and let me know? It would be GREATLY appreciated! Thanks! Lee Fuller Chief Technical Officer PrimeDNA Corporation / AAA Web Hosting Corporation We ARE the net. http://www.aaawebhosting.com ~~ 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: URL Hacks - Solution
From: Paris Lundis [EMAIL PROTECTED] Subject: RE: URL Hacks - Solution I think the script is a good first attempt and seems to address the URL hack threads previously that have gone around. Thank you. My feelings exactly. As usual, Dave Watts was right when he said this script doesn't cover enough attacks. However, it was intended to cover the attack that started this thread. I'll be happy to expand it's abilities if I can get some help. so programatically (SQL wise) what else might one post in the string to pickup further data???... May the SQL gods speak... The fun part about dealing with hack attacks on a public forum like this is that no one wants to dish any details, which is a good thing, but it does make projects like this difficult. I think if we all chip in with some specifics this program could get furthered and cover perhaps other known hack arounds... If anyone has any other info on database hacks that they'd like to help defend against, please contact me off list. The more I know about, the better this script can be. If you have just general comments, please post them here of course. Maybe your thought will get someone thinking. Thanks again, Paris for the good words and push to continue. From: Bruce, Rodney [EMAIL PROTECTED] Subject: RE: URL Hacks - Solution URL hacks I think are easier to handle than form.Variables. As far as I'm concerned, variables are variables. These attacks require certain language context no matter if they come from urls, forms, etc., so filtering out the key phrase(s) the right way *should* repel them. But I like the idea of adding the notification by email when an attempted hack is tried and then kicking them off site. Thanks, Bruce. That's the real meat of my security concepts. If anything unwanted is going on, I want to know about it and get rid of them. I never understood why we throw a friendly error message to someone attacking our system. But that's just me. _ Get your FREE download of MSN Explorer at http://explorer.msn.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF Studio Preference File
Does anyone know where the CF Studio preference file is located? I'm guessing that maybe it needs to be thrown away and recreated. I'm specifically looking for the one the contains OptionsSettings... for RDS or file transfers. Bruce - Original Message - From: Bruce Holm [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 11:52 AM Subject: Re: Turn off double-spacing on rds xfer But it is set to Unix already. Any other ideas? Bruce [EMAIL PROTECTED] - Original Message - From: Garza, Jeff [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 11:17 AM Subject: RE: Turn off double-spacing on rds xfer F8 - File Settings - Check Format When Saving = Unix HTH, Jeff Garza Lead Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Bruce Holm [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 8:53 AM To: CF-Talk Subject: Turn off double-spacing on rds xfer Short version: Does anyone know where the setting is in CF Studio 4.5 for preventing my files (that are transfered via RDS) from being converted to double-spacing (the lines of code?) Long version? When I first loaded CF Studio 4.5 about a year ago, all was fine. But the last 4 months, when I xfer my single-spaced .cfm source code file from our development server (a Sun UNIX box) to our staging server (also a Sun UNIX box), the files end up double-spaced. I have to open the file on the staging server, remove double-spacing, and resave it to rid it of the every-other (blank) line. I thought this had to do with the OptionsSettings... and selecting File Settings where you can specify Unix file types. But mine is already set to Unix. Other teammate's CF Studio isn't behaving this way. Is a preference file corrupted or is there a logical explanation (and cure) for this problem??? - Bruce Holm - Web Programmer Lattice Semiconductor Corp. [EMAIL PROTECTED] - ~~ 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: Debug output
-Original Message- From: Justin [mailto:[EMAIL PROTECTED]] Subject: RE: Debug output Try putting font color=white after your /html at the end of your pages. Better yet, you could put it in onrequestend.cfm, then you wouldn't have to modify all your pages. Justin Hansen - [EMAIL PROTECTED] Web Application Developer Interactive Business Solutions, Inc 816-221-5200 ext. 1305 U Justin, what's onrequestend.cfm?The way you wrote that makes me think that's another of the many undocumented features of CF that I learn about here rather than in the documentation or the books. Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks ~~ 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
Client Variables NOT going away though I try
I'm having the darnedest time trying to delete client files on browser close or after a period of time. I'm even trying to follow Hal Helms great Tracking State Management with Cold Fusion to run this correctly. Even running the code below - the CFID and CFTOKEN are exactly the same, and are unforgotten. They are supposed to disappear, but they don't! Here's a chuck of my application file: !--- Application Settings --- cfapplication name=thisapplication clientmanagement=Yes sessionmanagement=Yes setclientcookies=Yes sessiontimeout=#CreateTimeSpan(0,0,20,0)# clientstorage=thisapplication_Client !--- Expire the Client Variables when the browser closes --- CFIf IsDefined(cookie.CFID) AND Isdefined(cookie.CFTOKEN) CFSET localCFID = Cookie.CFID CFSET localCFTOKEN = Cookie.CFTOKEN CFCOOKIE name=CFID value=#localCFID# CFCOOKIE name=CFTOKEN value=#localCFTOKEN# /CFIF !--- Expire the Client Variables on 5 minutes --- CFPARAM NAME=CLIENT.CheckLastVisit DEFAULT=#CreateODBCDateTime(Now())# CFSET Compare = DateCompare(DateAdd(n, -5, CreateODBCDateTime(Now())), CLIENT.CheckLastVisit) CFIF Compare IS NOT 1 CFSCRIPTStructClear(Session);/CFSCRIPT CFCOOKIE NAME=CFID VALUE=0 EXPIRES=NOW CFCOOKIE NAME=CFTOKEN VALUE=0 EXPIRES=NOW CFELSE CFSET CLIENT.CheckLastVisit = CreateODBCDateTime(Now()) /CFIF Help! Stephen R. Cassady [EMAIL PROTECTED] http://www.tallylist.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: dbtype=dynamic
I think Dave is right -- it only seems to work with ODBC connection strings, not OLEDB. tom Deb Dickerson [EMAIL PROTECTED] wrote in message 013401c10987$6b458e40$[EMAIL PROTECTED]">news:013401c10987$6b458e40$[EMAIL PROTECTED]... You might be able to find something in this Microsoft article that might help. http://support.microsoft.com/support/kb/articles/q193/3/32.asp Debbie ~~ 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: URL Hacks - Solution
Josh, Do keep us all posted as to the outcome of all this. There are those of us who will, no doubt, want to jump right on any solutions you find. If you need a list to keep up with this, let me know and I'll create a temporary (or permanent if needed) list to accommodate. Take care... Lee Fuller Chief Technical Officer PrimeDNA Corporation / AAA Web Hosting Corporation We ARE the net. http://www.aaawebhosting.com -Original Message- From: Josh R [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 10:08 PM To: CF-Talk Subject: RE: URL Hacks - Solution From: Paris Lundis [EMAIL PROTECTED] Subject: RE: URL Hacks - Solution I think the script is a good first attempt and seems to address the URL hack threads previously that have gone around. Thank you. My feelings exactly. As usual, Dave Watts was right when he said this script doesn't cover enough attacks. However, it was intended to cover the attack that started this thread. I'll be happy to expand it's abilities if I can get some help. so programatically (SQL wise) what else might one post in the string to pickup further data???... May the SQL gods speak... The fun part about dealing with hack attacks on a public forum like this is that no one wants to dish any details, which is a good thing, but it does make projects like this difficult. I think if we all chip in with some specifics this program could get furthered and cover perhaps other known hack arounds... If anyone has any other info on database hacks that they'd like to help defend against, please contact me off list. The more I know about, the better this script can be. If you have just general comments, please post them here of course. Maybe your thought will get someone thinking. Thanks again, Paris for the good words and push to continue. From: Bruce, Rodney [EMAIL PROTECTED] Subject: RE: URL Hacks - Solution URL hacks I think are easier to handle than form.Variables. As far as I'm concerned, variables are variables. These attacks require certain language context no matter if they come from urls, forms, etc., so filtering out the key phrase(s) the right way *should* repel them. But I like the idea of adding the notification by email when an attempted hack is tried and then kicking them off site. Thanks, Bruce. That's the real meat of my security concepts. If anything unwanted is going on, I want to know about it and get rid of them. I never understood why we throw a friendly error message to someone attacking our system. But that's just me. ~~ 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
How do I list query results in a random order fashion??
Dear Cf'ers: I have the below query that gets companies alphabetically (stupid, eh?) - the problem is, the companies don't like it because, being ordered by company name, it gives preference to those that begin with the first letters of the alphabet. Can anyone think of a way to order this list in a random fashion each time it is envoked?? Thank you all for your consideration. Tom CFQUERY NAME=GetAllCompaniesForThisCategory DATASOURCE=MedMallDs DBTYPE=ODBC SELECT DISTINCT JoinTbl.CategoryID, JoinTbl.CompanyID, CategoryTbl.CategoryName, CategoryTbl.CategoryID, CompanyTbl.CompanyID, CompanyTbl.CompanyName, CompanyTbl.WebAddress FROM CategoryTbl, JoinTbl, CompanyTbl WHERE JoinTbl.CategoryID = CategoryTbl.CategoryID AND JoinTbl.CompanyID = CompanyTbl.CompanyID AND JoinTbl.CategoryID = #CategoryID# AND CompanyTbl.WebAddress IS NOT NULL ORDER BY CompanyTbl.CompanyName /CFQUERY * MedMatrix New Used Medical Equipment Web Portal http://www.medmatrix.com V:(407) 772-3427 F:(407) 772-3428 Tom Forbes, Forbes Web Consulting, Inc. 178 S. Monterey Isle Blvd., Longwood, FL - 32779 * ~~ 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 do I list query results in a random order fashion??
Don't know if its the easiest or best, but one way is place your query output into an array say qarray Use RandRange() to generate random numbers use CFloop to loop through array Simple code: CFLOOP Condition= Arraylen(qarray) GT 0 CFSET rnum = Randrange(1,Arraylen(qarray)) #garray[rnum]# ArrayDeleteAt[qarray,rnum]!---clears that array element so each company is only displayed once-- /cfloop -Original Message- From: Tom Forbes [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 3:45 PM To: CF-Talk Subject: How do I list query results in a random order fashion?? Dear Cf'ers: I have the below query that gets companies alphabetically (stupid, eh?) - the problem is, the companies don't like it because, being ordered by company name, it gives preference to those that begin with the first letters of the alphabet. Can anyone think of a way to order this list in a random fashion each time it is envoked?? Thank you all for your consideration. Tom CFQUERY NAME=GetAllCompaniesForThisCategory DATASOURCE=MedMallDs DBTYPE=ODBC SELECT DISTINCT JoinTbl.CategoryID, JoinTbl.CompanyID, CategoryTbl.CategoryName, CategoryTbl.CategoryID, CompanyTbl.CompanyID, CompanyTbl.CompanyName, CompanyTbl.WebAddress FROM CategoryTbl, JoinTbl, CompanyTbl WHERE JoinTbl.CategoryID = CategoryTbl.CategoryID AND JoinTbl.CompanyID = CompanyTbl.CompanyID AND JoinTbl.CategoryID = #CategoryID# AND CompanyTbl.WebAddress IS NOT NULL ORDER BY CompanyTbl.CompanyName /CFQUERY * MedMatrix New Used Medical Equipment Web Portal http://www.medmatrix.com V:(407) 772-3427 F:(407) 772-3428 Tom Forbes, Forbes Web Consulting, Inc. 178 S. Monterey Isle Blvd., Longwood, FL - 32779 * ~~ 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 do I list query results in a random order fashion??
Try this: 1. Pull back the query unsorted. 2. Create a while-do loop that picks a random record from the query 3. Display the record 4. Delete the record from the record set 5. Go back to step 2. Kevin [EMAIL PROTECTED] 07/10/01 03:44PM Dear Cf'ers: I have the below query that gets companies alphabetically (stupid, eh?) - the problem is, the companies don't like it because, being ordered by company name, it gives preference to those that begin with the first letters of the alphabet. Can anyone think of a way to order this list in a random fashion each time it is envoked?? Thank you all for your consideration. Tom CFQUERY NAME=GetAllCompaniesForThisCategory DATASOURCE=MedMallDs DBTYPE=ODBC SELECT DISTINCT JoinTbl.CategoryID, JoinTbl.CompanyID, CategoryTbl.CategoryName, CategoryTbl.CategoryID, CompanyTbl.CompanyID, CompanyTbl.CompanyName, CompanyTbl.WebAddress FROM CategoryTbl, JoinTbl, CompanyTbl WHERE JoinTbl.CategoryID = CategoryTbl.CategoryID AND JoinTbl.CompanyID = CompanyTbl.CompanyID AND JoinTbl.CategoryID = #CategoryID# AND CompanyTbl.WebAddress IS NOT NULL ORDER BY CompanyTbl.CompanyName /CFQUERY * MedMatrix New Used Medical Equipment Web Portal http://www.medmatrix.com V:(407) 772-3427 F:(407) 772-3428 Tom Forbes, Forbes Web Consulting, Inc. 178 S. Monterey Isle Blvd., Longwood, FL - 32779 * ~~ 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: Client Variables NOT going away though I try
have you tried the DeleteClientVariable() function? -Original Message- From: Stephen R. Cassady [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 2:59 PM To: CF-Talk Subject: Client Variables NOT going away though I try I'm having the darnedest time trying to delete client files on browser close or after a period of time. I'm even trying to follow Hal Helms great Tracking State Management with Cold Fusion to run this correctly. Even running the code below - the CFID and CFTOKEN are exactly the same, and are unforgotten. They are supposed to disappear, but they don't! Here's a chuck of my application file: !--- Application Settings --- cfapplication name=thisapplication clientmanagement=Yes sessionmanagement=Yes setclientcookies=Yes sessiontimeout=#CreateTimeSpan(0,0,20,0)# clientstorage=thisapplication_Client !--- Expire the Client Variables when the browser closes --- CFIf IsDefined(cookie.CFID) AND Isdefined(cookie.CFTOKEN) CFSET localCFID = Cookie.CFID CFSET localCFTOKEN = Cookie.CFTOKEN CFCOOKIE name=CFID value=#localCFID# CFCOOKIE name=CFTOKEN value=#localCFTOKEN# /CFIF !--- Expire the Client Variables on 5 minutes --- CFPARAM NAME=CLIENT.CheckLastVisit DEFAULT=#CreateODBCDateTime(Now())# CFSET Compare = DateCompare(DateAdd(n, -5, CreateODBCDateTime(Now())), CLIENT.CheckLastVisit) CFIF Compare IS NOT 1 CFSCRIPTStructClear(Session);/CFSCRIPT CFCOOKIE NAME=CFID VALUE=0 EXPIRES=NOW CFCOOKIE NAME=CFTOKEN VALUE=0 EXPIRES=NOW CFELSE CFSET CLIENT.CheckLastVisit = CreateODBCDateTime(Now()) /CFIF Help! Stephen R. Cassady [EMAIL PROTECTED] http://www.tallylist.com 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
Mailings that appear to be from humans?
Hi all, I want to send mail with cfmail but when receiving the mail I want it to appear as if its from a human name opposed to an email address. Example: From: John Doe Opposed to From: [EMAIL PROTECTED] Anyone have any ideas on how to do this? btw I understand that the mail still must come from an email address, just wondering if maybe I could add some sort of header for the human name part Thanks in advance, Jeff ~~ 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: Mailings that appear to be from humans?
Create the From as John Doe [EMAIL PROTECTED]. That will handle it for you. Lee Fuller Chief Technical Officer PrimeDNA Corporation / AAA Web Hosting Corporation We ARE the net. http://www.aaawebhosting.com -Original Message- From: Jeff Green [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 5:25 PM To: CF-Talk Subject: Mailings that appear to be from humans? Hi all, I want to send mail with cfmail but when receiving the mail I want it to appear as if its from a human name opposed to an email address. Example: From: John Doe Opposed to From: [EMAIL PROTECTED] Anyone have any ideas on how to do this? btw I understand that the mail still must come from an email address, just wondering if maybe I could add some sort of header for the human name part Thanks in advance, Jeff ~~ 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: Mailings that appear to be from humans?
Jeff: You can use this: to=Human[EMAIL PROTECTED] Yvette Ingram Brainbench Certified ColdFusion 4.5 Programmer Email: [EMAIL PROTECTED] or [EMAIL PROTECTED] ICQ: 21200397 Website: http://www.tkisolutions.com - Original Message - From: Jeff Green [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 8:24 PM Subject: Mailings that appear to be from humans? Hi all, I want to send mail with cfmail but when receiving the mail I want it to appear as if its from a human name opposed to an email address. Example: From: John Doe Opposed to From: [EMAIL PROTECTED] Anyone have any ideas on how to do this? btw I understand that the mail still must come from an email address, just wondering if maybe I could add some sort of header for the human name part Thanks in advance, Jeff ~~ 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: Form builder software
scan into Omniform 4.0 Edit/tweak the OCR results will automatically recognize MOST paperform fields and assigna generic name. from OmniForm - File save as PDF Open the pdf form in full version of Adobe acrobat and edit form fields names/formatting This is now your online form/template. Use www.activepdf.com's toolkit to pipe data via CF into these form templates, or you can use the Adobe Acrobat FDF activex or java toolkit. All the best, Steve - Original Message - From: Rick Lamb [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 12:10 PM Subject: SOT: Form builder software Hi all, I need to find a better solution than html forms to meet my clients needs. My client has a bunch of paper forms and documents that he wants to use online. I've tried creating these in html but the lack of formatting and print control is causing some problems. Not to mention the huge amount of time it's taking. Does anybody know of a better way to create these forms online. I need them to be able to except input from a database to populate the fields in the form and to be manually updateable online. I found one product that may work, it's called Liquid Forms and converts the forms to editable pdf versions. Any other solutions out there you guys can recommend? Thanks, Rick ~~ 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