Multiple CFFile
I have 4 cffiles set up on one form page. The first cffile uploads to the proper location and also inserts into the db however the other 3 do not get the proper information. My code looks like this. UPDATE ProdPics SET ItemPicLB = '#ItemPicLB#' WHERE #ItemID# = PicID UPDATE ProdPics Set ItemPicF = '#ItemPicF#' WHERE #ItemID# = PicID UPDATE ProdPics Set ItemPicB = '#ItemPicB#' WHERE #ItemID# = PicID TIA Alan ~~ 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: Parse the width and height of an uploaded graphic file?
There's a custom tag named CFX_IMGINFO. This returns the height and the width of the specified images (gif or jpg). There's another one na,ed CF_IMAGESIZE. This also retuens the height / width of images. DK www.artmaya.com - Original Message - From: Jeff Small <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Sent: Friday, April 13, 2001 2:26 AM Subject: Parse the width and height of an uploaded graphic file? > Is it possible to return the width and height of a jpeg or gif graphic > that's uploaded using 'cffile action = upload'? > ~~ 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 field not being properly evaulated
David, Solved it yesterday. Problem was in my cfselect statement. Thanks for getting back to me. James David Shadovitz wrote: > > It's because you have > ?user=#Trim(list.username)# > as part of the form's action. Eliminate this. Instead, the action page should > use Form.username. > > -David > > On Wednesday, April 11, 2001 7:36 AM, James Taavon > [SMTP:[EMAIL PROTECTED]] wrote: > > I am not sure why I can't figure this out, I thought it was simple. > > > > I am using a to populate a drop down list of names. When a > > new name is selected, it only selects the name from the top of the list. > > The action file is the same as the originating file. > > > > > > This query evaluates the user that just logged in. > > - > > > > select * from taavon.users > > where username= '#url.user#' > > > > > > > > This query is for the drop down list > > > > > > select * from taavon.users > > where manager = 'self' > > order by fullname > > > > > > > > Query list contents of user's work. > > --- > > > > select * from taavon.users, taavon.submissions > > where taavon.users.fullname = taavon.submissions.assignedto and > > username = '#url.user#' > > order by LID > > > > > > > > > > > > File Active_Inbox.cfm > > - > > > method="post"> > > > value="fullname"> > > > > > > ~~ 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
Looking for CF code for building breadcrumbs
Does anyone know of a source for a good example of using CF code to build a breadcrumb navigation trail similar to what is shown for ASP in this evolt article? http://www.evolt.org/article/Breadcrumbs_for_Those_Using_ASP/17/4438/index.h tml Thanks! George [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
sql date times
Hi all, our sql server is set up to american date Time format, so as you know once thats done you must play by its rules, I know this is an SQL question but does anyone know how to break dates apart using the (cast or convert functions, (I think)) IN SQL,, its just that when I mask my date from my query I never get the right date.. I've submitted this query before, but not regarding the above... if anyone has any ideas' I'd be well gratefull thanx... JMC... ~~ 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: cannot display
Thanks all for the suggestions and quick replies! I check everything suggested and it was as per specs. After some rebooting and starting and stopping IIS and CF all works OK. Don't know what that was exactly, but it was our main server (thankfully) :). Robert O. >-Original Message- >From: Jeremy Castonguay [mailto:[EMAIL PROTECTED]] >Sent: Thursday, April 12, 2001 4:19 PM >To: CF-Talk >Subject: RE: cannot display > > >Is your wwwroot folder marked as executable... If its not CFML templates >will not execute upon launching.. > >Thanks >Jeremy W. Castonguay >eCopy Inc. >www.ecopy.com > > >-Original Message- >From: Robert Orlini [mailto:[EMAIL PROTECTED]] >Sent: Thursday, April 12, 2001 4:36 PM >To: CF-Talk >Subject: cannot display > > >This may be an easy one but... > >Right out of the blue my development machine refuses to display any .CFM >pages. All I get is "Page cannot be displayed". All .htm pages work. CF >Server is started and running. Permissions should be OK. > >Any suggestions? > >Thanks. > >Roberto O. > ~~ 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
Security & Scripting
There is an excellent small article on security vis a vis URL, cookie and form parameters at: http://webreview.com/2001/04_13/developers/index02.shtml My question is what do the members of this list use to prevent malicious attempts to alter or destroy a database by means of the URL form or cookie such as an example given in the article: http://www.mysite.com/doLogin.php?UserID=12345 changed to http://www.mysite.com/doLogin.php?UserID=12345+TRUNCATE+TABLE+Items or when someone enters a SQL command in a form text box 12345 TRUNCATE TABLE Items I guess one could do a content check of every submitted variable to detect for SQL statements such as TRUNCATE, DELETE, UPDATE, INSERT, etc. Thanks, Sebastian ~~ 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
CFFILE Error
Has anyone seen this error message before: Error in CFFILE tag The form field specified in the CFFILE tag (DOCUMENT) does not contain an uploaded file. Please be sure that you have specified the correct form field name. 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: Security & Scripting
In your example, where you pass the userID on the line, using Val can overcome it. http://www.mysite.com/doLogin.php?UserID=12345+TRUNCATE+TABLE+Items Select * from Users where UserID = #Val(url.UserID)# - Original Message - From: "sebastian palmigiani" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, April 13, 2001 8:13 AM Subject: Security & Scripting > > There is an excellent small article on security vis a vis URL, cookie and > form parameters at: > > http://webreview.com/2001/04_13/developers/index02.shtml > > My question is what do the members of this list use to prevent malicious > attempts to alter or destroy a database by means of the URL form or cookie > such as an example given in the article: > > http://www.mysite.com/doLogin.php?UserID=12345 > > changed to > > http://www.mysite.com/doLogin.php?UserID=12345+TRUNCATE+TABLE+Items > > or when someone enters a SQL command in a form text box > > 12345 TRUNCATE TABLE Items > > I guess one could do a content check of every submitted variable to detect > for SQL statements such as TRUNCATE, DELETE, UPDATE, INSERT, etc. > > Thanks, > Sebastian > > > ~~ 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
Make sure your FORM contains the encryption: multipart/form-data -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Friday, April 13, 2001 9:20 AM To: CF-Talk Subject: CFFILE Error Has anyone seen this error message before: Error in CFFILE tag The form field specified in the CFFILE tag (DOCUMENT) does not contain an uploaded file. Please be sure that you have specified the correct form field name. 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: CFFILE Error
Hi James, This error has been plaguing me for months and I finally figured out what is causing it. It's due to users with browsers older than MSIE 4 or Netscape 3 trying to use the tag on a page. These browsers don't know about this tag. Check your error log and you can see what browser version is used when the error occurs. Usually it's MSIE 3.02. Mike Cady - Original Message - From: "James Taavon" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, April 13, 2001 9:20 AM Subject: CFFILE Error > Has anyone seen this error message before: > > Error in CFFILE tag > > The form field specified in the CFFILE tag (DOCUMENT) does not contain > an uploaded file. Please be sure that you have specified the correct > form field name. > > 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: CFFILE Error
oh.. right. thanks for reminding me. "Adkins, Randy" wrote: > > Make sure your FORM contains the encryption: > multipart/form-data > > -Original Message- > From: James Taavon [mailto:[EMAIL PROTECTED]] > Sent: Friday, April 13, 2001 9:20 AM > To: CF-Talk > Subject: CFFILE Error > > Has anyone seen this error message before: > > Error in CFFILE tag > > The form field specified in the CFFILE tag (DOCUMENT) does not contain > an uploaded file. Please be sure that you have specified the correct > form field name. > > 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: Converting/creating .htaccess (UNIX crypt) passwords help nee ded.
Try checking http://packetstorm.securify.com They have tons of stuff that you can use. I think the most popular one is called John the ripper. As far as the original problem, perhaps you could store the ciphertext password in a database (or keep them in the text file), and use to run a program that will encipher the user entered data, and compare it with the enciphered password? This is basically what a Unix system does when you enter the password anyway. Chris Martin FSenablers, Inc -Original Message- From: Peter Janett [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 12, 2001 8:25 PM To: CF-Talk Subject: Re: Converting/creating .htaccess (UNIX crypt) passwords help nee ded. Are passwords crypted with the "crypt" function on UNIX "breakable"? I have another situation where I originally setup POP passwords using crypt, and would like to go to plain text, as my clients always forget their passwords, and I have to just reset it to a new one. So, if you know of any way to "uncrypt" please let me know. (If you'd feel better emailing me privately, feel free.) Thanks, Peter Janett New Media One Web Services WEB HOSTING FOR WEB DEVELOPERS Sun, IRIX, Windows 2000, Linux; PHP, MySQL, Perl, Cold Fusion, MS SQL, ASP, SSI, SSL http://www.newmediaone.net [EMAIL PROTECTED] (303)828-9882 - Original Message - From: "Terry Bader" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, April 12, 2001 3:58 PM Subject: RE: Converting/creating .htaccess (UNIX crypt) passwords help nee ded. > don't quote me on this but i do not think it is possible... even using perl > on both systems to create the encryption... both platforms perform the > encrypt functionality differently... > > well, in my experience, once tried to do the same thing... but i too may > have missed something. > > my only recommendation to too run a password breaker on the unix encrypted > passwords, save it to a file like ID::CLEARTEXTPASSWORD > then take it to your windows platform and use cfml to parse the file and > re-encrypt... > but this isnt gaurrenteed due to that not all passwords are figured out by > the breaker... > > good-luck and if there is an easy solution, let me know PLZ... > > > > Terry Bader > IT/Web Specialist > EDO Corp - Combat Systems > (757) 424-1004 ext 361 - Work > [EMAIL PROTECTED] > > > (757)581-5981 - Mobile > [EMAIL PROTECTED] > icq: 5202487 aim: lv2bounce > http://www.cs.odu.edu/~bader > > > > > > > > -Original Message- > > From: Peter Janett [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, April 12, 2001 4:05 PM > > To: CF-Talk > > Subject: Converting/creating .htaccess (UNIX crypt) passwords help > > needed. > > > > > > Converting/creating .htaccess (UNIX crypt) password help needed. > > > > I'm moving a site over from UNIX to Win2k with CF. I need to > > duplicate a > > password protected directory that used .htaccess passwords on > > the old UNIX > > system. > > > > The issue is, there is a large number of username/password > > combinations. I > > don't have the passwords anywhere, so I need to duplicate the > > process of > > crypt, so I can crypt the new password, and test it against > > the one crypted > > on the old UNIX account. > > > > Any help appreciated, > > > > Peter Janett > > > > New Media One Web Services > > > > WEB HOSTING FOR WEB DEVELOPERS > > > > Sun, IRIX, Windows 2000, Linux; > > PHP, MySQL, Perl, Cold Fusion, > > MS SQL, ASP, SSI, SSL > > http://www.newmediaone.net > > [EMAIL PROTECTED] > > (303)828-9882 > > > > > > > > > ~~ 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: Security & Scripting
What function would you use if the UserID contained characters and numbers such as SPAL12? Sebastian on 4/13/01 8:23 AM, Tim Painter at [EMAIL PROTECTED] wrote: > In your example, where you pass the userID on the line, using Val can > overcome it. > > http://www.mysite.com/doLogin.php?UserID=12345+TRUNCATE+TABLE+Items > > > Select * from Users where UserID = #Val(url.UserID)# > > - Original Message - > From: "sebastian palmigiani" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, April 13, 2001 8:13 AM > Subject: Security & Scripting > > >> >> There is an excellent small article on security vis a vis URL, cookie and >> form parameters at: >> >> http://webreview.com/2001/04_13/developers/index02.shtml >> >> My question is what do the members of this list use to prevent malicious >> attempts to alter or destroy a database by means of the URL form or cookie >> such as an example given in the article: >> >> http://www.mysite.com/doLogin.php?UserID=12345 >> >> changed to >> >> http://www.mysite.com/doLogin.php?UserID=12345+TRUNCATE+TABLE+Items >> >> or when someone enters a SQL command in a form text box >> >> 12345 TRUNCATE TABLE Items >> >> I guess one could do a content check of every submitted variable to detect >> for SQL statements such as TRUNCATE, DELETE, UPDATE, INSERT, etc. >> >> Thanks, >> Sebastian >> >> >> > ~~ 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 Download
I am trying to give the user access to download files that are located on a different hard drive than the webserver directory. I have used cfdirectory in the past when files were located in the home web server directory. The cffile would list all files and the user can click on file name which is a link that will either open file in user's browser or prompt them to save file to disk. My problem now is that the files are located on a different drive and the url link will not get me out of the home directory to get file. Plus the file list needs to be dynamically generated so user can select from list. I have tried a few custom tags but didn't have much luck. Any help would be appreciated. Thanks, Shannon ~~ 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
Resolving file name after upload
After successfully uploading a file to the server I want to be able to view from the web. Instead of storing the actual file name in the database it stored a temporary name C:\WINNT\TEMP\ACF8.tmp. I am using a CFCONTENT tag which works great if do direct insert into the database via SQL INSERT, but when using my CFFORM it uses this temp name. What can I do to resolve this problem to get the actual fil name in the database? Thanks! 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: Resolving file name after upload
After the file is uploaded, you should be able to use: #File.ServerFile# -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Friday, April 13, 2001 10:13 AM To: CF-Talk Subject: Resolving file name after upload After successfully uploading a file to the server I want to be able to view from the web. Instead of storing the actual file name in the database it stored a temporary name C:\WINNT\TEMP\ACF8.tmp. I am using a CFCONTENT tag which works great if do direct insert into the database via SQL INSERT, but when using my CFFORM it uses this temp name. What can I do to resolve this problem to get the actual fil name in the database? Thanks! 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: wddx --> SQL Server 7 ?
> I'm using CF 4.0.1 and SQL 7. I've built up a fair sized > Structure (e.g. up to about 10K) over several data entry pages, > and want to insert the 30 to 60 rows into my database. So these > are my options, and I want to do the third one: > > 1. CFLOOP through structure in CF, doing insert statements (I > won't do this: too many db calls from CF). > 2. Use CF to create a large string, pass that to stored proc, > parses and > loop through with inserts. I can do this. > 3. Create wddx packet, send that to a stored proc somehow. > This is what I'd like to do. > > Any hints, articles, etc on INSERTING xml or Wddx? I know SQL > can create it, but I'm at a total loss on inserting. You might want to take a look at a recent SQL Server 2000 presentation by our own Simon Horwith, which discusses batch inserts/updates using XML. I'm pretty sure you can do this with SQL Server 7 as well, using an add-on available from Microsoft. I don't know if you'll be able to use WDDX with this, though. The presentation is on the Fig Leaf web site; select User Groups ... CFUG ... Meeting Notes. 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
RE: Does Studio have Built-in Scripting?
> Is there a way to set up scripts to run and do something > within studio. Something like writing the Last Modified > Date to a comment field when the file is saved? I know > other programs have some of their own built-in scripting. > Does Studio, and if so, where do I find it? Studio can be automated using Windows Script Host. Jason Powers did a good presentation on using scripts with Studio at our last CFUG. The presentation is on the Fig Leaf web site; select User Groups ... CFUG ... Meeting Notes. 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
Re: Resolving file name after upload
Randy, Do I use that in my CFCONTENT. Currently i have select documents from taavon.submissions where lid = '#url.lid#' "Adkins, Randy" wrote: > > After the file is uploaded, you should be able to use: > #File.ServerFile# > > -Original Message- > From: James Taavon [mailto:[EMAIL PROTECTED]] > Sent: Friday, April 13, 2001 10:13 AM > To: CF-Talk > Subject: Resolving file name after upload > > After successfully uploading a file to the server I want to be able to > view from the web. Instead of storing the actual file name in the > database it stored a temporary name C:\WINNT\TEMP\ACF8.tmp. > > I am using a CFCONTENT tag which works great if do direct insert into > the database via SQL INSERT, but when using my CFFORM it uses this temp > name. What can I do to resolve this problem to get the actual fil name > in the database? > > Thanks! > > 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: Resolving file name after upload
James, When the information is stored into the database ( DOCUMENTS ) check the variable named used with in the insert There is where you want to use #File.ServerFile#. Then yes, your content would use the variable that you pull from the docs query. *** Note the name in the Select Line must be the same in the CONTENT File name. Example: select documents from taavon.submissions where lid = '#url.lid#' -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Friday, April 13, 2001 10:44 AM To: CF-Talk Subject: Re: Resolving file name after upload Randy, Do I use that in my CFCONTENT. Currently i have select documents from taavon.submissions where lid = '#url.lid#' "Adkins, Randy" wrote: > > After the file is uploaded, you should be able to use: > #File.ServerFile# > > -Original Message- > From: James Taavon [mailto:[EMAIL PROTECTED]] > Sent: Friday, April 13, 2001 10:13 AM > To: CF-Talk > Subject: Resolving file name after upload > > After successfully uploading a file to the server I want to be able to > view from the web. Instead of storing the actual file name in the > database it stored a temporary name C:\WINNT\TEMP\ACF8.tmp. > > I am using a CFCONTENT tag which works great if do direct insert into > the database via SQL INSERT, but when using my CFFORM it uses this temp > name. What can I do to resolve this problem to get the actual fil name > in the database? > > Thanks! > > 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: File Download
Create a link to a .cfm page that uses the cfcontent tag to download the file. e.g Click here to download the file (put the filename.ext after the link to the .cfm -- this will make the browser default to the actual filename as opposed to download.cfm) download.cfm: - Original Message - From: "W. Shannon Carr" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, April 13, 2001 10:16 AM Subject: File Download > I am trying to give the user access to download files that are located on a > different hard drive than the webserver directory. I have used cfdirectory > in the past when files were located in the home web server directory. The > cffile would list all files and the user can click on file name which is a > link that will either open file in user's browser or prompt them to save > file to disk. > > My problem now is that the files are located on a different drive and the > url link will not get me out of the home directory to get file. Plus the > file list needs to be dynamically generated so user can select from list. > > I have tried a few custom tags but didn't have much luck. Any help would be > appreciated. > > Thanks, > Shannon > > > ~~ 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: lists Alphabetically
You also avoid all the looped queries and conditional code by writing 1 SQL query and grouping your cfoutput: SELECT lastname, firstname, LEFT(lastname, 1) AS letterindex FROM Directory_tbl ORDER BY letterindex, lastname, firstname #directory.letterindex# #directory.lastname#, #directory.firstname# Ian MacFadyen Sr. Application Developer Cardinal Communications http://www.cardinalweb.com [EMAIL PROTECTED] ph. 510.647.1400 x 210 -Original Message- From: Christine Kelley [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 12, 2001 10:28 AM To: CF-Talk Subject: lists Alphabetically Hi! How do I output a whole list of names from a query grouped alphabetically? Output example: A Allen, Bob Ames, John B Book, Sam Briant, Max I'm thinking it's by somehow using the group attribute of the tag or looping through the query, but I'm not sure exactly how to get these results. Thank-you for any help! Christine ~~ 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
CFFILE-WRITE
Hi all, I am using . I'd like to put coldfusion tags which include struct and array variables and cfloop to the OUTPUT as content. anyone know how to do this? please help, thank you in advance! ~~ 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: Insert query? - nevermind
That is why I said cfinsert enhancement not cfquery enhancement... jon - Original Message - From: "Hayes, David" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, April 12, 2001 5:57 PM Subject: RE: Insert query? - nevermind > This is analogous to the periodic "can I use javascript to set my cf > variables?" post - your CF object and your database are in different > "places". The CF Query Object isn't going to be recognized by your database > application. > > The tables don't have to be the same to use an INSERT...SELECT statement; > you specify which fields you want to use, and transform the data as needed > in the select statement. > > You'll have to create multiple insert statements, whether you do it in CF or > do it in a stored procedure; if you have a large number of records to > insert, you could output your Query Object to a formatted text file and > import directly into your db using a manual or automated process. > > -Original Message- > From: Jon Hall [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 12, 2001 3:35 PM > To: CF-Talk > Subject: Re: Insert query? - nevermind > > > I just remembered I asked this question some time ago, and the answer was > no. I would really love to be able do this though... > cfinsert enhancement perhaps? Any technical reasons why this could not be > done? > > jon > - Original Message - > From: "Jon Hall" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, April 12, 2001 4:30 PM > Subject: Insert query? > > > > I know it's possible to Insert a Select statement if the tables are > exactly > > the same, however is it possible to insert a CF queryset? Something > like... > > > > INSERT INTO Table(Columns,...) > > #GeneratedQuery# > > > > > > jon > > > ~~ 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: Multiple CFFile
Try naming your queries and referencing your results as #queryname.var#. Jeff Garza Web Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Alan Koenig [mailto:[EMAIL PROTECTED]] Sent: Friday, April 13, 2001 1:00 AM To: CF-Talk Subject: Multiple CFFile I have 4 cffiles set up on one form page. The first cffile uploads to the proper location and also inserts into the db however the other 3 do not get the proper information. My code looks like this. UPDATE ProdPics SET ItemPicLB = '#ItemPicLB#' WHERE #ItemID# = PicID UPDATE ProdPics Set ItemPicF = '#ItemPicF#' WHERE #ItemID# = PicID UPDATE ProdPics Set ItemPicB = '#ItemPicB#' WHERE #ItemID# = PicID TIA Alan ~~ 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-WRITE
Hopefully I am on the same sheet of what you are asking: Since the Output will be changing as the struct and array information changes, you can place output tags as an outer loop Is this what you are asking for??? -Original Message- From: Chang Liu [mailto:[EMAIL PROTECTED]] Sent: Friday, April 13, 2001 11:14 AM To: CF-Talk Subject: CFFILE-WRITE Hi all, I am using . I'd like to put coldfusion tags which include struct and array variables and cfloop to the OUTPUT as content. anyone know how to do this? please help, thank you in advance! ~~ 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 Download
Or for an even neater URL... Download download.cfm > Create a link to a .cfm page that uses the cfcontent tag to download the > file. > > e.g Click here to > download the file > (put the filename.ext after the link to the .cfm -- this will make the > browser default to the actual filename as opposed to download.cfm) > > download.cfm: > > > > - Original Message - > From: "W. Shannon Carr" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, April 13, 2001 10:16 AM > Subject: File Download > > > > I am trying to give the user access to download files that are located on > a > > different hard drive than the webserver directory. I have used cfdirectory > > in the past when files were located in the home web server directory. The > > cffile would list all files and the user can click on file name which is a > > link that will either open file in user's browser or prompt them to save > > file to disk. > > > > My problem now is that the files are located on a different drive and the > > url link will not get me out of the home directory to get file. Plus the > > file list needs to be dynamically generated so user can select from list. > > > > I have tried a few custom tags but didn't have much luck. Any help would > be > > appreciated. > > > > Thanks, > > Shannon > > > > > > > ~~ 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-WRITE
sorry, i didn't make it clear. this is my tag: thanks! - Original Message - From: "Adkins, Randy" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, April 13, 2001 11:13 AM Subject: RE: CFFILE-WRITE > Hopefully I am on the same sheet of what you are asking: > > Since the Output will be changing as the struct and array > information changes, you can place output tags as an > outer loop > > > > > output="#myoutput#"> > > > > Is this what you are asking for??? > > > > -Original Message- > From: Chang Liu [mailto:[EMAIL PROTECTED]] > Sent: Friday, April 13, 2001 11:14 AM > To: CF-Talk > Subject: CFFILE-WRITE > > > Hi all, > > I am using . > > I'd like to put coldfusion tags which include struct and array variables and > cfloop to the OUTPUT as content. > > anyone know how to do this? > > please help, thank you in advance! > ~~ 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: Resolving file name after upload -- Thanks!
Randy, Thanks, works now. James "Adkins, Randy" wrote: > > James, > > When the information is stored into the database > ( DOCUMENTS ) check the variable named used > with in the insert > > There is where you want to use #File.ServerFile#. > > Then yes, your content would use the variable > that you pull from the docs query. > > *** Note the name in the Select Line must be the same > in the CONTENT File name. > > Example: > > select documents > from taavon.submissions > where lid = '#url.lid#' > > > file="c:\inetpub\wwwroot\Intranet-Secure\lsar_new\pdf\#docs.documents#"> > > -Original Message- > From: James Taavon [mailto:[EMAIL PROTECTED]] > Sent: Friday, April 13, 2001 10:44 AM > To: CF-Talk > Subject: Re: Resolving file name after upload > > Randy, > > Do I use that in my CFCONTENT. Currently i have > > > select documents from taavon.submissions > where lid = '#url.lid#' > > > file="c:\inetpub\wwwroot\Intranet-Secure\lsar_new\pdf\#docs.name#"> > > "Adkins, Randy" wrote: > > > > After the file is uploaded, you should be able to use: > > #File.ServerFile# > > > > -Original Message- > > From: James Taavon [mailto:[EMAIL PROTECTED]] > > Sent: Friday, April 13, 2001 10:13 AM > > To: CF-Talk > > Subject: Resolving file name after upload > > > > After successfully uploading a file to the server I want to be able to > > view from the web. Instead of storing the actual file name in the > > database it stored a temporary name C:\WINNT\TEMP\ACF8.tmp. > > > > I am using a CFCONTENT tag which works great if do direct insert into > > the database via SQL INSERT, but when using my CFFORM it uses this temp > > name. What can I do to resolve this problem to get the actual fil name > > in the database? > > > > Thanks! > > > > 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: CFFILE-WRITE
Are you building a page that will contain something like: SELECT * FROM myTable #THIS.MyField# "> OR something like: -Original Message- From: Chang Liu [mailto:[EMAIL PROTECTED]] Sent: Friday, April 13, 2001 11:34 AM To: CF-Talk Subject: Re: CFFILE-WRITE sorry, i didn't make it clear. this is my tag: thanks! - Original Message - From: "Adkins, Randy" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, April 13, 2001 11:13 AM Subject: RE: CFFILE-WRITE > Hopefully I am on the same sheet of what you are asking: > > Since the Output will be changing as the struct and array > information changes, you can place output tags as an > outer loop > > > > > output="#myoutput#"> > > > > Is this what you are asking for??? > > > > -Original Message- > From: Chang Liu [mailto:[EMAIL PROTECTED]] > Sent: Friday, April 13, 2001 11:14 AM > To: CF-Talk > Subject: CFFILE-WRITE > > > Hi all, > > I am using . > > I'd like to put coldfusion tags which include struct and array variables and > cfloop to the OUTPUT as content. > > anyone know how to do this? > > please help, thank you in advance! > ~~ 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
Unsubscribe
Please unsubscribe me from the CF-Talk list. I have attempted to unsubscribe several times via the website, but to no avail. Christopher McGuckin ~~ 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
cfid/cftoken
does cfid relate to the application and cftoken relate to the individual user? or does each user get one urltoken variable (cfid+cftoken) and that is their identity for all applications on that server? what about if they're using multiple cf servers? does cfid relate to the id of that server? or would the domain of the cookie handle that? - Ken Beard Manager, Application Development Stone Ground Solutions 5100 West Kennedy Blvd, Suite 430 Tampa FL 33602 813.387.1235 voice 866.767.4051 toll free 813.387.1237 fax www.stoneground.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
Database Normalization?
my task is to take a massive localguide database and try to normalize the database currently consist of fields like: company information category main category other subscategory subscategory other list areaoftown an example of category main might restaurant and category other as nightclub subscatergory might be chinese and subscatgoryother as italian list might be wedding and areaoftown could be carytown so all together it is a restaurant which is also a club that serves chinese and italian that caters for weddings and is located in carytown choices seperate each category main into seperate tables so i would restaurant, clubs, golf course, etc. my options are seperating each table out and doing some crazy queries and inserts. or making a categories table and a company table and a table that houses category id and company id. or is there a another option that i'm overlooking the reason for the change is that the database is being pounded around 12 and 5 each day because of queries for restaurants please help metzy ~~ 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
Now error
I have the code in a development environment and a test environment. The development works fine but the test produces this error. It is WinNT 4.0 SP6 with CF 4.5.1 SP2 on both machines. Any ideas? TIA, Cami Error Occurred While Processing Request Error Diagnostic Information An error occurred while evaluating the expression: #DateDiff("d", myclosed[Counter][8], now())# LT 15 Error near line 190, column 52. Parameter 2 of function DateDiff which is now "" must be a date/time value The error occurred while processing an element with a general identifier of (CFIF), occupying document position (190:2) to (190:58). ~~ 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-WRITE
yeah, exactly! but my outputinfo is: #cart[i][2]# #cart[i][4]# #cart[i][5]# #dollarformat(cart[i][3])# "> any ideas? the error message seemed like cffile couldn't transfer variables and cfloop to text file. thanks again! - Original Message - From: "Adkins, Randy" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, April 13, 2001 11:42 AM Subject: RE: CFFILE-WRITE > Are you building a page that will contain something like: > > SELECT * FROM > myTable > #THIS.MyField# > "> > > > > > OR something like: > > > > > > -Original Message- > From: Chang Liu [mailto:[EMAIL PROTECTED]] > Sent: Friday, April 13, 2001 11:34 AM > To: CF-Talk > Subject: Re: CFFILE-WRITE > > > sorry, i didn't make it clear. > > this is my tag: > ouputBody=" > > i want to put struct and array variables and cfloop here > > "> > > > > thanks! > > - Original Message - > From: "Adkins, Randy" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, April 13, 2001 11:13 AM > Subject: RE: CFFILE-WRITE > > > > Hopefully I am on the same sheet of what you are asking: > > > > Since the Output will be changing as the struct and array > > information changes, you can place output tags as an > > outer loop > > > > > > > > > > > output="#myoutput#"> > > > > > > > > Is this what you are asking for??? > > > > > > > > -Original Message- > > From: Chang Liu [mailto:[EMAIL PROTECTED]] > > Sent: Friday, April 13, 2001 11:14 AM > > To: CF-Talk > > Subject: CFFILE-WRITE > > > > > > Hi all, > > > > I am using . > > > > I'd like to put coldfusion tags which include struct and array variables > and > > cfloop to the OUTPUT as content. > > > > anyone know how to do this? > > > > please help, thank you in advance! > > > ~~ 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: Unsubscribe
Chris, For some reason, the functionality on the site tells you that you need to reply to the email to get it to work. However, the email that is sent to you doesn't give you any indication of this. I've had the same problem many times and it's very aggravating. Jason - Original Message - From: "McGuckin, Chris" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, April 13, 2001 8:47 AM Subject: Unsubscribe > Please unsubscribe me from the CF-Talk list. I have attempted to > unsubscribe several times via the website, but to no avail. > > Christopher McGuckin > > > > > ~~ 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: Now error
It is not now() that is the problem. It is the value of myclosed[Counter][8] that is returning "". DC - Original Message - From: "Cami Lawson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, April 13, 2001 11:54 Subject: Now error > I have the code in a development environment and a test environment. The > development works fine but the test produces this error. It is WinNT 4.0 > SP6 with CF 4.5.1 SP2 on both machines. Any ideas? > > TIA, > Cami > > Error Occurred While Processing Request > Error Diagnostic Information > > An error occurred while evaluating the expression: > > > #DateDiff("d", myclosed[Counter][8], now())# LT 15 > > > > Error near line 190, column 52. > -- -- > > > Parameter 2 of function DateDiff which is now "" must be a date/time value > > > The error occurred while processing an element with a general identifier of > (CFIF), occupying document position (190:2) to (190:58). > > > > > ~~ 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: cfid/cftoken
Ken, The cfid is incremented by one per user for that particular server. The cftoken is a radomly generated number. By putting the two together you get a unique id that in theory is unique to each individual user, but I would not suggest trying to use that in a multiserver enviroment. I have seen problems in the past using a domain cookie to span multiple servers. I cluster that "sticks" an individual to a particular server once they have started there session is the best way to go, if possible. CW -Original Message- From: Ken Beard [mailto:[EMAIL PROTECTED]] Sent: Friday, April 13, 2001 1:52 PM To: CF-Talk Subject: cfid/cftoken does cfid relate to the application and cftoken relate to the individual user? or does each user get one urltoken variable (cfid+cftoken) and that is their identity for all applications on that server? what about if they're using multiple cf servers? does cfid relate to the id of that server? or would the domain of the cookie handle that? - Ken Beard Manager, Application Development Stone Ground Solutions 5100 West Kennedy Blvd, Suite 430 Tampa FL 33602 813.387.1235 voice 866.767.4051 toll free 813.387.1237 fax www.stoneground.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: Unsubscribe
The address [EMAIL PROTECTED] has been removed from the HoF lists. - Original Message - From: "McGuckin, Chris" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, April 13, 2001 11:47 AM Subject: Unsubscribe > Please unsubscribe me from the CF-Talk list. I have attempted to > unsubscribe several times via the website, but to no avail. > > Christopher McGuckin > > > > ~~ 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: Unsubscribe
The usual problem with people unsubscribing is that they are trying to remove an address other than the one subscribed. When this doesn't work, I get the emails directly. Then I just use the standard interface once they give me the right one. :) > Chris, > For some reason, the functionality on the site tells you that you need to > reply to the email to get it to work. However, the email that is sent to > you doesn't give you any indication of this. I've had the same problem many > times and it's very aggravating. > > Jason > > - Original Message - > From: "McGuckin, Chris" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, April 13, 2001 8:47 AM > Subject: Unsubscribe > > > > Please unsubscribe me from the CF-Talk list. I have attempted to > > unsubscribe several times via the website, but to no avail. > > > > Christopher McGuckin > > > > > > > > > > > ~~ 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
minihelp
i get the following error when i try to use the custom tag minihelp: Cannot find CFML template for custom tag MAX_ID. ColdFusion attempted looking in the tree of installed custom tags but did not find a custom tag with this name. The error occurred while processing an element with a general identifier of (CF_MAX_ID), occupying document position (20:5) to (23:20). am i supposed to also down load cf_max_id?? and do i just install this in the custom tags directory? * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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 Database
This has probably been covered before, but OH MY GOD, CASSADY YOU'RE DA F***ING MAN! TALLYLIST REIGNS SUPREME. GREAT JOB!! I CAN DELETE ALL THOSE TEXT FILES I'VE BEEN SAVING NOW! Thanks- [EMAIL PROTECTED] >Date: Tue, 10 Apr 2001 12:00:37 -0600 >From: "cassady " <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Cc: <[EMAIL PROTECTED]> >Subject: RE: CF-Talk Database >Message-ID: <[EMAIL PROTECTED]> > >Jason, >I believe last November I did what you're talking about. Drop me a line >[EMAIL PROTECTED], after checking out the site: > >Tallylist >http://www.tallylist.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re[2]: Re:Runtime session var error.
It is more than possible that the update is knocking out the value. Try re-setting it AFTER the update. Carol L. Bluestein Senior Programmer NYS Office of Real Property 518-486-6335 [EMAIL PROTECTED] Reply Separator Subject:Re: Re:Runtime session var error. Author: [EMAIL PROTECTED] Date: 4/11/01 2:14 PM I've added a cfparam to deal with that in Application.cfm but I'm still going to encounter the problem when I do an update query further down the page which uses the password field. I still want to try and figure out why it seems to have disappeared "Carol Bluestein" <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>... > It would seem to me, that if the program is not finding session.password, that > you might use cfparam to set it (so it will always be there) and check your code > for a structClear(session) or structDelete command -- you may have inadvertantly > cleared the session.password variable. > > Carol L. Bluestein > Senior Programmer > NYS Office of Real Property > 518-486-6335 > [EMAIL PROTECTED] > > > Reply Separator > Subject:Runtime session var error. > Author: [EMAIL PROTECTED] > Date: 4/11/01 1:11 PM > > Hi all, > > I have a really annoying intermittent problem out on a customer's live site > where they submit a form and they get an error that says that a session var > is nonexistent. This is a real pain because I can't reproduce the problem > on either the customer's website or my development box. Only some of the > customer's users have a problem , I checked the DB and saw that a good > number of people have submitted without problems. > > I had an issue last night where session vars were lost because the CF cookie > wasn't written because I had done some CFLOCATION's in the login handler > page which was also the very first of the app. I replaced all of these with > JavaScript redirects and it worked fine. > > This login page directs the user to a survey form which then posts to an > action page. > The action page is the page that reports non-existent session vars. I know > that the survey form can get at the session vars because I use some as > hidden vars. > > Only one application.cfm page, and there are no cflocation tags on the form > page. > I've configured an error handler to email me details for any error on the > action page. > I've modifed the error handler to send me a dump of all form and session > vars the next time an error occurs. > > Any ideas? The customer is about to have a hemorrhage. > > Thanks a million Kev > > See error email below. > Error occured at: 11-Apr-01 > > Location: 128.2.88.201 > Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) > Referer: http://www.hillgroupinc.com/surveys/vng/Survey_Form.cfm > Username: > > Message: An error occurred while evaluating the expression: > session.username is "vng1001" and session.password is "vng" > Error near line 9, column 37.Error resolving parameter > SESSION.PASSWORDThe session variable PASSWORD does not exist. > The cause of this error is very likely one of the following > things:The name of the session variable has been > misspelled.The session variable has not yet been created.The session > variable has timed out. > Exception Type: EXPRESSION > Specific Details on Exception Type Expression: > ErrNumber: 16396 > > > > General Details: > > No Detail available. > > Kevin Gilchrist > Senior Consultant > RedSiren Technologies Inc. > (412) 281 4427 ext 466 > ~~ 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: Now error
nevermind, it was a difference in db -Original Message- From: David E. Crawford [mailto:[EMAIL PROTECTED]] Sent: Friday, April 13, 2001 11:03 AM To: CF-Talk Subject: Re: Now error It is not now() that is the problem. It is the value of myclosed[Counter][8] that is returning "". DC - Original Message - From: "Cami Lawson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, April 13, 2001 11:54 Subject: Now error > I have the code in a development environment and a test environment. The > development works fine but the test produces this error. It is WinNT 4.0 > SP6 with CF 4.5.1 SP2 on both machines. Any ideas? > > TIA, > Cami > > Error Occurred While Processing Request > Error Diagnostic Information > > An error occurred while evaluating the expression: > > > #DateDiff("d", myclosed[Counter][8], now())# LT 15 > > > > Error near line 190, column 52. > -- -- > > > Parameter 2 of function DateDiff which is now "" must be a date/time value > > > The error occurred while processing an element with a general identifier of > (CFIF), occupying document position (190:2) to (190:58). > > > > > ~~ 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-WRITE
You have to remember that with CF it reads the # signs as part of a variable thus you would get the error similar to variable not defined or something similar to the required # was not defined to close the variable. Since your VARIABLE OUTPUTINFO would actually be: It interrepurts the " " as the closing of the CFFILE tag and there was no close #. My suggestion is to try to run a replace on the variable prior to putting it to the CFFILE. Replace the < with < and > with > and as well as the # with ASC(35) I think it is. and the " as " once you want to read the entire CF Code as it is written, you can se the Evaluate() function. -Original Message- From: Chang Liu [mailto:[EMAIL PROTECTED]] Sent: Friday, April 13, 2001 12:06 PM To: CF-Talk Subject: Re: CFFILE-WRITE yeah, exactly! but my outputinfo is: #cart[i][2]# #cart[i][4]# #cart[i][5]# #dollarformat(cart[i][3])# "> any ideas? the error message seemed like cffile couldn't transfer variables and cfloop to text file. thanks again! - Original Message - From: "Adkins, Randy" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, April 13, 2001 11:42 AM Subject: RE: CFFILE-WRITE > Are you building a page that will contain something like: > > SELECT * FROM > myTable > #THIS.MyField# > "> > > > > > OR something like: > > > > > > -Original Message- > From: Chang Liu [mailto:[EMAIL PROTECTED]] > Sent: Friday, April 13, 2001 11:34 AM > To: CF-Talk > Subject: Re: CFFILE-WRITE > > > sorry, i didn't make it clear. > > this is my tag: > ouputBody=" > > i want to put struct and array variables and cfloop here > > "> > > > > thanks! > > - Original Message - > From: "Adkins, Randy" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, April 13, 2001 11:13 AM > Subject: RE: CFFILE-WRITE > > > > Hopefully I am on the same sheet of what you are asking: > > > > Since the Output will be changing as the struct and array > > information changes, you can place output tags as an > > outer loop > > > > > > > > > > > output="#myoutput#"> > > > > > > > > Is this what you are asking for??? > > > > > > > > -Original Message- > > From: Chang Liu [mailto:[EMAIL PROTECTED]] > > Sent: Friday, April 13, 2001 11:14 AM > > To: CF-Talk > > Subject: CFFILE-WRITE > > > > > > Hi all, > > > > I am using . > > > > I'd like to put coldfusion tags which include struct and array variables > and > > cfloop to the OUTPUT as content. > > > > anyone know how to do this? > > > > please help, thank you in advance! > > > ~~ 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: Now error
I may be off here, but you may wish to make sure the version of MDAC is the same on both machines - I've had trouble with formatting dates before, and it seemed to be an odbc thing... HTH, Andrew Peterson - Original Message - From: Cami Lawson <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Sent: Friday, April 13, 2001 10:54 AM Subject: Now error > I have the code in a development environment and a test environment. The > development works fine but the test produces this error. It is WinNT 4.0 > SP6 with CF 4.5.1 SP2 on both machines. Any ideas? > > TIA, > Cami > > Error Occurred While Processing Request > Error Diagnostic Information > > An error occurred while evaluating the expression: > > > #DateDiff("d", myclosed[Counter][8], now())# LT 15 > > > > Error near line 190, column 52. > -- -- > > > Parameter 2 of function DateDiff which is now "" must be a date/time value > > > The error occurred while processing an element with a general identifier of > (CFIF), occupying document position (190:2) to (190:58). > > > > > ~~ 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
SQL and reserved characters
A fellow developer asked me a question as to the best method to insert reserved characters into a SQL Server DB. I've done this through my different vices in many ways, however I would like to hear how other developers are handling this common issue. Here is an example for illustration: Insert the following text into a Varchar db column named "Quote" in a Table named "Tools" Jeremy said "Allaire's ColdFusion is a wonderful tool for developers." The key issues I am looking to tackle are the ' and " qoutes in the sentence above and how they would be inserted and retreived from a DB. Thanks in advance for your comments. - Steven Johnson --- Webmaster - HealthObjects [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 Download
Thank you for your help. I wasn't aware of the cfcontent tag but will be sure to add a new snippet. Thanks again, Shannon - Original Message - From: "Tim Painter" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, April 13, 2001 10:57 AM Subject: Re: File Download > Create a link to a .cfm page that uses the cfcontent tag to download the > file. > > e.g Click here to > download the file > (put the filename.ext after the link to the .cfm -- this will make the > browser default to the actual filename as opposed to download.cfm) > > download.cfm: > > > > - Original Message - > From: "W. Shannon Carr" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, April 13, 2001 10:16 AM > Subject: File Download > > > > I am trying to give the user access to download files that are located on > a > > different hard drive than the webserver directory. I have used cfdirectory > > in the past when files were located in the home web server directory. The > > cffile would list all files and the user can click on file name which is a > > link that will either open file in user's browser or prompt them to save > > file to disk. > > > > My problem now is that the files are located on a different drive and the > > url link will not get me out of the home directory to get file. Plus the > > file list needs to be dynamically generated so user can select from list. > > > > I have tried a few custom tags but didn't have much luck. Any help would > be > > appreciated. > > > > Thanks, > > Shannon > > > > > > > > ~~ 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
User Name and Password Routine
All, Hey all, im glad I found this list, it seems to be a valuable resource. I'm currently creating a user name and password routine that interfaces with a access database. Does anyone have any experience with this or can anyone point me in a good direction to get started? Thanks, Sean Sean Percival Owner Paragon Matrix - Web and Graphic Design 877.498.6072 - phone [EMAIL PROTECTED] - email [EMAIL PROTECTED] - wireless email www.paragonmatrix.com - web ~~ 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: User Name and Password Routine
Sean, That is a very open ended question. There are many ways to setup access control using db variables. You would have to divulge a little more information about your security schema and business needs. ie: - will you have multiple layers of access control or just one level of validation? - is this for an existing site (where you cannot restructure) or are you planning a new site where you can control directory structure? Any additional information will help get a thread going. :-) Tony Gruen -Original Message- From: Sean Percival [mailto:[EMAIL PROTECTED]] Sent: Friday, April 13, 2001 10:39 AM To: CF-Talk Subject: User Name and Password Routine All, Hey all, im glad I found this list, it seems to be a valuable resource. I'm currently creating a user name and password routine that interfaces with a access database. Does anyone have any experience with this or can anyone point me in a good direction to get started? Thanks, Sean Sean Percival Owner Paragon Matrix - Web and Graphic Design 877.498.6072 - phone [EMAIL PROTECTED] - email [EMAIL PROTECTED] - wireless email www.paragonmatrix.com - web ~~ 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-WRITE
use cf_bodycontent. you can find it on the fusebox.org site. stuff At 11:42 AM 4/13/01 -0400, you wrote: >Are you building a page that will contain something like: > >SELECT * FROM >myTable > #THIS.MyField# > "> > > > > >OR something like: > > > > > >-Original Message- >From: Chang Liu [mailto:[EMAIL PROTECTED]] >Sent: Friday, April 13, 2001 11:34 AM >To: CF-Talk >Subject: Re: CFFILE-WRITE > > >sorry, i didn't make it clear. > >this is my tag: >ouputBody=" > >i want to put struct and array variables and cfloop here > >"> > > > >thanks! > >- Original Message - >From: "Adkins, Randy" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Friday, April 13, 2001 11:13 AM >Subject: RE: CFFILE-WRITE > > > > Hopefully I am on the same sheet of what you are asking: > > > > Since the Output will be changing as the struct and array > > information changes, you can place output tags as an > > outer loop > > > > > > > > > > > output="#myoutput#"> > > > > > > > > Is this what you are asking for??? > > > > > > > > -Original Message- > > From: Chang Liu [mailto:[EMAIL PROTECTED]] > > Sent: Friday, April 13, 2001 11:14 AM > > To: CF-Talk > > Subject: CFFILE-WRITE > > > > > > Hi all, > > > > I am using . > > > > I'd like to put coldfusion tags which include struct and array variables >and > > cfloop to the OUTPUT as content. > > > > anyone know how to do this? > > > > please help, thank you in advance! > > > ~~ 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-WRITE
maybe not because of this reason. except struct and array variable and cfloop, the code worked well. for example: - Original Message - From: "Adkins, Randy" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, April 13, 2001 1:02 PM Subject: RE: CFFILE-WRITE > You have to remember that with CF it reads > the # signs as part of a variable thus you > would get the error similar to variable not > defined or something similar to the required # > was not defined to close the variable. > Since your VARIABLE OUTPUTINFO would actually be: > > OUTPUT="THISPAGE > > tag and there was no close #. > > My suggestion is to try to run a replace on the variable > prior to putting it to the CFFILE. > > Replace the < with < and > with > > and as well as the # with ASC(35) I think it is. > > and the " as " once you want to read the > entire CF Code as it is written, > > you can se the Evaluate() function. > > > -Original Message- > From: Chang Liu [mailto:[EMAIL PROTECTED]] > Sent: Friday, April 13, 2001 12:06 PM > To: CF-Talk > Subject: Re: CFFILE-WRITE > > > yeah, exactly! > > but my outputinfo is: > > > > > #cart[i][2]# > #cart[i][4]# > #cart[i][5]# > #dollarformat(cart[i][3])# > > > > > "> > > > > any ideas? > the error message seemed like cffile couldn't transfer variables and cfloop > to text file. > > thanks again! > > > - Original Message - > From: "Adkins, Randy" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, April 13, 2001 11:42 AM > Subject: RE: CFFILE-WRITE > > > > Are you building a page that will contain something like: > > > > SELECT * FROM > > myTable > > #THIS.MyField# > > "> > > > > > > > > > > OR something like: > > > > > > > > > > > > -Original Message- > > From: Chang Liu [mailto:[EMAIL PROTECTED]] > > Sent: Friday, April 13, 2001 11:34 AM > > To: CF-Talk > > Subject: Re: CFFILE-WRITE > > > > > > sorry, i didn't make it clear. > > > > this is my tag: > > > ouputBody=" > > > > i want to put struct and array variables and cfloop here > > > > "> > > > > > > > > thanks! > > > > - Original Message - > > From: "Adkins, Randy" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Friday, April 13, 2001 11:13 AM > > Subject: RE: CFFILE-WRITE > > > > > > > Hopefully I am on the same sheet of what you are asking: > > > > > > Since the Output will be changing as the struct and array > > > information changes, you can place output tags as an > > > outer loop > > > > > > > > > > > > > > > > > output="#myoutput#"> > > > > > > > > > > > > Is this what you are asking for??? > > > > > > > > > > > > -Original Message- > > > From: Chang Liu [mailto:[EMAIL PROTECTED]] > > > Sent: Friday, April 13, 2001 11:14 AM > > > To: CF-Talk > > > Subject: CFFILE-WRITE > > > > > > > > > Hi all, > > > > > > I am using . > > > > > > I'd like to put coldfusion tags which include struct and array variables > > and > > > cfloop to the OUTPUT as content. > > > > > > anyone know how to do this? > > > > > > please help, thank you in advance! > > > > > > ~~ 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
T&E Form
Talk about the run around and different phone numbers to get a form mailed to you, whoa must be all them 14" monitors --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.248 / Virus Database: 121 - Release Date: 4/11/2001 ~~ 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: User Name and Password Routine
Agreed - security models vary tremendously. Sounds like you're just getting started though - I'd recommend checking out the CF_Login tag in the Dev Exchange for very basic protection (.cfm files only) to get started. >From there, as Tony said - if you can provide more info on the application/security structure you'd like to create, there are lots of resources here to help provide some direction and details. Truman -Original Message- From: Tony Gruen [mailto:[EMAIL PROTECTED]] Sent: Friday, April 13, 2001 12:06 PM To: CF-Talk Subject: RE: User Name and Password Routine Sean, That is a very open ended question. There are many ways to setup access control using db variables. You would have to divulge a little more information about your security schema and business needs. ie: - will you have multiple layers of access control or just one level of validation? - is this for an existing site (where you cannot restructure) or are you planning a new site where you can control directory structure? Any additional information will help get a thread going. :-) Tony Gruen -Original Message- From: Sean Percival [mailto:[EMAIL PROTECTED]] Sent: Friday, April 13, 2001 10:39 AM To: CF-Talk Subject: User Name and Password Routine All, Hey all, im glad I found this list, it seems to be a valuable resource. I'm currently creating a user name and password routine that interfaces with a access database. Does anyone have any experience with this or can anyone point me in a good direction to get started? Thanks, Sean Sean Percival Owner Paragon Matrix - Web and Graphic Design 877.498.6072 - phone [EMAIL PROTECTED] - email [EMAIL PROTECTED] - wireless email www.paragonmatrix.com - web ~~ 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: User Name and Password Routine
Sorry for the blank message. Well the security needs for the site are very minimal. It will just need to verify the user name within the access database and pass them along to another site for some computer based training ASP files. There will only be one level of access. Users will also have the ability to register if they are a new user. This is for an existing site although I am in the process of rebuilding the entire site. Thanks for you help! Sean -Original Message- From: Tony Gruen [mailto:[EMAIL PROTECTED]] Sent: Friday, April 13, 2001 11:06 AM To: CF-Talk Subject: RE: User Name and Password Routine Sean, That is a very open ended question. There are many ways to setup access control using db variables. You would have to divulge a little more information about your security schema and business needs. ie: - will you have multiple layers of access control or just one level of validation? - is this for an existing site (where you cannot restructure) or are you planning a new site where you can control directory structure? Any additional information will help get a thread going. :-) Tony Gruen -Original Message- From: Sean Percival [mailto:[EMAIL PROTECTED]] Sent: Friday, April 13, 2001 10:39 AM To: CF-Talk Subject: User Name and Password Routine All, Hey all, im glad I found this list, it seems to be a valuable resource. I'm currently creating a user name and password routine that interfaces with a access database. Does anyone have any experience with this or can anyone point me in a good direction to get started? Thanks, Sean Sean Percival Owner Paragon Matrix - Web and Graphic Design 877.498.6072 - phone [EMAIL PROTECTED] - email [EMAIL PROTECTED] - wireless email www.paragonmatrix.com - web ~~ 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: User Name and Password Routine
-Original Message- From: Tony Gruen [mailto:[EMAIL PROTECTED]] Sent: Friday, April 13, 2001 11:06 AM To: CF-Talk Subject: RE: User Name and Password Routine Sean, That is a very open ended question. There are many ways to setup access control using db variables. You would have to divulge a little more information about your security schema and business needs. ie: - will you have multiple layers of access control or just one level of validation? - is this for an existing site (where you cannot restructure) or are you planning a new site where you can control directory structure? Any additional information will help get a thread going. :-) Tony Gruen -Original Message- From: Sean Percival [mailto:[EMAIL PROTECTED]] Sent: Friday, April 13, 2001 10:39 AM To: CF-Talk Subject: User Name and Password Routine All, Hey all, im glad I found this list, it seems to be a valuable resource. I'm currently creating a user name and password routine that interfaces with a access database. Does anyone have any experience with this or can anyone point me in a good direction to get started? Thanks, Sean Sean Percival Owner Paragon Matrix - Web and Graphic Design 877.498.6072 - phone [EMAIL PROTECTED] - email [EMAIL PROTECTED] - wireless email www.paragonmatrix.com - web ~~ 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: User Name and Password Routine
Go to Chapter 17 of Sybex's Mastering Cold Fusion book to see the details explained; then, copy the code from the accompanying CD. Works great out of the box/book, including session management... ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 -Original Message- From: Sean Percival [SMTP:[EMAIL PROTECTED]] Sent: Friday, April 13, 2001 1:39 PM To: CF-Talk Subject:User Name and Password Routine All, Hey all, im glad I found this list, it seems to be a valuable resource. I'm currently creating a user name and password routine that interfaces with a access database. Does anyone have any experience with this or can anyone point me in a good direction to get started? Thanks, Sean Sean Percival Owner Paragon Matrix - Web and Graphic Design 877.498.6072 - phone [EMAIL PROTECTED] - email [EMAIL PROTECTED] - wireless email www.paragonmatrix.com - web ~~ 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
Extracting Meta tag info from a called page
I know I have seen something about this in the past but for the life of me cannot put my hands on it. I want to be able to extract just the meta info from a page when I call it. Can someone lead me in the right direction PLEASE. Thanks Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. ~~ 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
RDS through a Proxie
I seem to remember there being talk about a registry setting that could be added to allow the studio RDS to work through a proxie. Does anyone have this info off hand (if it exists)? 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
Dynamically Displayed Content Weekly?
Can anyone tell me where I could find out more regarding dynamically displaying text on a cfm page weekly? I know this can be done in ASP but wasn't sure if it was possible in cf. TIA, Dayv ~~ 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: RDS through a Proxie
> I seem to remember there being talk about a registry setting > that could be added to allow the studio RDS to work through > a proxie. Does anyone have this info off hand (if it exists)? You should be able to just set IE up to use the proxy, and set Studio to use IE as the integrated browser. 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
Re: RDS through a Proxie
Hm. I had tried that and it didn't work. Then I tried setting the 'use external config...' and it didn't work. When I turned that off and restarted studio it decided to work. Strange. > > I seem to remember there being talk about a registry setting > > that could be added to allow the studio RDS to work through > > a proxie. Does anyone have this info off hand (if it exists)? > > You should be able to just set IE up to use the proxy, and set Studio to use > IE as the integrated browser. > > 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
recieve a fax
I want to be able to receive a fax then db or email it, any suggestions? thanks Mike ~~ 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
Ouput in 2 colums of a table
How can I get the output from a query to line up side-by-side in 2 columns of a table? Like this: Example: 1 4 2 5 3 6 Also, can this be done dynamically, so if the list changes it will reorganize dynamically? For instance, if someone added 3 more entries, the output of the list above would automatically readjust to this: 1 6 2 7 3 8 4 9 5 Anyone done this before? Thanks, Mike ~~ 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: Ouput in 2 colums of a table
Tables inside of tables work great for this #number# -Original Message- From: WebMaster [mailto:[EMAIL PROTECTED]] Sent: Friday, April 13, 2001 3:21 PM To: CF-Talk Subject: Ouput in 2 colums of a table How can I get the output from a query to line up side-by-side in 2 columns of a table? Like this: Example: 1 4 2 5 3 6 Also, can this be done dynamically, so if the list changes it will reorganize dynamically? For instance, if someone added 3 more entries, the output of the list above would automatically readjust to this: 1 6 2 7 3 8 4 9 5 Anyone done this before? Thanks, Mike ~~ 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
Scanner Software
Does anyone know where I may be able to get a custom tag (or whatever) that will allow me to scan images directly into a browser that will work with ColdFusion? I have looked at the software cfdev.com offers and it is pretty good except that it will only scan to a .jpg image format and I need it to be able to scan to a ..tif format. Thanks, Kevin ~~ 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: Scanner Software
Best one out there is activescan from http://www.cfdev.com Steven A. del Sol Vendors Representative San Diego Cold Fusion User Group [EMAIL PROTECTED] At 04:13 PM 4/13/2001 -0600, you wrote: >Does anyone know where I may be able to get a custom tag (or whatever) >that will >allow me to scan images directly into a browser that will work with >ColdFusion? > >I have looked at the software cfdev.com offers and it is pretty good >except that >it will only scan to a .jpg image format and I need it to be able to scan to a >..tif format. > >Thanks, > >Kevin > > > > ~~ 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: Ouput in 2 colums of a table
There is a script here that will do it (set for "alphabetical" sorts, but would work with numbers with a tweak) I suppose the column names need changed too... http://cfhub.com/discussion/viewmessages.cfm?Forum=11&Topic=183 select distinct Category from YourTable Order By Category ASC non-breaking-space #GetCats.Category[ArrayIndex]# ~~ 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: Looking for CF code for building breadcrumbs
The tag gallery has cf_breadcrumb and cf_breadcrumbtrail. Do a search on "breadcrumb" at http://devex.allaire.com/developer/gallery/ -David On Friday, April 13, 2001 4:38 AM, Earl, George [SMTP:[EMAIL PROTECTED]] wrote: > Does anyone know of a source for a good example of using CF code to build a > breadcrumb navigation trail similar to what is shown for ASP in this evolt > article? > > http://www.evolt.org/article/Breadcrumbs_for_Those_Using_ASP/17/4438/index.h > tml ~~ 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: Registry size.
I agree, but the problem is what if there is a problem with the DSN and CF throws an error, then it would show the dsn name and at that point its all over! Ideas? Neil - Original Message - From: "Peter Tilbrook" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, April 11, 2001 2:43 AM Subject: RE: Registry size. > Just disable CF_Registry. It shouldn't be enabled unless you absolutely > trust your customers. > > -Original Message- > From: Bryan LaPlante [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, 11 April 2001 16:29 > To: CF-Talk > Subject: Re: Registry size. > > > I am jumping in here mid discussion but a couple of post back did you > mention a concern about using a datasource for storing client var's? I have > a question. If you use a DB for client var's, do the customers have any way > of knowing what you named the datasource? If you set the default in CF admin > to use DB for Client var's I would think the only thing you would be up > against is getting the customer to comply with a policy that asks them not > to purposely set Registry as the storage in their CFAPPLICATION tag. > > What -a- ya think? > > - Original Message - > From: "Neil H." <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, April 10, 2001 11:50 PM > Subject: Re: Registry size. > > > > You guys don't understand this is a hosting server so I don't set the > code. > > > > Understand now? > > > > Thanks, > > > > Neil > > > > - Original Message - > > From: "Scott, Andrew" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Monday, April 09, 2001 10:08 PM > > Subject: RE: Registry size. > > > > > > > Not if you follow the basic guidelines and user variables instead of > hard > > > coding this info, also to be 100% sure wrap these with cftry and have > your > > > own custom message!!! That should make it harder for anyone to second > > guess. > > > > > > > > > > > > -Original Message- > > > From: Neil H. [mailto:[EMAIL PROTECTED]] > > > Sent: 10 April 2001 12:01 > > > To: CF-Talk > > > Subject: Re: Registry size. > > > > > > > > > Jon, > > > If there is ever an error in the dsn won't the server throw the DSN > > > name. This would become a security issue since user X can query user > Y's > > > client info? > > > > > > Thanks, > > > > > > Neil > > > > > > - Original Message - > > > From: "Jon Hall" <[EMAIL PROTECTED]> > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > Sent: Monday, April 09, 2001 6:27 PM > > > Subject: Re: Registry size. > > > > > > > > > > Changing the client variables to be stored in a database is one of the > > > first > > > > things I do on a new server. Using an Access database is much better > > than > > > > the registry. SQL Server or any other real rdbms is even better. > > > > > > > > jon > > > > - Original Message - > > > > From: "Neil H." <[EMAIL PROTECTED]> > > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > > Sent: Monday, April 09, 2001 5:58 PM > > > > Subject: Re: Registry size. > > > > > > > > > > > > > I host several sites with people and some really sloppy code. Does > > > using > > > > a > > > > > MDB have any ramifications. Also won't people be able to manipulate > > > this > > > > > database?! They can't manipulate the registry since it is locked > > there > > > is > > > > > no CFregistry. > > > > > > > > > > Thanks, > > > > > > > > > > Neil > > > > > > > > > > - Original Message - > > > > > From: "Arden Weiss" <[EMAIL PROTECTED]> > > > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > > > Sent: Tuesday, March 27, 2001 9:59 PM > > > > > Subject: RE: Registry size. > > > > > > > > > > > > > > > > Time to move your client variables to ODBC source, etc... to avoid > > > > > CrAsHiTiSe. > > > > > > > > > > > > ^ > > > > > > / \__ > > > > > >(@\___ > > > > > > / O > > > > > > /(_/ > > > > > > /_/ > > > > > > Whoof... > > > > > > 410-757-3487 > > > > > > > > > > > > -Original Message- > > > > > > From: Neil H. [SMTP:[EMAIL PROTECTED]] > > > > > > Sent: Tuesday, March 27, 2001 7:47 PM > > > > > > To: CF-Talk > > > > > > Subject: Registry size. > > > > > > > > > > > > I noticed my registry is getting huge (128 megs) and that I > > increased > > > it > > > > > to > > > > > > 160 megs for space sakes but are the entries in there that I can > > > remove > > > > > from > > > > > > CF not collecting garbage? > > > > > > > > > > > > Thanks, > > > > > > > > > > > > Neil > > > > > > > > > > > > > > > > > > > > > ~~ 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: Registry size.
Yeah, just use proper error control. You should never have detailed error info showing on a production server. In the admin under the debugging section disable anything that gives info and/or proper use of cferror and cftry/cfcatch will remove anything other than "friendly" error messages you define. -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: April 13, 2001 19:02 To: CF-Talk Subject: Re: Registry size. I agree, but the problem is what if there is a problem with the DSN and CF throws an error, then it would show the dsn name and at that point its all over! Ideas? Neil - Original Message - From: "Peter Tilbrook" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, April 11, 2001 2:43 AM Subject: RE: Registry size. > Just disable CF_Registry. It shouldn't be enabled unless you absolutely > trust your customers. > > -Original Message- > From: Bryan LaPlante [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, 11 April 2001 16:29 > To: CF-Talk > Subject: Re: Registry size. > > > I am jumping in here mid discussion but a couple of post back did you > mention a concern about using a datasource for storing client var's? I have > a question. If you use a DB for client var's, do the customers have any way > of knowing what you named the datasource? If you set the default in CF admin > to use DB for Client var's I would think the only thing you would be up > against is getting the customer to comply with a policy that asks them not > to purposely set Registry as the storage in their CFAPPLICATION tag. > > What -a- ya think? > > - Original Message - > From: "Neil H." <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, April 10, 2001 11:50 PM > Subject: Re: Registry size. > > > > You guys don't understand this is a hosting server so I don't set the > code. > > > > Understand now? > > > > Thanks, > > > > Neil > > > > - Original Message - > > From: "Scott, Andrew" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Monday, April 09, 2001 10:08 PM > > Subject: RE: Registry size. > > > > > > > Not if you follow the basic guidelines and user variables instead of > hard > > > coding this info, also to be 100% sure wrap these with cftry and have > your > > > own custom message!!! That should make it harder for anyone to second > > guess. > > > > > > > > > > > > -Original Message- > > > From: Neil H. [mailto:[EMAIL PROTECTED]] > > > Sent: 10 April 2001 12:01 > > > To: CF-Talk > > > Subject: Re: Registry size. > > > > > > > > > Jon, > > > If there is ever an error in the dsn won't the server throw the DSN > > > name. This would become a security issue since user X can query user > Y's > > > client info? > > > > > > Thanks, > > > > > > Neil > > > > > > - Original Message - > > > From: "Jon Hall" <[EMAIL PROTECTED]> > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > Sent: Monday, April 09, 2001 6:27 PM > > > Subject: Re: Registry size. > > > > > > > > > > Changing the client variables to be stored in a database is one of the > > > first > > > > things I do on a new server. Using an Access database is much better > > than > > > > the registry. SQL Server or any other real rdbms is even better. > > > > > > > > jon > > > > - Original Message - > > > > From: "Neil H." <[EMAIL PROTECTED]> > > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > > Sent: Monday, April 09, 2001 5:58 PM > > > > Subject: Re: Registry size. > > > > > > > > > > > > > I host several sites with people and some really sloppy code. Does > > > using > > > > a > > > > > MDB have any ramifications. Also won't people be able to manipulate > > > this > > > > > database?! They can't manipulate the registry since it is locked > > there > > > is > > > > > no CFregistry. > > > > > > > > > > Thanks, > > > > > > > > > > Neil > > > > > > > > > > - Original Message - > > > > > From: "Arden Weiss" <[EMAIL PROTECTED]> > > > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > > > Sent: Tuesday, March 27, 2001 9:59 PM > > > > > Subject: RE: Registry size. > > > > > > > > > > > > > > > > Time to move your client variables to ODBC source, etc... to avoid > > > > > CrAsHiTiSe. > > > > > > > > > > > > ^ > > > > > > / \__ > > > > > >(@\___ > > > > > > / O > > > > > > /(_/ > > > > > > /_/ > > > > > > Whoof... > > > > > > 410-757-3487 > > > > > > > > > > > > -Original Message- > > > > > > From: Neil H. [SMTP:[EMAIL PROTECTED]] > > > > > > Sent: Tuesday, March 27, 2001 7:47 PM > > > > > > To: CF-Talk > > > > > > Subject: Registry size. > > > > > > > > > > > > I noticed my registry is getting huge (128 megs) and that I > > increased > > > it > > > > > to > > > > > > 160 megs for space sakes but are the entries in there that I can > > > remove > > > > > from > > > > > > CF not collecting garbage? > > > > > > > > > > > > Thanks, > > > > > > > > > > > > Neil > > > > > > > > > > > > > > > > > > > > > ~~
CF-Talk-list V1 #271
--[This is an automatically generated email notification.]-- V I R U S A L E R T ! You recently sent a message containing a known virus. The message was sent on 4/13/01 10:48:10 PM. The subject of the message was: "CF-Talk-list V1 #271" The message was sent to the following recipient(s): [EMAIL PROTECTED], [EMAIL PROTECTED] One or more of the recipients listed is a Small Dog Design client. As a result, their copy of the message has been quarantined in a special confinement area and can only be released by their system administrator. This message is only meant to serve as a notification that your message was not delivered to all of the designated recipients. No action is required on your part. Please note, however, that the detection of a virus in a message you sent may be an indication that your computer system has already been compromised by a virus. To obtain detailed information about wh Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Unsubscribe
Make sure that the email address you use to unsubscribe is the same as the one you subscribed with. When most folks have trouble, it's when they've changed email addresses since they subscribed last, and the system is forwarding their old address. We had that problem here a lot when we went to the new mail system. For example, my address went from [EMAIL PROTECTED] to [EMAIL PROTECTED] But, the old address still gets my mail to me. Dave - Original Message - From: Jason Lotz <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Sent: Friday, April 13, 2001 12:01 PM Subject: Re: Unsubscribe > Chris, > For some reason, the functionality on the site tells you that you need to > reply to the email to get it to work. However, the email that is sent to > you doesn't give you any indication of this. I've had the same problem many > times and it's very aggravating. > > Jason > > - Original Message - > From: "McGuckin, Chris" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, April 13, 2001 8:47 AM > Subject: Unsubscribe > > > > Please unsubscribe me from the CF-Talk list. I have attempted to > > unsubscribe several times via the website, but to no avail. > > > > Christopher McGuckin > > > > > > > > > > > ~~ 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
Query string not appear
Hallo, How can i use query string, but not appear in url? 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