Outputting Structure Key Problem
The following code below can be seen at http://www.tcmtests.com/files/codetest.cfm When I try append the following code to it I get an error that the variable Sleep is not defined cfouput#Score.Sleep#/cfoutput How can I output the structure key value that I want? --- cfquery name=GetAverages select AVG(QuizPercent) as AvgPercent, QuizIDfrom test_board_biomed GROUP BY QuizID /cfquery cfdump var=#GetAverages# label=new cfset Score = StructNew() cfoutput query=GetAverages cfset Result = StructInsert(Score,QuizID,AvgPercent) /cfoutput cfoutputCount: #StructCount(Score)#/cfoutput cfloop collection=#score# item=x cfoutput#x# #Score[x]#/cfoutputbr /cfloop [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RDS error
I'm trying to set up an RDS connection to a remote server and am getting an error message that says 'Remote Server Operation Failed - HTTP Error:404' Any clues on resolving this? Sebastian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: RDS error
No Firewalls. on 6/28/03 11:05 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: Any firewalls between you and the remote server? That's the first place to look. -Novak - Original Message - From: sebastian palmigiani [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, June 28, 2003 9:00 PM Subject: RDS error I'm trying to set up an RDS connection to a remote server and am getting an error message that says 'Remote Server Operation Failed - HTTP Error:404' Any clues on resolving this? Sebastian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: RDS error
Well, here is another clue: The browser is launched and the URL says: http://www.siddhayogachicago.org/CFIDE/administrator/index.cfm I don't know where that is coming from. I am using HomeSite+. Do I need to put anything in the Remote Development mapping for this remote server for 'HomeSite+Path' 'Server Path' and 'Browser Path' as I did for the localhost? Sebastian on 6/28/03 11:05 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: Any firewalls between you and the remote server? That's the first place to look. -Novak - Original Message - From: sebastian palmigiani [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, June 28, 2003 9:00 PM Subject: RDS error I'm trying to set up an RDS connection to a remote server and am getting an error message that says 'Remote Server Operation Failed - HTTP Error:404' Any clues on resolving this? Sebastian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
security and browser cached pages
Access to a browser cached page from a password protected site can be accessed by anyone using the same machine using the back button on the browser and see those pages even if they're not logged into the site. Is there some code that will expire the browser cached pages? Thanks Sebastian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
macromedia web site
What gives with the macromedia web site? I get a lot of blank pages even with their home page. I am using IE 6.0 on windows xp. On the Mac it's the same. Not only that, whatever pages I get are very slow to load. Sebastian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
why error?
I can't figure out why I'm getting an error on this. The ExtraDate variable
outputs as 30.
cfset ExtraDate = DateAdd('m', 1, CreateDate(Year(Now()), Month(Now()),
1))
select size=1 name=Date
cfloop index=X from=1 to=#DaysInMonth(Month(ExtraDate))#
cfset Date = Month(ExtraDate) '/' X '/' Year(ExtraDate)
cfset NewDate = DateFormat(Date, 'ddd. mm/dd/yy')
cfif NewDate CONTAINS 'Sat'
cfoutputoption value=#NewDate##NewDate#/cfoutput
/cfif
/cfloop
/select
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT:some flash fun
http://www.cyberglass.co.uk/FlashEx/mindreader.html how they do that??? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
data form limit
What is the limit on the amount of data that can be transferred with a form, let's say a textarea. Is passing data in the form with the ColdFusion to xml tag a way around that limit? If so, is there a limit on how much data can be passed this way too? thanks sebastian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: data form limit
at the high end it the source would be, let's say, fifty 8.5 X 11 typed pages back and front. One time I tried to pass a lot of info in a textarea and got truncated at about 2 pages. It would not take any more. on 3/1/03 1:40 PM, Ben Doom at [EMAIL PROTECTED] wrote: AFAIK, there are no theoretical limits. Practical limits would depend on server, client, and bandwidth (in order of increasing limitation). How much are we talking about? -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: sebastian palmigiani [mailto:[EMAIL PROTECTED] : Sent: Saturday, March 01, 2003 2:27 PM : To: CF-Talk : Subject: data form limit : : : What is the limit on the amount of data that can be transferred : with a form, : let's say a textarea. : : Is passing data in the form with the ColdFusion to xml tag a way : around that : limit? If so, is there a limit on how much data can be passed : this way too? : : thanks : sebastian : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
web beacons
Yahoo is using something called web beacons. Can anyone simply explain how a single pixel gif is used as a web beacon. http://privacy.yahoo.com/privacy/us/pixels/details.html Sebastian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
forums software request
Does anyone know of a forums ColdFusion program that has the new thread/not new thread and new message/not new message function database driven and not cookies or session variable based? I have the fusetalk software which bases the new/not new on cookies. If you leave and return from the forum and have not read any of the new topics when you return they are shown as being not new and read. The users of the fusetalk software find this confusing. Sebastian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
CF_Query2Excel
I want to ouput a query to an excel file and am using the custom tag cf_query2excel. When the Excel file is generated the excel headings are not in the same sequence as in the query. For example, the query has in this order 'SponsorName, SponsorID, FirstName, LastName.' But in the Excel file it shows up in the following sequence 'FirstName, LastName, etc.' Any suggestions on how to make the headings appear in the same sequence as the query? thanks Sebastian __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF_Query2Excel
on 9/5/02 12:40 PM, Mark W. Breneman at [EMAIL PROTECTED] wrote: Been there done that and had to get a different tag in the interests of time. Yep. I ended up using the cf_excel tag by Michael Walsh and works great. thanks sebastian __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: datatypes in select boxes
I am not sure if I have grasped your problem but What I do in this situation is this OPTION VALUE=#TchrID#,#GradeTaught##TCHRNAME# #GradeTaught# make the option value into a list then at the stored procedure I would cfset VARIABLE.TchrID = ListFirst(FORM.TchGrade) cfset VARIABLE.GradeTaught = ListLast(FORM.TchGrade) Then pass each individual VARIABLE.xxx to the stored procedure Sebastian on 4/10/02 9:11 AM, Janine Jakim at [EMAIL PROTECTED] wrote: I have a select box that shows teachers and the grade they teach (some teach several grades). This selection is sent to a stored procedure. I want my select box to pull up the teacher with the students by grade so I set it up like this SELECT NAME=TchGrade SIZE=9 TABINDEX size=1 style=width:190px Multiple OPTION SELECTED VALUE= CFOUTPUT QUERY=TchrByGrade OPTION VALUE=#TchrID##GradeTaught##TCHRNAME# #GradeTaught# /CFOUTPUT /SELECT Simple eeeh Now this would work great IF TchrID and GradeTaught were both varchar fields, but TchrID is an integer and GradeTaught is a varchar. So of course I am getting errors about the datatype being wrong and or an error trying to convert it. So I then moved the option value into my query ((TchrID + GradeTaught) AS TcherGradeTaught) And used that OPTION VALUE=#TcherGradeTaught##TCHRNAME# #GradeTaught# Although this is a good thing to do it of course doesn't fix my problem. Any way around this? Thanks, J __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
StructClear(session)
After I do a StructClear(Session) the Session.URLToken that I have added to links also get cleared out and I get a message that Session.URLToken can't be found. How do I prevent it from doing it that? Thanks Sebastian __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFCACHE
Do I need to specify the second flush to flush index.cfm or will the first flush take care of both index.cfm and index.cfm?* 1. cfcache action=FLUSH directory=#FilePath_2# expireurl=index.cfm?* 2. cfcache action=FLUSH directory=#FilePath_2# expireurl=index.cfm Sebastian __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
time field in access
I have an Access db with a date/time value with a medium time format (0:00 am) The field is set as not required When the form is left blank for the time value and the query insert is attempted you get StartTime '' But then you get the error message: data type mismatch in criteria expression How do I insert an empty value or a null value into that date/time field? Sebastian __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://wwwpennyhostcom/redirectcfm?adcode=coldfusionb FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
Re: Could someone check this with non-IE5.5 ?
checked it out on the mac with IE 5.0 and NN 4.7 does not work with the mac Sebastian on 8/21/01 7:26 AM, Thomas Chiverton at [EMAIL PROTECTED] wrote: http://www.compsoc.man.ac.uk/~falken/example.html The way its meant to work, is like a normal drop down, but if you click once in the box (no blue highlight) and type (say) inr it will highlight and select into the box the 1st item in the drop down that has that prefix. I'm looking for Netscape (4.7x, 6) testers, but ie5 or 4 would be good. I've tested it with IE5.5 here. If it works even moderatly well, it'll be going up as a custom tag (marks to cfdev for the tag its based on). Regards, Thomas Chiverton Intranet Architect 01565 757 909 The web is the borderless embodiment of every abstraction ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFLOCK Scope vs Name attributes !!
on 8/15/01 1:27 AM, Jay Sudowski - Handy Networks LLC at [EMAIL PROTECTED] wrote: NAME Optional. Specifies the name of the lock. Only one request will be able to execute inside a CFLOCK tag with a given name. Does this mean then that you don't have to specify what type (read only, exclusive) when you use the name attribute? Sebastian ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
sql for changing field names
I am trying to change a field name with SQL in a Access database. I don't quite have the right syntax with alter products alter product_id rename SKU Sebastian ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Access file for Mac users??
They will not be able to open it. They need to have a conversion utility that would, for example, convert the Access database to a FileMaker database. One such product is called MacLinkPlus by DataViz http://www.dataviz.com/products/maclinkplus/index.html Most but not all Mac users have some version of this software. Sebastian on 7/16/01 12:01 PM, Jeff Fongemie at [EMAIL PROTECTED] wrote: Hello cf-Talk, I have a simple Access database running a small website. Can a Mac user download the access MDB file and open it?? Since Microsoft does not make Access for the MAC, what alternatives do I have to make the actual file available so he can open it? Anyone know of a Mac program that will open a MDB file?? I can convert it to a CSV file, and he can use that, but we'd like to take me out of the loop. Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] Internet Guns For Hire (603) 356-0768 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
maxrows and blockfactor
What is the difference between maxrows and blockfactor? Both are available with cfquery but only blockfactor is available with cfstoredproc. Can you use blockfactor with a cfstoredproc the same way that you would use maxrows in cfquery? Sebastian Palmigiani Cash Flow Club Charity http://www.cashflowclubonline.com/?SEB007883 voice: 773.929.9256 ~~ 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: Unicode ( was OT: Coldfusion vs. ASP)
on 6/18/01 11:58 PM, Kay Smoljak at [EMAIL PROTECTED] wrote: I'd be really interested in finding out about these workarounds... are there any online resources? Anything to keep me away from ASP! One of the work arounds that I have used is to use the URLEncodedFormat() around the unicode characters and insert them that way into the database. Then when you pull them out and want to display them you use URLDecode(). Sebastian Palmigiani Cash Flow Club Charity http://www.cashflowclubonline.com/?SEB007883 voice: 773.929.9256 ~~ 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
forum subscriptions and logins
I have member site which sets a session variable after login. This site also has a forum which emails participants when someone replies to their post. The email contains the URL to the thread. If they click on the URL in the email and they are not logged on they will be taken to the login page. How can I work it so that after they do go through the login process they are automatically redirected to the thread? The idea I came up with is to parse the cgi.http_referer to see if it is asking for a subscribed thread and then put it in a session variable. After they have a successful login then use the session variable with cflocation to the thread. Am I on the right track or is there a better way to do this? 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: Help sought with CFX_DIRECTORYLIST
on 6/5/01 2:35 PM, Mike Brunt at [EMAIL PROTECTED] wrote: Larry, it is almost always a good idea to lock CFX tags using CFLOCK. The threading info could relate to memory threading issues. I have a good article on using cflock, if you would like a copy please let me know. What type of lock would you use? 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
Apache and trailing back slash
I do not understand why you get trailing back slash when using GetDirectoryFromPath with Apache web server cfoutput#GetDirectoryFromPath(CGI.CF_TEMPLATE_Path)#/cfoutput In other words I get c:/program files/apache group/apache/htdocs/members/om/archive/adu/\ Why is there a trailing back slash? How do I get rid of it? 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
highlighting search terms
I want to develop a highlight function of search terms. The following works
well except that it changes the case of the keyword in the output. For
example, 'Cold' in the original becomes 'cold' in the output.
What can I include in the code to keep the original case of the String? If I
use REReplace() then I omit the keywords because of case sensitivity.
Sebastian
-
cfset String = 'Cold Fusion is a rapid application development system for
professional developers who want to create dynamic Web applications and
interactive Web sites. It provides the fastest way to integrate browser,
server, and database technologies into powerful Web applications. With Cold
Fusion, you can build everything from online stores to sophisticated
business systems.'
!--- Set the highlight style ---
style type=text/css
..highlight { background-color: yellow }
/style
cfset Keywords = 'cold,web,server'
cfset OpenTag = 'span class=highlight'
cfset CloseTag = '/span'
cfloop index=x from=1 to=#ListLen(Keywords)#
cfset HighlightedWord = OpenTag ListGetAt(Keywords, x) CloseTag
cfset String= REReplaceNoCase(String, ListGetAt(Keywords, x),
HighlightedWord, ALL)
/cfloop
cfoutput#String#/cfoutput
~~
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
can anyone help?
I have win2K professional with personal web server for development. PWS is hanging after any requests, whether with an htm or cfm file request. When choosing any options in PWS I get the following message: Server is busy This action cannot be completed because the other program is busy. Choose 'Switch to' to activate the busy program and correct the problem. There are no other programs running. I have uninstalled and reinstalled PWS and same problem. Can anyone help? 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: can anyone help?
OK. I have ditched PWS. I have installed Apache and reinstalled ColdFusion and copied the DLL file and changed the httpd.conf file in apache. I cannot get the web server to start. When I click on start apache I get a dos command window that goes so fast I can't even read what it says. I was able to make out the following however, Apache.exe cannot determine local host name. I think the httpd.conf files needs further editing but I'm not confident about what to change. I am guessing that the following lines at the end of the conf file need to be changed. I want to be able to have http://127.0.0.1/ Sebastian -- # If you want to use name-based virtual hosts you need to define at # least one IP address (and port number) for them. # #NameVirtualHost 12.34.56.78:80 #NameVirtualHost 12.34.56.78 # # VirtualHost example: # Almost any Apache directive may go into a VirtualHost container. # #VirtualHost ip.address.of.host.some_domain.com # ServerAdmin [EMAIL PROTECTED] # DocumentRoot /www/docs/host.some_domain.com # ServerName host.some_domain.com # ErrorLog logs/host.some_domain.com-error_log # CustomLog logs/host.some_domain.com-access_log common #/VirtualHost #VirtualHost _default_:* #/VirtualHost LoadModule coldfusion_module modules/ApacheModuleColdFusion.dll -- on 5/31/01 8:58 AM, Tony Schreiber at [EMAIL PROTECTED] wrote: I know this isn't the answer to your question, but ditch PWS and run Apache for Win32. Works great. ;p I think I'm running 1.3.20 on my development machine. Easy install, SMALL footprint... I have win2K professional with personal web server for development. PWS is hanging after any requests, whether with an htm or cfm file request. When choosing any options in PWS I get the following message: Server is busy This action cannot be completed because the other program is busy. Choose 'Switch to' to activate the busy program and correct the problem. There are no other programs running. I have uninstalled and reinstalled PWS and same problem. Can anyone help? 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: can anyone help?
on 5/31/01 9:40 AM, Arden Weiss at [EMAIL PROTECTED] wrote: See Apache installation instructions paper ColdFusion and Apache install tips and tricks by Mark Mathis on Annapolis Cold Fusion Users Group web site (2/22/01 meeting) if you decide to go that route. It will help... www.ancfug.com/meetings Arden, thanks. Those are the instructions I was looking for. 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
Apache web server
I have installed the Apache web server and when I get this page to test the installation http://127.0.0.1/CFDOCS/testinstallation/test.cfm When I click on Verify query I get: The requested method POST is not allowed for the URL /CFDOCS/testinstallation/courses.cfm. Also, I can't get the Cold Fusion Adminsitrator to launch. When the browser launches a file download process starts and the funny thing is that the encrypted index.cfm page shows up in the Studio Edit panel. Any suggestions? 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: can anyone help?
Thanks for all your help. I have got Apache working with ColdFusion. Sebastian on 5/31/01 4:39 PM, Dave Watts at [EMAIL PROTECTED] wrote: OK. I have ditched PWS. I have installed Apache and reinstalled ColdFusion and copied the DLL file and changed the httpd.conf file in apache. I cannot get the web server to start. When I click on start apache I get a dos command window that goes so fast I can't even read what it says. I was able to make out the following however, Apache.exe cannot determine local host name. If you want to find out exactly what error is being returned, you can simply open a command prompt and run the command contained within the shortcut. I think the httpd.conf files needs further editing but I'm not confident about what to change. I am guessing that the following lines at the end of the conf file need to be changed. I want to be able to have http://127.0.0.1/ If I recall correctly, when you set up Apache, all you should have to change within httpd.conf is add the LoadModule directive, change the DocumentRoot directive, and change the Directory directive, assuming you've got a properly configured TCP/IP stack bound to your network card. 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
request scope confusion
I am trying to understand the request scope. What is the difference between putting cfset DSN = 'foo' vs. cfset request.DSN = 'foo' in the application.cfm template or in any template? 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: case
LCase(yourword) on 5/29/01 4:36 PM, Jones, Becky at [EMAIL PROTECTED] wrote: is there a cf command that would allow me to force a word to output in all lowercase? thanks, bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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: Email
on 5/29/01 10:44 PM, Parker, Kevin at [EMAIL PROTECTED] wrote: Can I create a search interface to the contents of a mail box without moving the contents to a dB. You can use Verity to make a collection of the messages, index them and do a cfsearch on them. 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
more locking questions
1. In a shared hosting environment if you do proper locking of session variables in your application and another application does not how does that affect you? 2. If the answer to number 1 is that it destabalizes your application would it then be better to have variables stored in cookies rather than session variables? 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: basic question
Yes they do. I call an encrypted tag like cf_counter which does not need any attributes and what gets outputted is the encryption. Sebastian on 5/23/01 4:04 AM, Thomas Chiverton at [EMAIL PROTECTED] wrote: I downloaded an encrypted custom tag. When I make a call to the tag it shows up all encrypted on the output page. How do you make an encrypted tag display correctly. Do your other ColdFusion files work OK ? ~~ 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: cfcatch and email
Bryan, I have followed your suggestion. I created a query with a phony datasource to generate an error and put the cfmail outside the cfcatch block. I have tried the following code in my development box and on the hosting environment and it does not send the email with the error. Can someone try the following code with your email address and see if an email is sent. Scratching my head. Sebastian cftry cfquery name=Test datasource=X Select * from Members /cfquery cfcatch type=database cfset Detail = CFCATCH.Detail /cfcatch /cftry cfif IsDefined(Detail) cfmail from=[EMAIL PROTECTED] to=[EMAIL PROTECTED] subject=Database Error #Detail# /cfmail /cfif cfoutput#Detail#/cfoutput on 5/22/01 3:44 AM, Bryan LaPlante at [EMAIL PROTECTED] wrote: Never tried to do that inside of a cfcatch block before but could you just populate a variable with the email message and then outside the try block check to see if the message is not empty and then send an email if so? Bryan - Original Message - From: sebastian palmigiani [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 21, 2001 10:39 PM Subject: cfcatch and email I want to send an email with database error info using cftry/cfcatch. But it is not working. Am I trying to do something that can't be done within a cfcatch block? Sebastian --- cftry cfquery name='foo' datasource='foo' Select * from members /cfquery cfcatch type=database !--- EMail WebMaster --- cfmail from=[EMAIL PROTECTED] type=HTML to=[EMAIL PROTECTED] subject=Database Error Date: #DateFormat(Now(), MM D, YYY)# #TimeFormat(Now(), h:mm tt)#br Error Type: #CFCATCH.Type#br Message: #CFCATCH.Message#br Template: #CGI.CF_Template_Path#br Referer: #CGI.HTTP_Referer#brbr Details: #CFCATCH.Detail#brbr /cfmail cflocation url=index.cfm?go=Error --- /cfcatch /cftry ~~ 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: Compromising Security
Is this the most efficient way to check for SQL in form input? Sebastian -- cfset FORM.FirstName = 'Sebastian' cfset FORM.LastName = 'Palmigiani' cfset FORM.Address = ';drop table members;' cfset FormList = '' cfset FormList = ListAppend(FormList, FORM.FirstName) cfset FormList = ListAppend(FormList, FORM.LastName) cfset FormList = ListAppend(FormList, FORM.Address) cfset SQLList = 'Select,Insert,Delete,Update,Drop,Create,Table' cfloop list=#SQLList# index=SQL cfif ListContainsNoCase(FormList, SQL) !--- Send back if there are SQL keywords --- cflocation url=index.cfm?Message=Error /cfif /cfloop on 5/22/01 5:27 PM, Bryan Love at [EMAIL PROTECTED] wrote: someone could conceivable type ; drop table [tablename]; into a form field if they knew the name of the table and mess up the DB Bryan Love ACP Internet Application Developer [EMAIL PROTECTED] -Original Message- From: Pooh Bear [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 22, 2001 9:28 AM To: CF-Talk Subject: Compromising Security hey, I was wondering what are the least amount of information someone needs to compromise my database or code? I am.err...hacking? my site/database through the URL. So far, I've got 2 tablenames, the datasource, and some field names. I dont want to have to do a lot of coding to prevent this from being seen by someone else, but i will if have to, but first i want to know if anyone could do anything with this much information. Thanx! :) ~~ 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
cfcatch and email
I want to send an email with database error info using cftry/cfcatch. But it is not working. Am I trying to do something that can't be done within a cfcatch block? Sebastian --- cftry cfquery name='foo' datasource='foo' Select * from members /cfquery cfcatch type=database !--- EMail WebMaster --- cfmail from=[EMAIL PROTECTED] type=HTML to=[EMAIL PROTECTED] subject=Database Error Date: #DateFormat(Now(), MM D, YYY)# #TimeFormat(Now(), h:mm tt)#br Error Type: #CFCATCH.Type#br Message: #CFCATCH.Message#br Template: #CGI.CF_Template_Path#br Referer: #CGI.HTTP_Referer#brbr Details: #CFCATCH.Detail#brbr /cfmail cflocation url=index.cfm?go=Error --- /cfcatch /cftry ~~ 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: grab links from a webpage
on 5/15/01 10:57 AM, Art Broussard at [EMAIL PROTECTED] wrote: I can pull up the page using cfhttp. Now how do I search for links on it? Do i need to use find or refind? I don't fully understand reg expressions so I don't know how to use it that well.go To learn more about regular expressions go to http://www.houseoffusion.com/ and download the PowerPoint presentation on regular expressions. 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: E-commerce Dilemma
on 5/15/01 5:19 PM, Alexandre Dornback at [EMAIL PROTECTED] wrote: Check this out. It kills both of the carts you are looking at! I personally know the guy who wrote this and it is simply the best app you can find for a core commerce engine. Here is a feature list.. You forgot the URL. 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
Forced logout
How can I use javascript to make a member logout if they go to a different web site? Is this possible to do with javascript. 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
Counting members online.
Counting members online. I am developing a member site with log on. How can one accurately count how many members are online at a particular time. My idea is to set up an application variable counter which increases when a person logs on and decreases when a person logs out. How can I account 1. members who do not log out 2. members who go to another site 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: Q. about Encoding
on 5/9/01 6:01 AM, Michael Lugassy at [EMAIL PROTECTED] wrote: Is it possible to Encode a certain string into specific set of characters? when I use the Encode() function it gives out a WELL ENCODED STRING, but the problem is that it's TOO ENCODED - It can't seem to be placed securely into form fields or urls (because it sometimes contains special signs such as /' and Carrige Returns). is there any solution to this? Try using URLEncodedFormat() and then URLDecode(). 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: How do I open an IE window into fullscreen channel mode?
Hi Spadea. Welcome to the list. Try this in the head section.
SCRIPT LANGUAGE=JavaScript
!--
BrowserName = navigator.appName;
BrowserVersion = parseInt(navigator.appVersion);
if (BrowserName == Netscape) {
self.moveTo(0,0)
self.resizeTo((screen.availWidth-8),(screen.availHeight-45)) }
else { self.moveTo(0,0)
self.resizeTo((screen.availWidth),(screen.availHeight)) }
//--
/SCRIPT
Cheers,
Sebastian
on 5/8/01 9:04 PM, Spadea Ho at [EMAIL PROTECTED] wrote:
Hi guys, new to the list here.
Sorry to ask this question here, but I really need to find out
a way to launch an IE window into full screen channel mode
(the mode when u manually hit F11 to make the browser
fullscreen) from a desktop shortcut. I have to do this for
some net kiosk at a cafe. Does anyone know of any javascript
that does this? I have been searching thru' the major developer
sites with no results. Can anyone give me a hand in this?
Thanks a million,
Spadea ho.
~~
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
default spool file
I had a problem with cfmail where it kept sending the same email over and over again. I had to stop the CF service. I checked the spool directory and found the following spool file: c:\CFusion\Mail\Spool\2A.CFMAIL=1 That was the name of the email that was beeing sent over and over. What is the default value for this file? 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
bcc and lists
How do I retrieve sets from a list so as to loop through the list and send groups of emails in the bcc field rather than the whole list at once or only one at a time? cfset MailList = ValueList(GetEMails.EMail) cfmail to='[EMAIL PROTECTED]' from='[EMAIL PROTECTED]' subject='newsletter' bcc='#MailList# #Message# /cfmail 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
Mid function for lists
Is there a way of extracting groups of elements within a list like using the Mid function for extracting groups of chracters within a string? I want to loop through the list to extract groups of emails and put each group in BCC in cfmail as a way of circumventing the limitation of the cfmail tag. 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
CFMAILPARAM and X-Mailer
Can you use the CFMAILPARAM tag to reset the value of the X-Mailer header in cfmail so you can bypass ISPs who consider X-Mailer: Allaire Cold Fusion as spam mail? 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
ValueList() in CF 4.5
The ValueList function in CF 4.5.1 inserts a space between values using the default delimiter. The table column has the following values: '3.1' and '3.2' When I do a query and use the ValueList function RoleID = ValueList(Query.Column) it outputs as 3.1 ,3.2 with an extra space. As a result using ListFind(RoleID, '3.1') gives a 0 Is this the way it is supposed to work? I would think that the extra space is not needed. I can't remember now if CF 4.0 did this too. 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
validating URLs with regex
REFind('^http://[\./-:0-9a-zA-Z]+$', URL)
I want to be able to validate the url.
This works
REFind('^http://[\./-:0-9a-zA-Z]+$', URL)
But I want to allow - _ ? = and alphanumeric characters in the query
string but not in the first part of the URL.
What do I need to add to
^http://[\./-:0-9a-zA-Z]+$
to make it work? Also, how can I make the s in https optional?
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
cfcache with database changes
Am I missing something or is this the way that the cfcache tag is supposed to work? I have a page which has a menu that derives its data from the database. So I use the cfcache tag on that page set to action="CACHE" I use the following only after a change that affects the menu is made to the database. cfcache action="FLUSH" directory="http://127.0.0.1/cfscripts/arica/tranlation/" expireurl="Q_D_LanguageMenu.cfm" However, the menu is not refreshed. I have also used the local file path with no success: c:\inetput\root\cfscripts\arica\translation\. The only time the menu page gets refreshed is that if I manually change something on that page thereby changing its timestamp. Is there a work around or am I using this tag incorrectly? 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
OT:CyberCash
I am thinking of using CyberCash. How is their performance and service since they have declared bankruptcy? 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
locks and StructClear
What type of lock is used with StructClear(Session)? Is it ReadOnly or Exclusive? 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
http 500 Internal Server Error and CF installation
I have just installed CFServer 4.5.1 on Windows 2000 with IIS. I get the html pages to display but not the cfm pages, when for example, going to the cf administrator page. I get an http 500 Internal Server Error. I have followed all the instructions in the knowledge base article 7671 and the problem persists. There has to be a simple fix for this but I can't figure it out. Thanks, Sebastian -- There is a problem with the page you are trying to reach and it cannot be displayed. Please try the following: Open the 127.0.0.1 home page, and then look for links to the information you want. Click the Refresh button, or try again later. Click Search to look for information on the Internet. You can also see a list of related sites. HTTP 500 - Internal server error Internet Explorer ~~ 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: http 500 Internal Server Error and CF installation
I found out what the problem was. Under properties of the default web site there is 'Application Protection' which was set to 'Medium Pooled' and when I changed it to 'Low IIS Process' I was able to get the administrator page and cfm pages displayed. What a day. I started at 6:30 this morning and just now solved it. Sebastian on 4/18/01 3:18 PM, Stephenie Hamilton at [EMAIL PROTECTED] wrote: no need to reinstall, go into IIS, application settings, remove and recreate the app...should fix it fine -- Stephenie Hamilton Senior ColdFusion Administrator Express Technologies, Inc. want CF_Freedom? try CFXHosting.com -Original Message- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 3:00 PM To: CF-Talk Subject: RE: http 500 Internal Server Error and CF installation you need to reinstall Win2K. it comes bundled with MDAC 2.5, and when installing CF over it, it breaks. just "upgrade" to Win2K FROM win2K and it'll be fine. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message----- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 1:14 PM To: CF-Talk Subject: http 500 Internal Server Error and CF installation I have just installed CFServer 4.5.1 on Windows 2000 with IIS. I get the html pages to display but not the cfm pages, when for example, going to the cf administrator page. I get an http 500 Internal Server Error. I have followed all the instructions in the knowledge base article 7671 and the problem persists. There has to be a simple fix for this but I can't figure it out. Thanks, Sebastian -- There is a problem with the page you are trying to reach and it cannot be displayed. Please try the following: Open the 127.0.0.1 home page, and then look for links to the information you want. Click the Refresh button, or try again later. Click Search to look for information on the Internet. You can also see a list of related sites. HTTP 500 - Internal server error Internet Explorer ~~ 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
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 cfquery name="foo" datasource="bar" Select * from Users where UserID = #Val(url.UserID)# /cfquery - 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: Link to download .jpg or gif
How about just putting a link text 'Right click to download' under the thumbnail. It's not ideal but it works. Sebastian on 4/11/01 10:17 PM, scottw at [EMAIL PROTECTED] wrote: I am looking for a solution to a downloading problem i am having with a link. I am thumbnailing images, and am wanting to have a "download" link next to the thumbnail that will automatically open up the 'save to' window. Obvioulsy if i just link directly to the .jpg file, the download window will not pop up, and it just redirects me to a blank page in my default browser and shows the full size image. Any suggestions?? Thanks, Scott ~~ 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: Picture Size
on 4/12/01 1:20 PM, William J Wheatley at [EMAIL PROTECTED] wrote: Has anyone come up with a way to check the size of a picture being uploaded before it actually gets uploaded? Instead of having to do it on the server side afterwards? Try: cfif CGI.CONTENT_LENGTH GT /cfif 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
Studio 4.5.2
I upgraded to CF Studio 4.5.2 with Win98. It kept repeatedly crashing my system. I had to go back to Studio 4.0. Is this just an issue with Win98 or would it be the same story with Win2000? I am disspointed in this 'improvement.' 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: Studio 4.5.2
I got Windows 2000 installed now. I install the CF Server from the CF Studio 4.5.2. I restart and I get all kinds of error messages such as: userinit.exe failed to initialize properly Service - AuthSrv.exe generated errors and will be closed Service - AzSrv.exe generated errors and will be closed I can't even get to the desktop and just get an empty screen. I went into safe mode and uninstalled the CF server and I was able to get to my desktop without any errors. Does this many sense to anyone? Sebastian on 4/11/01 3:19 PM, Sandra Clark at [EMAIL PROTECTED] wrote: Sebastian I had a lot of problems running 4.5.x on my Win2k computer until I did the following: I removed Studio 4.0 completely from my system. Moved my snippets and other customizations (like Help, etc.) to a temporary directory. Deleted the 4.0 directory and all subdirectories from my system Went through my registry with RegEdit and deleted anything to do with CFStudio or Homesite completely. Rebooted machine Did clean install. It cleaned up a lot of problems. Of course I still have problems (who doesn't with this crapola release), but it is markedly more stable than what I was working with before. Hope this helps Sandy Clark Shayna Productions http://www.shayna.com -Original Message- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 11, 2001 10:00 AM To: CF-Talk Subject: Studio 4.5.2 I upgraded to CF Studio 4.5.2 with Win98. It kept repeatedly crashing my system. I had to go back to Studio 4.0. Is this just an issue with Win98 or would it be the same story with Win2000? I am disspointed in this 'improvement.' 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
Thanks Bud: Re: SQL Server database restore
on 4/10/01 1:54 PM, Bud at [EMAIL PROTECTED] wrote: It's pretty easy. Right click on the databases directory in EM, go under the All Tasks menu and choose Restore Database. Hey Bud. Thanks. I knew there was an easy way to do this. Also thank you Adrian Cooper and Adrian Cesana for the other suggestions. 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
SQL Server database restore
I did my development in windows 98 with SQL Server. I have now windows 2000, with a clean install. How do I get the SQL Server database which I have backed up from the win98/SQL Server set up into the new win2000/SQL Server set up? I have put the backed up database in the SQL Backup folder but SQL Server does not see it. I have looked at using Data Transformation Services but none of the options seem to give me a way of accessing the backed up SQL Server database. I know there is an easy solution to this but I don't know it. Can anyone help me on this? 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: cfstored procedure- NEWbie
on 3/28/01 5:29 PM, Bob Silverberg at [EMAIL PROTECTED] wrote: We're on SQL2000, which has it's own quite usable SP debugger. I'm not referring to debugging the SPs themselves, which I always do outside of the CF environment, but rather debugging problem One of the things I noticed with using stored procedures is that somehow it's important that the paramaters that you pass to the stored procedure from the CF tag be in the same order as they are declared in the MS SQL stored procedure script. I have spent hours debugging some stored procedure that was not working and only when I made the order the same between CF and the stored procedure script did the problem disappear. 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
What does this error mean?
I do not understand nor can I figure out how to fix the following error from a stored procedure. Doe anyone know what this error means? Sebastian -- Error Diagnostic Information CMemoryException: unknown cause PCodeRuntimeContextImp::executeSQLTagCFStoredProc::endTag The error occurred while processing an element with a general identifier of (CFSTOREDPROC), occupying document position (24:1) to (25:33). -- cfstoredproc procedure="spSelectTranslation" datasource="arica" cfprocparam type="in" cfsqltype="cf_sql_varchar" dbvarname="@LanguageID" value="#Trim(URL.LanguageID)#" cfprocparam type="in" cfsqltype="cf_sql_varchar" dbvarname="@TrainingTranslationID" value="#Trim(URL.TrainingID)#" cfprocparam type="in" cfsqltype="cf_sql_smallint" dbvarname="@TrainingTranslationType" value="#Trim(URL.Type)#" /cfstoredproc ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
What does this error mean?
I do not understand nor can I figure out how to fix the following error from a stored procedure. Doe anyone know what this error means? Sebastian -- Error Diagnostic Information CMemoryException: unknown cause PCodeRuntimeContextImp::executeSQLTagCFStoredProc::endTag The error occurred while processing an element with a general identifier of (CFSTOREDPROC), occupying document position (24:1) to (25:33). -- cfstoredproc procedure="spSelectTranslation" datasource="arica" cfprocparam type="in" cfsqltype="cf_sql_varchar" dbvarname="@LanguageID" value="#Trim(URL.LanguageID)#" cfprocparam type="in" cfsqltype="cf_sql_varchar" dbvarname="@TrainingTranslationID" value="#Trim(URL.TrainingID)#" cfprocparam type="in" cfsqltype="cf_sql_smallint" dbvarname="@TrainingTranslationType" value="#Trim(URL.Type)#" /cfstoredproc ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Unicode and CMemoryException
After spending most of today trying to figure out the CMemory Exception Error I narrowed it down to using N datatypes such as ntext, nchar and nvarchar and using foreign language character sets. Is it true that there is really no way around this as CF does not support Unicode? I have CF 4.0 Sebastian CMemoryException: unknown cause PCodeRuntimeContextImp::executeSQLTagCFStoredProc::endTag ~~ 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
It's Greek to me
I am working on an application which will allow translators to input their translation from the English language to another language. One of the translations will be from English to Greek which has its own distinctive font set. I will be using MS SQL. How do I get this to work with a web database? Do I use nvar data type? Does the Greek font set need to be installed on the web hosting server? Or is it only necessary for the translator to have the font set installed on their computer? This is a new area for me to work in and, really, Greek to me. LOL. 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
database error
I don't understand the following MS SQL error. Both columns for the primary and foreign key are varchar(20). I don't know how to fix this error because I don't even know what it means as it is the first time for this one. Any help? Thanks, Sebastian --- - Unable to create relationship 'FK_TrainingTranslations_WWTunings'. [Microsoft][ODBC SQL Server Driver][SQL Server]The total row size (8132) for table 'TrainingTranslations' exceeds the maximum number of bytes per row (8060). Rows that exceed the maximum number of bytes will not be added. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: different link colours
on 3/18/01 12:16 AM, Seamus Campbell at [EMAIL PROTECTED] wrote: So how do I get the above links colours to ONLY work in bottom.cfm Try the style tag like a href="YourLink.cfm" style="color: YourColor;"YourLink/a The style tag must be included in each link. There are other ways to do it with CSS but this is the simplest. 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: weird session variable behavior
I have used other delimiters such as "|' and even the comma and still the same results. I have figured out that it has something to do with the development server on my machine because I put the pages up on the hosting site and it worked ok. It is errors like these that are so frustrating and some times take the most time to resolve. Thanks, Sebastian on 3/15/01 3:42 AM, Joseph Thompson at [EMAIL PROTECTED] wrote: I have never seen the "exponent" character used as a delimiter... maybe the fact that ^ is a mathematical operator is a problem? (more and better answers will follow in the "morning" I am sure) I set a 2 element list to a session variable and retrieve the last element. This works ok on this page. cflock name="SESSION.SessionID" timeout="10" cfset SESSION.SponsorID = "HPRO1^The Human Process Inc." cfoutput#ListLast(SESSION.SponsorID, "^")#/cfoutput /cflock on subsequent pages I have cflock name="SESSION.SessionID" timeout="10" cfoutput#ListLast(SESSION.SponsorID, "^")#/cfoutput /cflock but strangely when I do a ListLen(Session.SponsorID, "^") the list only shows as having 1 element only and I can't access the 2nd element on the list in other pages. I tried various delimiters and still did not work. Where did the 2nd element go? I am using CF 4.0 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
weird session variable behavior
I set a 2 element list to a session variable and retrieve the last element. This works ok on this page. cflock name="SESSION.SessionID" timeout="10" cfset SESSION.SponsorID = "HPRO1^The Human Process Inc." cfoutput#ListLast(SESSION.SponsorID, "^")#/cfoutput /cflock on subsequent pages I have cflock name="SESSION.SessionID" timeout="10" cfoutput#ListLast(SESSION.SponsorID, "^")#/cfoutput /cflock but strangely when I do a ListLen(Session.SponsorID, "^") the list only shows as having 1 element only and I can't access the 2nd element on the list in other pages. I tried various delimiters and still did not work. Where did the 2nd element go? I am using CF 4.0 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
SESSION.URLToken
If you want to use session variables and you want to anticipate users not having cookies turned on is it correct then that you would need to use a SESSION.URLToken and not just a URLToken appended to each link? Why doesn't just having URLToken work? I tried it and I can't access the session variables but when I use SESSION.URLToken in the links then the session variables are available. What about having both session and client management on at the same time? Which token would you use then? 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: SESSION.URLToken
on 3/11/01 7:50 PM, Dave Watts at [EMAIL PROTECTED] wrote: To the best of my knowledge, there's no local variable called URLToken. There is a URLToken that is activated only when clientmanagement is on. 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: Examples of Password protection
on 3/10/01 9:35 AM, Michael at [EMAIL PROTECTED] wrote: Looking for some examples of password protection of certain pages or view's Near the end of chhapter 17 of the book Mastering ColdFusion 4.5 by Danesh and Motlagh has a nice section on this. 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: Protecting an admin page
on 3/8/01 9:47 PM, Hubert Earl at [EMAIL PROTECTED] wrote:
I have an admin page which can be accessed thru a login page. However, as
it now stands, if someone were to learn bookmark that page, he or she could
return to it via the bookmark, rather than via the login page. How can I
ensure that someone could only access the admin page via the login page?
You can set up a very simple security either using cookies or a session
variable after the member successfuly logs in. If everyone has the same
password you can have something like this on the page that the login form
points to:
cfif FORM.Password IS NOT "letMeIn"
cflocation url="login.cfm"
cfelse
cfcookie name="login" value="yes"
script
window.location = "admin/index.cfm"
/cfscript
/cfif
The reason for the script tag is that you can't set a cookie while you use
cflocation.
Have the login template and the action template outside the directory where
the application.cfm page that will test for the existence of the cookie or
session variable otherwise you would get a loop going.
In the application.cfm page you can test for the existence of the cookie or
session variable and if it does not exist send them back to the login page
with cflocation something like:
cfif NOT IsDefined("COOKIE.Login")
cflocation url="../login.cfm"
/cfif
You can do the same with a session variable. If you don't want to use the
application.cfm page you just have the above cookie test on every page that
you want secured.
If everyone uses the same password to get in its easy. If different
passwords are required you need to set up a database or have a text file
that you can look for password matches.
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
Testing for NULL in stored procedures
I am working on a poll which allows multiple selections. How do I get this strored procedure to work? I am passing null values from the cfstoredproc tag and want to conditionally run a query depending n whether the value of the variable is NULL or not. I have tried NULL, NOT NULL, !=. With nothing happens, and with NOT NULL and != I get syntax errors. CREATE PROCEDURE spMyVote (@PollID VARCHAR(25), @PollType CHAR(3), @ChoiceA CHAR(1), @ChoiceB CHAR(1), @ChoiceC (1)) AS IF @PollType = 'MS' BEGIN IF @ChoiceA NULL BEGIN UPDATE PollMultipleChoice SET AVote = AVote + 1 WHERE PollID = @PollID END IF @ChoiceB NULL BEGIN UPDATE PollMultipleChoice SET BVote = BVote + 1 WHERE PollID = @PollID END IF @ChoiceC NULL BEGIN UPDATE PollMultipleChoice SET CVote = CVote + 1 WHERE PollID = @PollID END END Here is the stored procedure tag: cfstoredproc procedure="spMyVote" datasource="arica" cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="@PollID" value="#TRIM(FORM.PollID)#" cfprocparam type="In" cfsqltype="CF_SQL_CHAR" dbvarname="@PollType" value="#TRIM(FORM.PollType)#" cfprocparam type="In" cfsqltype="CF_SQL_CHAR" dbvarname="@ChoiceA" value="#Trim(FORM.ChoiceA)#" null="#IIf(FORM.ChoiceA IS '', 1, 0)#" cfprocparam type="In" cfsqltype="CF_SQL_CHAR" dbvarname="@ChoiceB" value="#Trim(FORM.ChoiceB)#" null="#IIf(FORM.ChoiceB IS '', 1, 0)#" cfprocparam type="In" cfsqltype="CF_SQL_CHAR" dbvarname="@ChoiceC" value="#Trim(FORM.ChoiceC)#" null="#IIf(FORM.ChoiceC IS '', 1, 0)#" /cfstoredproc ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Testing for NULL in stored procedures
on 3/8/01 9:59 AM, Andy Ewings at [EMAIL PROTECTED] wrote: or rather! IF @ChoiceA IS NOT NULL Yep that did the trick. 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: Protecting an admin page
on 3/8/01 9:47 PM, Hubert Earl at [EMAIL PROTECTED] wrote:
I have an admin page which can be accessed thru a login page. However, as
it now stands, if someone were to learn bookmark that page, he or she could
return to it via the bookmark, rather than via the login page. How can I
ensure that someone could only access the admin page via the login page?
You can set up a very simple security either using cookies or a session
variable after the member successfuly logs in. If everyone has the same
password you can have something like this on the page that the login form
points to:
cfif FORM.Password IS NOT "letMeIn"
cflocation url="login.cfm"
cfelse
cfcookie name="login" value="yes"
script
window.location = "admin/index.cfm"
/cfscript
/cfif
The reason for the script tag is that you can't set a cookie while you use
cflocation.
Have the login template and the action template outside the directory where
the application.cfm page that will test for the existence of the cookie or
session variable otherwise you would get a loop going.
In the application.cfm page you can test for the existence of the cookie or
session variable and if it does not exist send them back to the login page
with cflocation something like:
cfif NOT IsDefined("COOKIE.Login")
cflocation url="../login.cfm"
/cfif
You can do the same with a session variable. If you don't want to use the
application.cfm page you just have the above cookie test on every page that
you want secured.
If everyone uses the same password to get in its easy. If different
passwords are required you need to set up a database or have a text file
that you can look for password matches.
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
I'm stumped
I get the following error with a stored procedure. I am using CF 4.0. What
is stumping me is that when I run the query in the analyzer it works. For
example, this work:
INSERT INTO PollMembers
(PollID, MemberID, MyVote, LastUpdate)
VALUES('MC-03-5-2001-14-33-22', 'PWOO2', 'A', GetDate())
ODBC Error Code = 23000 (Integrity constraint violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]INSERT statement conflicted
with COLUMN FOREIGN KEY constraint 'FK_PollMembers_Polls'. The conflict
occurred in database 'arica', table 'Polls', column 'PollID'.
SQL = "spInsertMyVote"
Data Source = "arica"
The error occurred while processing an element with a general identifier of
(CFSTOREDPROC), occupying document position (92:1) to (93:33).
--
The Tables are:
Polls PollMembersMembers
PollID VARCHAR(25) PK PollID VARCHAR(25) FK MemberID CHAR(10) PK
PollNameMemberID CHAR(10) FK FirstName
etc.etcetc
I have triple checked the relationships and they are fine.
Here is the stored procedure in CF:
cflock name="SESSION.SessionID" timeout="10"
cfset MemberID = SESSION.MemberID
/cflock
cfstoredproc procedure="spInsertMyVote"
datasource="arica"
cfprocparam type="In"
cfsqltype="CF_SQL_VARCHAR"
dbvarname="@PollID"
value="TRIM(FORM.PollID)"
cfprocparam type="In"
cfsqltype="CF_SQL_CHAR"
dbvarname="@MemberID"
value="#TRIM(MemberID)#"
cfprocparam type="In"
cfsqltype="CF_SQL_CHAR"
dbvarname="@MyVote"
value="#TRIM(FORM.TheVote)#"
/cfstoredproc
---
Here it is in SQL Server:
CREATE PROCEDURE spInsertMyVote (@PollID VARCHAR(25), @MemberID CHAR(10),
@MyVote CHAR(3))
AS
INSERT INTO PollMembers
(PollID, MemberID, MyVote, LastUpdate)
VALUES(@PollID, @MemberID, @MyVote, GetDate())
---
It's got to be something with CF. Why would it work in the SQL Query
Analyzer?
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: I'm stumped
on 3/6/01 6:45 PM, Bryan Love at [EMAIL PROTECTED] wrote: here's your problem... cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="@PollID" value="TRIM(FORM.PollID)" you didn't pound the trim function :) Geez...You're right! I have been at it for hours with this trying to figure it out. Couldn't see the trees because the forest was in the way. 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
Stored Procedures
In a stored procedure how can you run a conditional query based on the value of a declared variable? The following does not work. DECLARE @PollType CHAR SELECT @PollType = PollType FROM Polls WHERE PollStatus = 1 -- Run query depending on PollType IF @PollType = 'YN' BEGIN run query number 1 END IF @PollType = 'MC' BEGIN run query number 2 END 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
Which is better?
Which is better in this situation: using application variables or cfcache? I have an application variable from a query which populates a select box. Would it be better to use cfcache instead? 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
fusebox and cfcache
I have a question about using cfcache with fusebox. If I have an action like cfcase value="ShowSchedule" cfinclude template="Query_SelectSchedule.cfm" cfinclude template="Display_Schedule.cfm" /cfcase I want to use cfcache on Display_Schedule.cfm. The link would be listed as index.cfm?action=ShowSchedule. If that is the case then the query would run. Or would you put the cfcache tag in both templates? Or is this an instance where fusebox is not the way to go and just combine the two templates into one page and have cfcase value="ShowSchedule" cfinclude template="Query_Display_Schedule.cfm" /cfcase 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
Verity
Why is it that in the Summary variable in Verity sometimes HTML codes are shown and sometimes not? I have checked the pages where this happens and they are identical in terms of the image tag that is displayed in one summary and not in another. Also, how do you change the Score variable? I have tried #(Score * 100)# and cfset Score = Score * 100) #Score# and it don't work. 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: bold verity search terms
Thanks James. There is one thing I am unclear though. How do you exclude certains areas of the page in the parsing. For example, how do you limit the parsing to whatever is in between the body tags? Also, if there is an image that has a name that matches the search term then that image name will also get the bold treatment. Sebastian on 2/21/01 11:21 PM, James McCullough at [EMAIL PROTECTED] wrote: Sebastian, On your output page Verity gives you access to the "Summary" variable and you could do a simple loop over the criteria and a simple replace. cfparam name="form.criteria" default="funny Fusion" cfparam name="Summary" default="James is the funny guy with Cold Fusion Experience" cfloop list="#form.criteria#" index="num" delimiters=" " cfset summary=ReReplace(summary,"#num#","b#num#/b", "ALL") /cfloop cfoutput#Summary#/cfoutput You could then do a CFFILE for the HTML page and create a variable that comes from parsing the content between the body tags and do a similar type replace. I would loop over the search terms because the content match may be separated. You are on the right track. One thing that I have found is that parsing the content of the page and inserting it into the database and using that when indexing gives me a workaround for the fact that Verity does not index titles and descriptions. Parse between the title tags and description tags and you can index them. -Original Message- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 5:07 PM To: CF-Talk Subject: bold verity search terms Any ideas on how you would make bold b the verity search term in an htm or cfm file that is returned from cfsearch? The one way I can think of is to use cffile to get the html file and then do a replace of the search term with bsearch term/b. Am I on the right track? 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: local user time
on 2/22/01 9:23 AM, Ethan Rosch at [EMAIL PROTECTED] wrote: What's the best way to get the time off of the users local machine? The Now() fuctions pulls server time. You need to use javascript. 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: How to choose Name or Scope when locking
on 2/22/01 2:13 PM, Dave Watts at [EMAIL PROTECTED] wrote: Databases do this stuff for you; that's what transactional database processing is all about. I'd strongly recommend using transactions within the database to do this instead of CFLOCK. Of course, I suspect that you already know this, but for the benefit of any other readers, I thought that I should respond. how about cftransaction? ~~ 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: Validating Checkboxes
on 2/21/01 1:07 PM, Phoeun Pha at [EMAIL PROTECTED] wrote: Anyone have a good method in CF for validating checkboxes (grouped). Since the form gives you a comma delimited list of values of the boxes checked I would test with ListContains(variableName, variableValue). 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
bold verity search terms
Any ideas on how you would make bold b the verity search term in an htm or cfm file that is returned from cfsearch? The one way I can think of is to use cffile to get the html file and then do a replace of the search term with bsearch term/b. Am I on the right track? 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
2 Dabase Questions
Does the foreign key in a table need to be indexed when that field is already indexed as a primary key? Also, if you have a linking table with 2 foreign keys should those 2 keys be combined to form a primary key for the linking table? 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
2 Dabase Questions
Does the foreign key in a table need to be indexed when that field is already indexed as a primary key? Also, if you have a linking table with 2 foreign keys should those 2 keys be combined to form a primary key for the linking table? 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
Database Indexing Primary Keys
Does anyone have any input on these 2 questons? Does the foreign key in a table need to be indexed when that field is already indexed as a primary key? Also, if you have a linking table with 2 foreign keys should those 2 keys be combined to form a primary key for the linking table? 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: Not letting me update
Joshua: Try removing the single quotes around the 1. I am assuming that the sold column is either set to a number or bit value in your database. If so that would explain your error. Sebastian on 2/11/01 5:45 PM, Joshua Tipton at [EMAIL PROTECTED] wrote: The id is being passed yet I am reciving the error below. Can anyone tell me why. My database id is set to auto number. Joshua Tipton a href="delete.cfm?id=#id#"Delete/a cfquery name="" datasource="gunlist" dbtype="ODBC" UPDATE guns setsold = '1' WHERE (id = '#id#')/cfquery Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. ~~ 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
HTML/OS
Anyone know about ColdFusion users being wooed by HTML/OS http://biz.yahoo.com/bw/010205/ca_aestiva.html 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
session variables timing out
I have a site with 2 sections. The members only directory uses the application scope with session variables and the general public directories are all html files without any application.cfm. If a user goes from the member site to the public site and is active in the public site does that activity postpone the session variables timing out in the member site? My guess is no. 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
book review request
Anyone got a personal review of the baok Business Intelligence with Coldfusion Is it worth buying? 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
