Pro Bono help on Registration Form for Kids with Brain Damage
HI, I am a Web designer who has found this list to be one of the best for CF help. I am a part of a small team working free to put together a conference this spring, Alternative Therapies for Special Kids (www.4healthykids.org) The conference's focus are alternative health approaches for kids with brain disorders and brain damage. The CF registration form that is critical to the conference is not acting right. It registers to a certain number, but then never goes higher. I have a boat-load of work on my plate for this conference. If there is anyone out there who might have an hour or two for a truly worthy cause, this CF problem would be an easy fix for one of the gurus. The best I can do is a couple of hours of Web design (and a t-shirt from the conference) as a swap. Please contact me off-list if you think you can help. Many thanks. Darien C. Small Technical Information Officer iExpediter www.iexpediter.com [EMAIL PROTECTED] Bringing style and functionality to e-commerce. 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: which is the best way to do auto retrieval of Address...
thanx ppl!! problem solved! but hmm.. anyone know how to hide the popup.. under the parent page.. so that the user dun even know theres a pop up to generate it...??!! HAPPY MAN, han - Original Message - From: Steve Oliver [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 28, 2002 1:29 AM Subject: RE: which is the best way to do auto retrieval of Address... Yes you could do that, in the onchange paramater of the select box have it popup a new window. Do the query in that new window, then user the following javascript. script opener.formname.streetname = 'qry.StreetName'; opener.formname.city = 'qry.City'; /script If the form isn't named, and you only have 1 form on your page, you can use opener.forms[0].streetname Although this will cause a popup to show and disappear, I think a better way would be to just navigate to the same page with ?zip=12345 at the end of it. You'd have to cfparam all of your form fields this way, like cfparam name=thisform.FirstName default= Then in the form, input type=text name=FirstName value=#thisform.FirstName# At the top of the page you'd need to do something like. cfif isDefined(FORM.postalcode) cfset thisform = StructCopy(FORM) /cfif That will copy everything submitted through the form into the thisform structure, so if they filled out half of the form before selecting a postal code, it will load it all in the form. _ steve oliver senior internet developer atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: han peng [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 2:19 AM To: CF-Talk Subject: Re: which is the best way to do auto retrieval of Address... hmm.. are u saying... upon selected a postal code.. i callup a popup page which will perform a cfquery and do a matching... then pass back the matched value back to parent?? can I do that..?? if can... how shld i pass the value to and fro child and parent page...?? cheers han - Original Message - From: Robert Obreczarek [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 2:44 PM Subject: RE: which is the best way to do auto retrieval of Address... How about using frames? maybe an iframe/ilayer. that way you could click on a name, and the info would pop in a another frame Robert -Original Message- From: han peng [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 10:13 PM To: CF-Talk Subject: which is the best way to do auto retrieval of Address... hi... i need to do a address input fields.. where customer can choose their postal code.. and his house number and streetname will be retrieved out automatically... the codes below actually can do the work.. but because theres about 100,000 data to be put into array...so it took almost like a minute to load a page sigh... anyone have a better idea.? i did it this way coz customer wan to retrieve the data instantly.. thanx han Javascript function: function display_Street(box1, box2) { var TotalStreetArray = box2.length; for(i=0; iTotalStreetArray; i++) { if(box2[i][0] == box1) { document.form.strStreetName.value = box2[i][1]; document.form.strBlockNumber.value = box2[i][2]; } } } !--- Database Queries --- CFQUERY name=PostalCode_list datasource=#request.DSN# cachedwithin=#CreateTimeSpan(0, 6, 0, 0)# SELECT a.strPostalCode, a.strBlockNumber, b.strStreetName From tblPostalCode a, tblStreet b WHERE a.strStreetNumber = b.strStreetNumber ORDER BY a.strPostalCode /CFQUERY cfset StreetName_array = arraynew(2) CFSET i =1 CFLOOP query=PostalCode_list cfset StreetName_array[i][1] = #trim(strPostalCode)# cfset StreetName_array[i][2] = #trim(strStreetName)# cfset StreetName_array[i][3] = #trim(strBlockNumber)# CFSET i = i + 1 /CFLOOP CFWDDX INPUT=#StreetName_array# OUTPUT=MyWDDXPacket ACTION=CFML2WDDX CFWDDX INPUT=#MyWDDXPacket# OUTPUT=DynamicJSCode ACTION=WDDX2JS TOPLEVELVARIABLE=StreetName_array scriptcfoutput#DynamicJSCode#/cfoutput/script table width=100% border=0 cellspan=0 tr td width=5%BLK/HSE NO./td td width=25%cfinput type=text name=strBlockNumber size=5 maxlength=5 message=Please enter your Block / House Number. required=Yes onerror=setFocus value=#session.prospect.strBlockNumber#/td td width=5%FLR./td td width=25%cfinput type=text name=strFloorNumber size=5 maxlength=5 message=Please enter your Floor Number. required=No value=#session.prospect.strFloorNumber#/td td width=5%UNIT/td td width=25%cfinput type=text name=strUnitNumber size=5 maxlength=5 message=Please enter your Unit Number. required=No value=#session.prospect.strUnitNumber#/td td
Auto running of Codes to update data..
hihi hmm my customer required a booking request whereby the booking will be automatically cancelled after 3 days if it is not confirmed i have a Status Column for that booking table and a Booking Date column so how do i enable the system to automatically update the status column ?? eg tblRoom= 1 RoomID01 Booked 25/02/2002 2 RoomID02 Booked 25/02/2002 3 RoomID03 Confirmed 25/02/2002 4 RoomID04 Available 25/02/2002 5 RoomID05 Available 25/02/2002 today's is 28/02/2002 so system is to run thru the database and update data 1 and 2 to available and date to 28/02/2002 hmm can i use CF server scheduled task to do it?? or is there any such tool at Database side?? i'm using mssql 2000 thanx han __ 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=coldfusiona FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
Problem query
Hi all This was obviously a tricky question since I got no response - so I'll repost it below BTW the tables aren't set in stone - they could be redesigned to make this work I need to display teaching resources assigned to a course Each course should show: All resource names, and the total number of each resource booked on that date Right now there are three tables: resources (resource_id, description, total_available) resources allocated: (allocation_id, resource_id, event_id) and events with event_id and event_date So far the closest I've got is cfquery name=GetRecord datasource=#variablesdatabase# SELECT DISTINCT SUM(Resource_AllocationResource_Id)AS Booked,ResourcesTotal_Available, ResourcesDescription, EventsEvent_Date FROM Events,Resources,Resource_Allocation WHERE Resource_AllocationResource_Id = ResourcesResource_Id ANDResource_AllocationEvent_Id = EventsEvent_Id ANDEventsEvent_Date = #variablesEventDate# GROUP BY ResourcesDescription, ResourcesTotal_Available,EventsEvent_Date /cfquery But this only shows the resources booked for that day, not the whole list of resources I'm grateful if anyone can help Crispin Ryan __ 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: Auto running of Codes to update data..
If you are using SQL Server, then I think the best way would be to set up a trigger is sql server that will do the checking. -Original Message- From: han peng [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 10:21 AM To: CF-Talk Subject: Auto running of Codes to update data.. hihi... hmm.. my customer required a booking request whereby the booking will be automatically cancelled after 3 days if it is not confirmed. i have a Status Column for that booking table and a Booking Date column... so.. how do i enable the system to automatically update the status column ?? eg tblRoom 1. RoomID01 Booked 25/02/2002 2. RoomID02 Booked 25/02/2002 3. RoomID03 Confirmed 25/02/2002 4. RoomID04 Available 25/02/2002 5. RoomID05 Available 25/02/2002 today's is 28/02/2002.. so system is to run thru the database and update data 1 and 2 to available and date to 28/02/2002 hmm.. can i use CF server scheduled task to do it...?? or is there any such tool at Database side..?? i'm using mssql 2000... thanx han __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: SMB 2.0 Language Help
The language file is simply a list of variables. Each one represents a different string that appears in the application. The work is swapping out each native string in your application with a variable. Tedious and time-consuming... To switch languages, if Application.cfm sees the language variable, it then includes that language file and sets a cookie so that that users default language is that language. In SMB, you can switch back and forth on the fly from any page and your choice will stick. If i prepare a file like the one you listed, how do i setup a cold fusion page to display different languages? thanks chad Ok, I've got the Simple Message Board 2.0 language files available for download: http://www.simplemessageboard.com/download/smb_2B1_language.zip If anyone can help me by finishing the Spanish translation and by creat ing any other language files, that'd be great... Tony Schreiber, Senior Partner Man and Machine, Limite d mailto:[EMAIL PROTECTED] http://www.technocraft.co m http://www.simplemessageboard.com ___Free Forum Software for Cold Fusio n http://www.is300.net ___The Enthusiast's Home of the Lexus IS30 0 http://www.digitacamera.com __DigitA Camera Scripts and Tip s http://www.linklabexchange.com _Miata Link ECU Data Exchang e __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: SMB 2.0 Language Help
What is bork bork bork? Look in the preferences on Google, now that's a language pack :) They even have elmer fudd, Klingon, and bork bork bork! in there, lol _ steve oliver senior internet developer atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Eric J Hoffman [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 12:53 AM To: CF-Talk Subject: RE: SMB 2.0 Language Help well, if you have someone to do German, we'll do french. Heck , italian and russian. Lets go nuts. If we don't know it, babelfish it. LOL Regards, Eric J. Hoffman Director of Internet Development DataStream Connexion, LLC (formerly Small Dog Design) -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 11:05 PM To: CF-Talk Subject: RE: SMB 2.0 Language Help That'd be great, someone on the demo forum offered to do the German file, might want to coordinate efforts. Yes, just follow the same format - I recommend just copying the English file and then working your way down... I'll bundle anything you want in the language pack, pig latin, ebonics, Brit slang... We may give a shot at German and French...just follow the same format as the current files? (we had a request for british english too, 'cause us yank s talk too bloody funny) Regards, Eric J. Hoffman Director of Internet Development DataStream Connexion, LLC (formerly Small Dog Design) -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 9:27 PM To: CF-Talk Subject: SMB 2.0 Language Help Ok, I've got the Simple Message Board 2.0 language files available for download: http://www.simplemessageboard.com/download/smb_2B1_language.zip If anyone can help me by finishing the Spanish translation and by creatin g any other language files, that'd be great... Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.linklabexchange.com _Miata Link ECU Data Exchange __ 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://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
DLLHOST. EXE EATING RESOURCES!!
Hi, I am having some performance issues on a server hosting a CF app. Basically at certain times of the day the DLLhost.exe is over 1 GIG in size! Has anyone experienced this before, and if so whats the work round (let me guess, lock all session/application variables) : ) Nick. -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: 28 February 2002 11:49 To: CF-Talk Subject: RE: SMB 2.0 Language Help What is bork bork bork? Look in the preferences on Google, now that's a language pack :) They even have elmer fudd, Klingon, and bork bork bork! in there, lol _ steve oliver senior internet developer atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Eric J Hoffman [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 12:53 AM To: CF-Talk Subject: RE: SMB 2.0 Language Help well, if you have someone to do German, we'll do french. Heck , italian and russian. Lets go nuts. If we don't know it, babelfish it. LOL Regards, Eric J. Hoffman Director of Internet Development DataStream Connexion, LLC (formerly Small Dog Design) -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 11:05 PM To: CF-Talk Subject: RE: SMB 2.0 Language Help That'd be great, someone on the demo forum offered to do the German file, might want to coordinate efforts. Yes, just follow the same format - I recommend just copying the English file and then working your way down... I'll bundle anything you want in the language pack, pig latin, ebonics, Brit slang... We may give a shot at German and French...just follow the same format as the current files? (we had a request for british english too, 'cause us yank s talk too bloody funny) Regards, Eric J. Hoffman Director of Internet Development DataStream Connexion, LLC (formerly Small Dog Design) -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 9:27 PM To: CF-Talk Subject: SMB 2.0 Language Help Ok, I've got the Simple Message Board 2.0 language files available for download: http://www.simplemessageboard.com/download/smb_2B1_language.zip If anyone can help me by finishing the Spanish translation and by creatin g any other language files, that'd be great... Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.linklabexchange.com _Miata Link ECU Data Exchange __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
Problem connecting to SQl Server datasource
Hi, I am trying to connect to a SQL Server database and keep getting the following error: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection No matter what user I create etc I cannnot connect. Any help appreciated. Nick -Original Message- From: Crispin Ryan [mailto:[EMAIL PROTECTED]] Sent: 28 February 2002 10:38 To: CF-Talk Subject: Problem query Hi all This was obviously a tricky question since I got no response - so I'll repost it below. BTW the tables aren't set in stone - they could be redesigned to make this work. I need to display teaching resources assigned to a course. Each course should show: All resource names, and the total number of each resource booked on that date. Right now there are three tables: resources (resource_id, description, total_available) resources allocated: (allocation_id, resource_id, event_id) and events with event_id and event_date So far the closest I've got is cfquery name=GetRecord datasource=#variables.database# SELECT DISTINCT SUM(Resource_Allocation.Resource_Id)AS Booked,Resources.Total_Available, Resources.Description, Events.Event_Date FROM Events,Resources,Resource_Allocation WHERE Resource_Allocation.Resource_Id = Resources.Resource_Id ANDResource_Allocation.Event_Id = Events.Event_Id ANDEvents.Event_Date = #variables.EventDate# GROUP BY Resources.Description, Resources.Total_Available,Events.Event_Date /cfquery But this only shows the resources booked for that day, not the whole list of resources I'm grateful if anyone can help Crispin Ryan __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
Verity Search Results
A verity collection I have has about 16,000 records, pulled from three fields in a database (ID, publication, keywords). I've set the CFIndex Body=publication, keywords, and the title to publication Problem - for some searches using a single term, where I know there should be about 9,000 results, I get none. However, doing a search on a term where I know there are fewer, say 4-5,000 I get the proper results. Question - Is there an upper limit to returned results, and is there a setting or something else to correct this? Thanks, Mark -- Mark Leder, [EMAIL PROTECTED] on 02/28/2002 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
CFABORT template, not all CF processing?
Hello, I was wondering if there is a way to abort a particular CF Template, but not all CF processing? Right now I'm wrapping my code with CFIF tags which determine if the code will run or not CFIF animal IS dog run a bunch of code run a bunch of code run a bunch of code run a bunch of code run a bunch of code /CFIF __ 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=coldfusiona FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
CFABORT template, not all CF processing?
Sorry about that last one, I guess it's dangerous to hit tab and enter rapidly I was wondering if there is a way to abort a particular CF Template, but not all CF processing? Right now I'm wrapping my code with CFIF tags which determine if the code will run or not CFIF animal IS dog run a bunch of code run a bunch of code run a bunch of code run a bunch of code run a bunch of code /CFIF !--- end of template --- I'd rather do this: CFIF animal IS NOT dog CFABORT /CFIF But I don't want to abort ALL cf processing, only the template that it currently running Is this an option? Thanks, and sorry again about the first draft of this email- Lou __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://wwwpennyhostcom/redirectcfm?adcode=coldfusionc FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
RE: CFABORT template, not all CF processing?
Try using CFEXIT HTH -Original Message- From: Louis Klepner [mailto:[EMAIL PROTECTED]] Sent: 28 February 2002 13:38 To: CF-Talk Subject: CFABORT template, not all CF processing? Sorry about that last one, I guess it's dangerous to hit tab and enter rapidly... I was wondering if there is a way to abort a particular CF Template, but not all CF processing? Right now I'm wrapping my code with CFIF tags which determine if the code will run or not. CFIF animal IS dog run a bunch of code run a bunch of code run a bunch of code run a bunch of code run a bunch of code /CFIF !--- end of template --- I'd rather do this: CFIF animal IS NOT dog CFABORT /CFIF But I don't want to abort ALL cf processing, only the template that it currently running... Is this an option? Thanks, and sorry again about the first draft of this email- Lou __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: CFABORT template, not all CF processing?
Thank, I suppose I'm due for a RTFM on this one :) Lou -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mike Town end Sent: Thursday, February 28, 2002 8:44 AM To: CF-Talk Subject: RE: CFABORT template, not all CF processing? Try using CFEXIT HTH -Original Message- From: Louis Klepner [mailto:[EMAIL PROTECTED]] Sent: 28 February 2002 13:38 To: CF-Talk Subject: CFABORT template, not all CF processing? Sorry about that last one, I guess it's dangerous to hit tab and ente r rapidly... I was wondering if there is a way to abort a particular CF Template, but not all CF processing? Right now I'm wrapping my code with CFIF tags which determine if the code will run or not. CFIF animal IS dog run a bunch of code run a bunch of code run a bunch of code run a bunch of code run a bunch of code /CFIF !--- end of template --- I'd rather do this: CFIF animal IS NOT dog CFABORT /CFIF But I don't want to abort ALL cf processing, only the template that i t currently running... Is this an option? Thanks, and sorry again about the first draft of this email- Lou _ _ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: CFREPORT :: (CRPE32.DLL) could not be located
Hey Paul, I struggled with CFREPORT for a while and when I got it to work I found t he results were really not professional. If you look thru the archives you'l l see that most peopel are not getting what they want. So I took the advice of someone on this list and puchased Recrystalize. A n excellent product. It produces the input form and the processsing page fo r your reportand is able to open ActiveX, DHTML, or Java viewers. The resul t for your audience is professional. Yes you will need to install at least CR 8.0 on your CF server as it uses it's objects. One important note is that Recrystalize produces ASP pages. We basically re-write the Input form with CF and use the ASP page for the processing. Works beautifully! Worth every cent! Hope this helps, Frank Mamone Supervisor, Web Development STS, part of the NSB Group - Original Message - From: Paul Ihrig [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 9:33 AM Subject: CFREPORT :: (CRPE32.DLL) could not be located ok? where do i get this dll? i thought cfreport was standard in 5? first time messing with it. do i actually need crystal on my local machine to test some one else's report? thanks -paul Error occurred while processing CFREPORT The Crystal Reports Engine (CRPE32.DLL) could not be located on this server. ColdFusion's reporting functionality requires the Crystal Engine. Pleas e verify that you have installed this component before using the CFREPORT tag. Crystal Library = () DLL Version = , Engine Version= The error occurred while processing an element with a general identifie r of __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
How do I conect a web server to a sql server?
I have 2 boxes One is a Win 2k web server and the other is a Win 2k SQL server I need to get the web server talking to the SQL server so I can get CFServer 5 hooked up Can some one give me a quick how to or send me a link to some place that can help? I have 3 different books been all over the knowledge base and crawled iisfaqcom but cant find anything to do this Then again it was late and I could have looked right over it Thanks Phillip Broussard Tracker Marine Group 417-873-5957 __ 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: How do I conect a web server to a sql server?
The web server doesn't connect to SQL Server, your db middleware, in this case Cold Fusion, connects to the SQL Server I have 2 boxes One is a Win 2k web server and the other is a Win 2k SQL server I need to get the web server talking to the SQL server so I can get CFServer 5 hooked up Can some one give me a quick how to or send me a link to some place that can help? I have 3 different books been all over the knowledge base and crawled iisfaqcom but cant find anything to do this Then again it was late and I could have looked right over it Thanks Phillip Broussard Tracker Marine Group 417-873-5957 __ 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=coldfusiona FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
RE: CFREPORT :: (CRPE32.DLL) could not be located
How much does Recrystalize cost? T -Original Message- From: Frank Mamone [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 8:37 AM To: CF-Talk Subject: Re: CFREPORT :: (CRPE32.DLL) could not be located Hey Paul, I struggled with CFREPORT for a while and when I got it to work I found t he results were really not professional. If you look thru the archives you'l l see that most peopel are not getting what they want. So I took the advice of someone on this list and puchased Recrystalize. A n excellent product. It produces the input form and the processsing page fo r your reportand is able to open ActiveX, DHTML, or Java viewers. The resul t for your audience is professional. Yes you will need to install at least CR 8.0 on your CF server as it uses it's objects. One important note is that Recrystalize produces ASP pages. We basically re-write the Input form with CF and use the ASP page for the processing. Works beautifully! Worth every cent! Hope this helps, Frank Mamone Supervisor, Web Development STS, part of the NSB Group - Original Message - From: Paul Ihrig [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 9:33 AM Subject: CFREPORT :: (CRPE32.DLL) could not be located ok? where do i get this dll? i thought cfreport was standard in 5? first time messing with it. do i actually need crystal on my local machine to test some one else's report? thanks -paul Error occurred while processing CFREPORT The Crystal Reports Engine (CRPE32.DLL) could not be located on this server. ColdFusion's reporting functionality requires the Crystal Engine. Pleas e verify that you have installed this component before using the CFREPORT tag. Crystal Library = () DLL Version = , Engine Versio= The error occurred while processing an element with a general identifie r of __ 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://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: Problem query
Sounds like you are doing the wrong kind of join. When you want all the records from one table (in your case resources) and only those record s from the other table that match (in your case events) that calls for INNER , OUTER, LEFT and/or RIGHT joins. Here is an example from Access that should select the type of data yo u want. I didn't have any sample data so I'm guessing a little bit. You shou ld be able to add your necessary SUM and GROUP BY elements to this query. SELECT resources_allocation.resource_id, resources.total_available, resources.description, events.eventDate FROM (resources LEFT JOIN resources_allocation ON resources.resource_id= resources_allocation.resource_id) INNER JOIN events ON resources_allocation.event_id = events.event_I D; If you need a bit more help. Feel free to contact me off list. If I had a sampling of the data your using I could refine the query more. Ian Skinner Web Developer www.ilsweb.com - Original Message - From: Crispin Ryan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 28, 2002 2:37 AM Subject: Problem query Hi all This was obviously a tricky question since I got no response - so I 'll repost it below. BTW the tables aren't set in stone - they could be redesigned to make this work. I need to display teaching resources assigned to a course. Each course should show: All resource names, and the total number of each resource booked on that date. Right now there are three tables: resources (resource_id, description, total_available) resources allocated: (allocation_id, resource_id, event_id) and events with event_id and event_date So far the closest I've got is cfquery name=GetRecord datasource=#variables.database# SELECT DISTINCT SUM(Resource_Allocation.Resource_Id)AS Booked,Resources.Total_Available, Resources.Description, Events.Eve nt_Date FROM Events,Resources,Resource_Allocation WHERE Resource_Allocation.Resource_Id = Resources.Resource_Id ANDResource_Allocation.Event_Id = Events.Event_Id ANDEvents.Event_Date = #variables.EventDate# GROUP BY Resources.Description, Resources.Total_Available,Events.Event_Date /cfquery But this only shows the resources booked for that day, not the whol e list of resources I'm grateful if anyone can help Crispin Ryan ___ ___ 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://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Synchronization Error
A web user on my site got the below error, I can't reproduce it. Does anybody know what this means or what could be causing it? Thanks. -- Error Occurred While Processing Request Error Diagnostic Information Synchronization error. Please paste the text of this error into a mail message to the system administrator. The service timed-out waiting for the operating system's attempt to guarantee one thread mutually exclusive access to generate a unique Cold Fusion client ID. The error occurred while processing an element with a general identifier of (CFAPPLICATION), occupying document position (3:1) to (6:47) in the template file D:\Inetpub\wwwroot\mediapost\Application.cfm. -- Mark Kecko The Computer Guy MediaPost Communications [EMAIL PROTECTED] http://www.mediapost.com (203)222-0330 ext309 Imagination is the one weapon in the war against reality. Jules de Gaultier __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: How do I conect a web server to a sql server?
If your Web server is outside you firewall (in a DMZ) and your database server is behind the firewall (Intranet) you may have to open a port in your firewall to allow your Web server to talk to your database server. Hope this helps, Nicholas W. Watson Software Engineer Concurrent Technologies Corporation Email: [EMAIL PROTECTED] Phone: (814) 269-2653 -Original Message- From: Phillip Broussard [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 10:07 AM To: CF-Talk Subject: How do I conect a web server to a sql server? I have 2 boxes. One is a Win 2k web server and the other is a Win 2k SQL server. I need to get the web server talking to the SQL server so I can get CFServer 5 hooked up. Can some one give me a quick how to or send me a link to some place that can help? I have 3 different books been all over the knowledge base and crawled iisfaq.com but cant find anything to do this. Then again it was late and I could have looked right over it. Thanks Phillip Broussard Tracker Marine Group 417-873-5957 __ 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://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: How do I conect a web server to a sql server?
On 2/28/02, Phillip Broussard penned: I have 2 boxes. One is a Win 2k web server and the other is a Win 2k SQL server. I need to get the web server talking to the SQL server so I can get CFServer 5 hooked up. Can some one give me a quick how to or send me a link to some place that can help? I have 3 different books been all over the knowledge base and crawled iisfaq.com but cant find anything to do this. Then again it was late and I could have looked right over it. You need to install the SQL Server client network utility on the Web/CF server. Set up an alias using TCP/IP in that to the SQL Server IP Address. Then go into ColdFusion Administrator, set up an ODBC datasource using SQL Server. Enter the database name, the login and password and you can then talk to the database using the datasource name. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ __ 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://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: Problem query
Crispin, Aren't you only asking for resources booked on a particular date: Events.Event_Date = #variables.EventDate#? Wouldn't it be better to Order By or Group By #variables.EventDate# and remove the #variables.EventDate# from the Where clause? This would give you all the resources for that date not just those booked. andy -Original Message- From: Crispin Ryan [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 5:38 AM To: CF-Talk Subject: Problem query Each course should show: All resource names, and the total number of each resource booked on that date. Right now there are three tables: resources (resource_id, description, total_available) resources allocated: (allocation_id, resource_id, event_id) and events with event_id and event_date So far the closest I've got is cfquery name=GetRecord datasource=#variables.database# SELECT DISTINCT SUM(Resource_Allocation.Resource_Id)AS Booked,Resources.Total_Available, Resources.Description, Events.Event_Date FROM Events,Resources,Resource_Allocation WHERE Resource_Allocation.Resource_Id = Resources.Resource_Id ANDResource_Allocation.Event_Id = Events.Event_Id ANDEvents.Event_Date = #variables.EventDate# GROUP BY Resources.Description, Resources.Total_Available,Events.Event_Date /cfquery But this only shows the resources booked for that day, not the whole list of resources I'm grateful if anyone can help Crispin Ryan __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
CyberCash
Ok I am sure this has been discussed before but I am going to send a message anyway then I will go search the archives. :) Anyway I have a client who INSISTS on using Cybercash, so don't even recommend going w/ someone else, already tried that. I am sure they will switch once they see how slow they are. Anyway I know there are a few CyberCash tags out there for CF. However, I have never used one myself so thought I would ask for some recommendations on the best one out there. Preferably a FREE one. :) -Kelly ~~ Kelly Matthews Senior Programmer [EMAIL PROTECTED] http://www.allsoldout.net 703.387.4000 x 35 ~~ __ 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://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: CyberCash
www.verisign.com. They own cybercash. Call them for the latest and greatest. Mike -Original Message- From: Kelly Matthews [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 11:03 AM To: CF-Talk Subject: CyberCash Ok I am sure this has been discussed before but I am going to send a message anyway then I will go search the archives. :) Anyway I have a client who INSISTS on using Cybercash, so don't even recommend going w/ someone else, already tried that. I am sure they will switch once they see how slow they are. Anyway I know there are a few CyberCash tags out there for CF. However, I have never used one myself so thought I would ask for some recommendations on the best one out there. Preferably a FREE one. :) -Kelly ~~ Kelly Matthews Senior Programmer [EMAIL PROTECTED] http://www.allsoldout.net 703.387.4000 x 35 ~~ __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How do I conect a web server to a sql server?
Can the Web server see the SQL server on the network? The setup is fairly simple: 1) Install CF on the Web server. 2) If necessary, install the latest SQL Server ODBC driver, freely available on M$'s Web site. 3) Use the CF administrator to set up an ODBC connection to the SQL Server. Something tells me there is a key piece of information missing Mike -Original Message- From: Phillip Broussard [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 10:07 AM To: CF-Talk Subject: How do I conect a web server to a sql server? I have 2 boxes. One is a Win 2k web server and the other is a Win 2k SQL server. I need to get the web server talking to the SQL server so I can get CFServer 5 hooked up. Can some one give me a quick how to or send me a link to some place that can help? I have 3 different books been all over the knowledge base and crawled iisfaq.com but cant find anything to do this. Then again it was late and I could have looked right over it. Thanks Phillip Broussard Tracker Marine Group 417-873-5957 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: CyberCash
We use CFX_Cybercash (available ... well just about everywhere, including the Macromedia Developer's exchange). Free and easy to configure. Have not found it to be slow. Only issues we have are with Cybercash's admin, which is a whole different ball of wax. But if you need to use Cybercash, CFX_Cybercash works really well. Good luck, Matt On 2/28/2002 11:02 AM, Kelly Matthews [EMAIL PROTECTED] wrote: Ok I am sure this has been discussed before but I am going to send a message anyway then I will go search the archives. :) Anyway I have a client who INSISTS on using Cybercash, so don't even recommend going w/ someone else, already tried that. I am sure they will switch once they see how slow they are. Anyway I know there are a few CyberCash tags out there for CF. However, I have never used one myself so thought I would ask for some recommendations on the best one out there. Preferably a FREE one. :) -Kelly ~~ Kelly Matthews Senior Programmer [EMAIL PROTECTED] http://www.allsoldout.net 703.387.4000 x 35 ~~ __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Moving MSSQL DB from Dev to Prod
What's the typical way to copy one's development DB to production (SQL2000)? Changes will commonly be made on Dev, and there will be an existing version on production which will need to be overwritten I know about the copy database wizard, but AFAIK, it doesn't work if the DB already exists on the production server Finally, is there a resource concerning general CF/MSSQL interaction issues and best practices? Thanks, Jamie __ 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: CyberCash
We are using Payflow they are verisine also. -Original Message- From: Matt Kornguth [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 10:31 AM To: CF-Talk Subject: Re: CyberCash We use CFX_Cybercash (available ... well just about everywhere, including the Macromedia Developer's exchange). Free and easy to configure. Have not found it to be slow. Only issues we have are with Cybercash's admin, which is a whole different ball of wax. But if you need to use Cybercash, CFX_Cybercash works really well. Good luck, Matt On 2/28/2002 11:02 AM, Kelly Matthews [EMAIL PROTECTED] wrote: Ok I am sure this has been discussed before but I am going to send a message anyway then I will go search the archives. :) Anyway I have a client who INSISTS on using Cybercash, so don't even recommend going w/ someone else, already tried that. I am sure they will switch once they see how slow they are. Anyway I know there are a few CyberCash tags out there for CF. However, I have never used one myself so thought I would ask for some recommendations on the best one out there. Preferably a FREE one. :) -Kelly ~~ Kelly Matthews Senior Programmer [EMAIL PROTECTED] http://www.allsoldout.net 703.387.4000 x 35 ~~ __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How do I conect a web server to a sql server?
use the client configuration manager to create a friendly servername for your sql server. type cliconfg in the run box on the start menu. Under the alias tab, create a new alias pointing to the SQL server's IP and make sure network Lib's are on TCP/IP (if thats what you want) In CF admin, enter the alias you created as the server name. - j -Original Message- From: Haggerty, Michael A. [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 11:27 AM To: CF-Talk Subject: RE: How do I conect a web server to a sql server? Can the Web server see the SQL server on the network? The setup is fairly simple: 1) Install CF on the Web server. 2) If necessary, install the latest SQL Server ODBC driver, freely available on M$'s Web site. 3) Use the CF administrator to set up an ODBC connection to the SQL Server. Something tells me there is a key piece of information missing Mike -Original Message- From: Phillip Broussard [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 10:07 AM To: CF-Talk Subject: How do I conect a web server to a sql server? I have 2 boxes. One is a Win 2k web server and the other is a Win 2k SQL server. I need to get the web server talking to the SQL server so I can get CFServer 5 hooked up. Can some one give me a quick how to or send me a link to some place that can help? I have 3 different books been all over the knowledge base and crawled iisfaq.com but cant find anything to do this. Then again it was late and I could have looked right over it. Thanks Phillip Broussard Tracker Marine Group 417-873-5957 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFOBJECT and Excel Column widths
The simple answer is no, not just with CFCONTENT. You would need to use a COM object or create the page via VBScript in order to make this happen. In your VB code, you will end up creating an object based on the column you are trying to choose. I think the command is: obj.autoresize You can verify this by recording a macro where you autoresize the column. Sorry, Mike -Original Message- From: Tristram Charnley [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 10:02 AM To: CF-Talk Subject: CFOBJECT and Excel Column widths I've been using cfcontent to output query results in Excel. My client now wants the width of the spreadsheet columns being generated to automatically size to the length of the longest string returned from the query. Does anyone know whether this is possible, maybe with cfobject? No luck so far with cfcomet. Tristram Charnley --- [EMAIL PROTECTED] Allaire Certified ColdFusion Developer __ 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://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: Moving MSSQL DB from Dev to Prod
Backup your dev database to a file, upload it to live server, and force a restore over the current db, works for me. -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED]] Sent: 28 February 2002 16:37 To: CF-Talk Subject: Moving MSSQL DB from Dev to Prod What's the typical way to copy one's development DB to production (SQL2000)? Changes will commonly be made on Dev, and there will be an existing version on production which will need to be overwritten. I know about the copy database wizard, but AFAIK, it doesn't work if the DB already exists on the production server. Finally, is there a resource concerning general CF/MSSQL interaction issues and best practices? Thanks, Jamie __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: CFREPORT :: (CRPE32.DLL) could not be located
Here you go: http://www.recrystallize.com/merchant/orderform.htm - Original Message - From: Tammy Hong [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 28, 2002 10:26 AM Subject: RE: CFREPORT :: (CRPE32.DLL) could not be located How much does Recrystalize cost? T -Original Message- From: Frank Mamone [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 8:37 AM To: CF-Talk Subject: Re: CFREPORT :: (CRPE32.DLL) could not be located Hey Paul, I struggled with CFREPORT for a while and when I got it to work I found t he results were really not professional. If you look thru the archives you 'l l see that most peopel are not getting what they want. So I took the advice of someone on this list and puchased Recrystalize. A n excellent product. It produces the input form and the processsing page fo r your reportand is able to open ActiveX, DHTML, or Java viewers. The res ul t for your audience is professional. Yes you will need to install at least CR 8.0 on your CF server as it us es it's objects. One important note is that Recrystalize produces ASP page s. We basically re-write the Input form with CF and use the ASP page for the processing. Works beautifully! Worth every cent! Hope this helps, Frank Mamone Supervisor, Web Development STS, part of the NSB Group - Original Message - From: Paul Ihrig [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 9:33 AM Subject: CFREPORT :: (CRPE32.DLL) could not be located ok? where do i get this dll? i thought cfreport was standard in 5? first time messing with it. do i actually need crystal on my local machine to test some one else' s report? thanks -paul Error occurred while processing CFREPORT The Crystal Reports Engine (CRPE32.DLL) could not be located on this server. ColdFusion's reporting functionality requires the Crystal Engine. Ple as e verify that you have installed this component before using the CFREPO RT tag. Crystal Library = () DLL Version = , Engine Versi= The error occurred while processing an element with a general identif ie r of __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CyberCash
If they are setting up a new account with Verisign, they will ONLY be able to get PayFlowPro as Cybercash is being phased out. Shawnea - Original Message - From: Kelly Matthews [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 28, 2002 11:02 AM Subject: CyberCash Ok I am sure this has been discussed before but I am going to send a message anyway then I will go search the archives. :) Anyway I have a client who INSISTS on using Cybercash, so don't even recommend going w/ someone else, already tried that. I am sure they will switch once they see how slow they are. Anyway I know there are a few CyberCash tags out there for CF. However, I have never used one myself so thought I would ask for some recommendations on the best one out there. Preferably a FREE one. :) -Kelly ~~ Kelly Matthews Senior Programmer [EMAIL PROTECTED] http://www.allsoldout.net 703.387.4000 x 35 ~~ __ 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://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
Fusebox Question
I'm evaluating whether to use Fusebox methodology for our next Intranet My question is how does fusebox work with CF Advanced Security? We use our NT Security groups for many of our apps Don't want to lose that Thanks __ 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: CyberCash
As I clearly stated they are NOT switching they already have Cybercash. Looking for a Cybercash tag... So for now they will stick with that if Verisign makes them switch later they will have to deal with that at the time. -KLM [EMAIL PROTECTED] writes: If they are setting up a new account with Verisign, they will ONLY be able to get PayFlowPro as Cybercash is being phased out. ~~ Kelly Matthews Senior Programmer [EMAIL PROTECTED] http://www.allsoldout.net 703.387.4000 x 35 ~~ __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Fusebox Question
Fusebox isn't really a changing of anything, all that it does it allow you to have a more thought out way of managing your code. It borrows things from oop where it applies. I use it as much as I can, I would not go back. It allows me to reuse code much easier. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Frank Mamone [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 11:48 AM To: CF-Talk Subject: Fusebox Question I'm evaluating whether to use Fusebox methodology for our next Intranet. My question is how does fusebox work with CF Advanced Security? We use our NT Security groups for many of our apps. Don't want to lose that. Thanks __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How do I conect a web server to a sql server?
Maybe I read the question wrong. But by web server I meant IIS, Apache, etc... How is a web server going to talk to a database? If his web server BOX can't see his SQL Server BOX, than that's simply a networking issue. I have to disagree with this to a point. If the web server cannot 'see' t he database server, then a DSN cannot see the database. Now if you are using CF 5 you can use the DSN attribute for DSNless conne ct ion. But even in this case, the web server still has to 'see' the databas e server to some degree. My 2 cents... Clint -- Original Message -- from: Tony Schreiber [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Thu, 28 Feb 2002 10:10:46 -0500 (EST) The web server doesn't connect to SQL Server, your db middleware, in this case Cold Fusion, connects to the SQL Server... I have 2 boxes. One is a Win 2k web server and the other is a Win 2k SQ L server. I need to get the web server talking to the SQL server so I can get CFServer 5 hooked up. Can some one give me a quick how to or send me a link to some place that can help? I have 3 different books been al l over the knowledge base and crawled iisfaq.com but cant find anything t o do this. Then again it was late and I could have looked right over it. Thanks Phillip Broussard Tracker Marine Group 417-873-5957 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Fusebox Question
For me, the concept of Fusebox is good, but in practicality it becomes a pain to debug... having to track back through ALL included files to find an error... -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 9:54 AM To: CF-Talk Subject: RE: Fusebox Question Fusebox isn't really a changing of anything, all that it does it allow you to have a more thought out way of managing your code. It borrows things from oop where it applies. I use it as much as I can, I would not go back. It allows me to reuse code much easier. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Frank Mamone [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 11:48 AM To: CF-Talk Subject: Fusebox Question I'm evaluating whether to use Fusebox methodology for our next Intranet. My question is how does fusebox work with CF Advanced Security? We use our NT Security groups for many of our apps. Don't want to lose that. Thanks __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: Fusebox Question
Lot's of ways to get around that... like including the template name in comments on each page. !-- Here's an example //-- Mike -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 12:02 PM To: CF-Talk Subject: RE: Fusebox Question For me, the concept of Fusebox is good, but in practicality it becomes a pain to debug... having to track back through ALL included files to find an error... -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 9:54 AM To: CF-Talk Subject: RE: Fusebox Question Fusebox isn't really a changing of anything, all that it does it allow you to have a more thought out way of managing your code. It borrows things from oop where it applies. I use it as much as I can, I would not go back. It allows me to reuse code much easier. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Frank Mamone [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 11:48 AM To: CF-Talk Subject: Fusebox Question I'm evaluating whether to use Fusebox methodology for our next Intranet. My question is how does fusebox work with CF Advanced Security? We use our NT Security groups for many of our apps. Don't want to lose that. Thanks __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Cybercash tag not found...
I went to the developers section and when I try to download CFX_Cybercash (which appears to download from Cybercash's site) it's not found. Does anyone have a copy? Also I just spoke w/ Verisign, while they are merging Cybercash with their existing service customers who have Cybercash will not have to change a thing, all their cyber cash settings will still work with the merged service. Just an FYI. -Kelly ~~ Kelly Matthews Senior Programmer [EMAIL PROTECTED] http://www.allsoldout.net 703.387.4000 x 35 ~~ __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
someone want to help me?
My boss wants me to spec out the process of taking credit card orders over the web I have limited experience with this and any help you guys can give me is appreciated Thanks, Steven D Dworman - Web Consultant Systems Administrator ComSpec International - http://wwwcomspec-intnlcom phone: 2486478841 cell: 7349729676 - EMPOWER-XL ***Software for Higher Education*** http://wwwempower-xlcom __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://wwwpennyhostcom/redirectcfm?adcode=coldfusionc FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
RE: someone want to help me?
Three stage process: 1. secure connection to enter info (card details) - either unique or third party vendor 2. checking system - either unique or third party vendor 3. paying system - either unique or third party vendor The best solution for a simple fix is to go with a third party vendor who will supply the SSL (secure connection), card checking system and payment system - of course this all comes at a fee... Depends on the vendor but usually around 2-4%. Good CF friendly easy to use solution is WORLDPAY... The unique solution is a longer term set-up and will still cost, but depends on what you want, it will involve getting an SSL (verity 128 bit encryption software) and dedicated IP address for it to sit on. It also involves getting hold of a internet card checking facility (usually supplied by a bank or card provider - you need to check on this as it's different for us in the UK) - you also will need an Internet Merchant account with a bank in order to make payments online to your account - via a system like ePDQ (Barclays in the UK for example) - again tho this will cost a percentage of the transaction and most of the companies that offer this service will expect a base rate return. HTH J -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 17:25 To: CF-Talk Subject: someone want to help me? My boss wants me to spec out the process of taking credit card orders over the web. I have limited experience with this and any help you guys can give me is appreciated. Thanks, Steven D Dworman - Web Consultant Systems Administrator ComSpec International - http://www.comspec-intnl.com phone: 248.647.8841 cell: 734.972.9676 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: someone want to help me?
The process is not very difficult. Set up a payment gateway and a merchant account. 1) The payment gateway is the service you use to verify the available credit. Verisign is a good service, and so is Stacy Young's company (sfcommerce.com). Call them to set up an account, and they will ask you about the next step. 2) A merchant account is the account the money goes into. They have a discount rate, a per-transaction charge, and a provider charge - these vary from service to service. Your own bank account may be able to act as a merchant account, so call your bank about this. Usually, the payment gateway will offer you something in terms of code to integrate with their network. I like Verisign because they give you a CF custom tag that works splendidly. Good luck Mike -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 12:25 PM To: CF-Talk Subject: someone want to help me? My boss wants me to spec out the process of taking credit card orders over the web. I have limited experience with this and any help you guys can give me is appreciated. Thanks, Steven D Dworman - Web Consultant Systems Administrator ComSpec International - http://www.comspec-intnl.com phone: 248.647.8841 cell: 734.972.9676 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Inserting a delimited list into a database
Oh yeah!!! You are absolutely correct! John, tell Matthew what he's won. ;) -Jake --- Matthew Walker [EMAIL PROTECTED] wrote: Hey ho! The problem is having a table called Update! Try wrapping [] around update. -Original Message- From: Jake Munson [mailto:[EMAIL PROTECTED]] Sent: Thursday, 28 February 2002 10:47 am To: CF-Talk Subject: Inserting a delimited list into a database I have a form that returns a comma delimited list of numbers from some checkboxes that each have the same name. I want to be able to insert a new record in a database for each checkbox that was checked in my form. I figured that if I used a list loop based on my checkbox list, that I could have a SQL query insert a record for each value in the list. But it keeps giving me an error on the insert query. Is it not possible to put a cfquery into a loop? Is there a better way to do this? Below is my code. Below that is the error I get. CFLOOP INDEX=ServerID LIST=#servers# DELIMITER=, cfquery datasource=Software Updates name=serverUpdate INSERT INTO update (log_id, server) VALUES (#logQuery.id#,#ServerID#) /cfquery /CFLOOP [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position... I thought that maybe the problem was that I didn't have a cfoutput around the #ServerID#, but that wasn't the problem either. Thanks for the help. -Jake __ Do You Yahoo!? Yahoo! Greetings - Send FREE e-cards for every occasion! __ 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://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: Fusebox Question
Shawn, For me, the concept of Fusebox is good, but in practicality it becomes a pain to debug having to track back through ALL included files to find an error Not sure what version of CF you are using, but CF4x and CF5 debug information gives the file name of the template where the error occurred, the route through included files , as well as the exact line and character on that line that the error occurred, so it shouldn't be that much of a problem Generally I find that Fusebox is easier to debug than other methods, simply because the code is in much more manageable chunks, generally with only one function in a template Not much to look back through and not much code to wade through Just my 2p on that aspect of Fusebox Regards Stephen __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://wwwpennyhostcom/redirectcfm?adcode=coldfusionc FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
RE: How do I conect a web server to a sql server?
You need to install the SQL Server client network utility on the Web/CF server Set up an alias using TCP/IP in that to the SQL Server IP Address Then go into ColdFusion Administrator, set up an ODBC datasource using SQL Server Enter the database name, the login and password and you can then talk to the database using the datasource name Actually, you don't have to install the SQL Server Client Network Utility It's just an interface to functionality that's already there You can do this from the ODBC Control Panel; just click on the Client Configuration button within the second page of the connection wizard Dave Watts, CTO, Fig Leaf Software http://wwwfigleafcom/ voice: (202) 797-5496 fax: (202) 797-5444 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://wwwpennyhostcom/redirectcfm?adcode=coldfusionc FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
RE: CFABORT template, not all CF processing?
I was wondering if there is a way to abort a particular CF Template, but not all CF processing? Right now I'm wrapping my code with CFIF tags which determine if the code will run or not Try using CFEXIT That'll only work if called from within a custom tag Otherwise, it'll simply abort the page Dave Watts, CTO, Fig Leaf Software http://wwwfigleafcom/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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: How do I conect a web server to a sql server?
Dave, I've found that installing he client utility improves my performance via ODBC. Is there a network library that's overwritten when you install it? That's always been my guess. Mark -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 9:49 AM To: CF-Talk Subject: RE: How do I conect a web server to a sql server? You need to install the SQL Server client network utility on the Web/CF server. Set up an alias using TCP/IP in that to the SQL Server IP Address. Then go into ColdFusion Administrator, set up an ODBC datasource using SQL Server. Enter the database name, the login and password and you can then talk to the database using the datasource name. Actually, you don't have to install the SQL Server Client Network Utility. It's just an interface to functionality that's already there. You can do this from the ODBC Control Panel; just click on the Client Configuration button within the second page of the connection wizard. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: CFABORT template, not all CF processing?
CFEXIT will, when called on a regular template (non-custom tag) allow onrequestend.cfm to still be processed.other than that, it behaves the same as cfabort, as Dave pointed out. ~Simon Simon Horwith Macromedia Certified Instructor Certified Advanced ColdFusion 5 Developer Fig Leaf Software 1400 16th St NW, # 500 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 12:51 PM To: CF-Talk Subject: RE: CFABORT template, not all CF processing? I was wondering if there is a way to abort a particular CF Template, but not all CF processing? Right now I'm wrapping my code with CFIF tags which determine if the code will run or not. Try using CFEXIT That'll only work if called from within a custom tag. Otherwise, it'll simply abort the page. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: Passing a constant to a COM object method from Cold Fusion
The short answer is, you can't The longer (and more useful) answer is to simply pass the value that the constant represents, instead of trying to pass the constant itself Just look up what wdRowHeightExactly contains (it's probably an integer) and pass that instead just wondered, is this the case for using COM with CF (in which case perhaps it should be documented) or does the same problem exist using COM in asp? In ASP, you'd typically have an include file which specifies the values of the constants, which is why it works You could do the same thing in CF, by using CFSET to initialize the constant, and then you could reference it within your code Dave Watts, CTO, Fig Leaf Software http://wwwfigleafcom/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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=coldfusiona FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
(WOT) I'm hooped: Need Network monitoring tools bad. (over my bandwidth quota!!!
Sorry for the arguably WOT post Well here's the problem I'm over my bandwidth quota My ISP changed how it did its billing in December, to squeeze the sponge a little harder if you will, and all of a sudden I am a bustin' out of my quota!!! Given all of this extra traffic - I need to do some accounting to see what is generating the traffic What are my options? I need something quick and dirty, and hopefully not too time consuming or expensive Actually my budget is $000 or thereabouts I want to be able to generate a daily detail report with the following information: IP Address service [http, ftp, mail, other, browsing] domain in traffic (in KB) out traffic (in KB) The network is simply - 4 boxes 1) Network Proxy: so the boys in the office can cruise the net 2) Exchange Server (mail: one domain) 3) Web Server / DNS Server (multiple domains) 4) Web Server / DNS Server / Mail Server (multiple domains) All connected to the same hub that the Internet connection comes in on The proxy connects to the Private network with a second NIC Can I set up a sniffer to do my reporting? Can I setup a filter on IIS to do my resource utilization logging? As an aside - I need a new proxy server, and I was thinking of installing a linux box - any suggestions on products or builds? I will install on a p200 or maybe a pII333 Hope I make sense _ MSN Photos is the easiest way to share and print your photos: http://photosmsncom/support/worldwideaspx __ 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=coldfusiona FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
RE: CFABORT template, not all CF processing?
What about cfexit method=EXITTEMPLATE? _ steve oliver senior internet developer atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Simon Horwith [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 12:54 PM To: CF-Talk Subject: RE: CFABORT template, not all CF processing? CFEXIT will, when called on a regular template (non-custom tag) allow onrequestend.cfm to still be processed.other than that, it behaves the same as cfabort, as Dave pointed out. ~Simon Simon Horwith Macromedia Certified Instructor Certified Advanced ColdFusion 5 Developer Fig Leaf Software 1400 16th St NW, # 500 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 12:51 PM To: CF-Talk Subject: RE: CFABORT template, not all CF processing? I was wondering if there is a way to abort a particular CF Template, but not all CF processing? Right now I'm wrapping my code with CFIF tags which determine if the code will run or not. Try using CFEXIT That'll only work if called from within a custom tag. Otherwise, it'll simply abort the page. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
What are these, headers?
Hi The text below is randomly appearing at the top of some of my web pages: HTTP/11 200 OK Server: Microsoft-IIS/50 Date: Thu, 28 Feb 2002 17:45:56 GMT Content-Type: text/html Accept-Ranges: bytes Last-Modified: Thu, 28 Feb 2002 17:44:15 GMT ETag: 90e1e5897fc0c11:1df0 Content-Length: 1991537 What is this? This text seems to appear only when I am using CFLocation to redirect to a static html page that I created through CFHTTP, and it occurs randomly However, I've learned through testing that if I use a Meta Refresh instead of a CFLocate, text does not appear (ie problem solved) However, I am still curious as to what is going on Plus, I like CFLocate better (no clicking in IE when page is redirected) Can anyone tell me what this is and how to guarantee its absence from my page? Below is my cfhttp code that generates the page the first time it accessed CFHTTP METHOD = get URL=#requestServerPath#/indexcfm?fuseaction=getCard#parms# PATH=e:\#requestroot#\Cache FILE=cache#NewID#html If the page is called is accessed again, Cflocation accesses the cached version of the page, and sometimes that wierd header shows up: CFIF CheckCacheRecordCount cflocation url=/cache/#checkcachefile# Any ideas greatly appreciated Thanks! Andrew __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://wwwpennyhostcom/redirectcfm?adcode=coldfusionc FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
RE: How do I conect a web server to a sql server?
I've found that installing he client utility improves my performance via ODBC Is there a network library that's overwritten when you install it? That's always been my guess I have no idea I've never noticed any difference, but that's probably because I usually update the MDAC layer anyway Dave Watts, CTO, Fig Leaf Software http://wwwfigleafcom/ voice: (202) 797-5496 fax: (202) 797-5444 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://wwwpennyhostcom/redirectcfm?adcode=coldfusionc FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
RE: CFABORT template, not all CF processing?
Try this out, cfexit will only exit from the included template, and run everything else. You can also use cfexit method=EXITTAG if you only want to exit from a tag. !--- contents of test1.cfm --- cfinclude template=test2.cfm pThis should always show !--- contents of test2.cfm --- cfif 1 EQ 1 Test2 just got terminated!br cfexit method=EXITTEMPLATE cfelse Test2 was included!br /cfif _ steve oliver senior internet developer atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Simon Horwith [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 12:54 PM To: CF-Talk Subject: RE: CFABORT template, not all CF processing? CFEXIT will, when called on a regular template (non-custom tag) allow onrequestend.cfm to still be processed.other than that, it behaves the same as cfabort, as Dave pointed out. ~Simon Simon Horwith Macromedia Certified Instructor Certified Advanced ColdFusion 5 Developer Fig Leaf Software 1400 16th St NW, # 500 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 12:51 PM To: CF-Talk Subject: RE: CFABORT template, not all CF processing? I was wondering if there is a way to abort a particular CF Template, but not all CF processing? Right now I'm wrapping my code with CFIF tags which determine if the code will run or not. Try using CFEXIT That'll only work if called from within a custom tag. Otherwise, it'll simply abort the page. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: someone want to help me?
thanks for the tips. they should help plenty. -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 12:25 PM To: CF-Talk Subject: someone want to help me? My boss wants me to spec out the process of taking credit card orders over the web. I have limited experience with this and any help you guys can give me is appreciated. Thanks, Steven D Dworman - Web Consultant Systems Administrator ComSpec International - http://www.comspec-intnl.com phone: 248.647.8841 cell: 734.972.9676 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
Visual Equation Building
Hey All, OK I'll do my bets to explain what I'm trying to accomplish: I want to build a tool that allows the user to visually build an equation. The building blocks for the equation are essentially fields in a database. I'd like to display these building blocks in a list and give the user the ability to pass them into a workspace on the page that will hold the equation. Ideally I'd like to allow the user to drag and drop the building blocks into the workspace, but I suppose passing them via a link and some JavaScript would suffice. I also need to give the user a way of passing operators (+,-,*,/,[,]) to the workspace to help build the equation. Another hook is that I need to ultimately store the IDs of the records of the building blocks when I store the finished equation. I have some ideas, but I thought before I head down those paths, I'd see if anyone else had any input. Thanks in advance for any comments/help/hysterical laughter ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Visual Equation Building
OTTOMH, What about two select boxes, one containing a list of fields, and one containing operators. Use the onChange event to fire off some Javascript to concatenate each building block to the current equation. Then have the javascript put the updated equation to a textarea or something like that. Behind the scenes you can track the IDs in a variable and put it in a database when the user is done (maybe a button to click). Does that sound like what you are looking for? Kathryn Butterly Web Developer Washington Mutual Finance 813 632-4490 [EMAIL PROTECTED] -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 1:26 PM To: CF-Talk Subject: Visual Equation Building Hey All, OK I'll do my bets to explain what I'm trying to accomplish: I want to build a tool that allows the user to visually build an equation. The building blocks for the equation are essentially fields in a database. I'd like to display these building blocks in a list and give the user the ability to pass them into a workspace on the page that will hold the equation. Ideally I'd like to allow the user to drag and drop the building blocks into the workspace, but I suppose passing them via a link and some JavaScript would suffice. I also need to give the user a way of passing operators (+,-,*,/,[,]) to the workspace to help build the equation. Another hook is that I need to ultimately store the IDs of the records of the building blocks when I store the finished equation. I have some ideas, but I thought before I head down those paths, I'd see if anyone else had any input. Thanks in advance for any comments/help/hysterical laughter ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com __ 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://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: someone want to help me?
We have just worked side by side with CDG Commerce (http://www.cdgcommerce.com) and wrote a custom tag to process orders realtime (or not). It is very very simple and easy to implement. If you sign up through QuillDesign, there are no setup fee's so basically its free for you to get setup and accept credit cards. You just have to pay the montly fee's (which is in line with all other processors). If you already have a processor, they will let you transfer for free as well. We are putting the custom tag and signup forms online for Monday, BUT if you are interested in getting more information and possibly testing it out, let me know, I can have a custom tag setup and a test account for those who want to test. Again, it is VERY simple .. and it is not a CFX tag. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder - Original Message - From: Steven Dworman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 28, 2002 11:25 AM Subject: someone want to help me? My boss wants me to spec out the process of taking credit card orders over the web. I have limited experience with this and any help you guys can give me is appreciated. Thanks, Steven D Dworman - Web Consultant Systems Administrator ComSpec International - http://www.comspec-intnl.com phone: 248.647.8841 cell: 734.972.9676 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
CFHTTP origin IP
I Have posted this one 3 times an no response I don't know why but maybe someone could explain the behavior of CFHTTP on a machine with multiple IPS? Thanks, Neil __ 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: CFHTTP origin IP
Neil - it will come from the IP that the application is running on. Shawnea - Original Message - From: Neil H. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 28, 2002 1:51 PM Subject: CFHTTP origin IP I Have posted this one 3 times an no response. I don't know why but maybe someone could explain the behavior of CFHTTP on a machine with multiple IPS? Thanks, Neil __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
detecting broswer encryption
Need help with an issue I need to be able to detect the users encryption level set in there browser If the users browser does not support 128 bit encryption, I'm gonna bump them to a page telling them to upgrade their browser I know there is a cgi environment variable (https_keysize), but that only functions on a secure page (https) If the users browser is 40 bit, they can't get to the https page for me to able to use this variable Any ideas? I was also thinking of maybe doing a browser detect but I'm not certain if users could have upgraded their security levels and not their browsers Thx all -- Global Internet phone calls, voicemail, fax, e-mail and instant messaging Sign-up today at http://wwwhotvoicecom __ 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: CFHTTP origin IP
I haven't seen that to be the case. Just to confirm I did a couple of tests. The cfhttp always seems to use the primary ip address of the machine. jon - Original Message - From: Shawnea Carter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 28, 2002 1:58 PM Subject: Re: CFHTTP origin IP Neil - it will come from the IP that the application is running on. Shawnea - Original Message - From: Neil H. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 28, 2002 1:51 PM Subject: CFHTTP origin IP I Have posted this one 3 times an no response. I don't know why but maybe someone could explain the behavior of CFHTTP on a machine with multiple IPS? Thanks, Neil __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: What are these, headers?
The text below is randomly appearing at the top of some of my web pages: HTTP/1.1 200 OK Server: Microsoft-IIS/5.0 Date: Thu, 28 Feb 2002 17:45:56 GMT Content-Type: text/html Accept-Ranges: bytes Last-Modified: Thu, 28 Feb 2002 17:44:15 GMT ETag: 90e1e5897fc0c11:1df0 Content-Length: 1991537 What is this? This text seems to appear only when I am using CFLocation to redirect to a static html page that I created through CFHTTP, and it occurs randomly. This is definitely a HTTP header, AFAIK. I've not used CFHTTP much, though, so I couldn't tell you how the header's being output to random pages. But if you find out how you're doing it, let me know, I've been looking for a good way to output HTTP headers in a page for ages! ;) - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
Paypal IPN (instant Payment Notification)
Has anyone been able to get this to work with user management turned on?done this with coldfusion? I know that their are a couple of tags out their and I've bought them but they are out of data and doesnt seem to be working correctly Ernie Pena http://wwwAtomicqubecom __ 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: What are these, headers?
Gyrus, CFHTTP.Header would probably do the trick :-) HTH, Andrew -Original Message- From: Gyrus [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 1:13 PM To: CF-Talk Subject: Re: What are these, headers? The text below is randomly appearing at the top of some of my web pages: HTTP/1.1 200 OK Server: Microsoft-IIS/5.0 Date: Thu, 28 Feb 2002 17:45:56 GMT Content-Type: text/html Accept-Ranges: bytes Last-Modified: Thu, 28 Feb 2002 17:44:15 GMT ETag: 90e1e5897fc0c11:1df0 Content-Length: 1991537 What is this? This text seems to appear only when I am using CFLocation to redirect to a static html page that I created through CFHTTP, and it occurs randomly. This is definitely a HTTP header, AFAIK. I've not used CFHTTP much, though, so I couldn't tell you how the header's being output to random pages. But if you find out how you're doing it, let me know, I've been looking for a good way to output HTTP headers in a page for ages! ;) - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: What are these, headers?
We've seen this with CF 5 when we use CFHTMLHEAD. If we use CFHTMLHEAD in a template before the actual HTML head tag, we'd sometimes see the HTTP headers appear above the HTML output. This happened more often when we did a redirect to the page (ie cflocation). We moved all of our CFHTMLHEAD tags to ensure they were below the physical head tags and the problem disappeared. Matt -Original Message- From: Andrew Peterson [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 1:13 PM To: CF-Talk Subject: What are these, headers? Hi The text below is randomly appearing at the top of some of my web pages: HTTP/1.1 200 OK Server: Microsoft-IIS/5.0 Date: Thu, 28 Feb 2002 17:45:56 GMT Content-Type: text/html Accept-Ranges: bytes Last-Modified: Thu, 28 Feb 2002 17:44:15 GMT ETag: 90e1e5897fc0c11:1df0 Content-Length: 1991537 What is this? This text seems to appear only when I am using CFLocation to redirect to a static html page that I created through CFHTTP, and it occurs randomly. However, I've learned through testing that if I use a Meta Refresh instead of a CFLocate, text does not appear (i.e. problem solved). However, I am still curious as to what is going on. Plus, I like CFLocate better (no clicking in I.E. when page is redirected) Can anyone tell me what this is and how to guarantee its absence from my page? Below is my cfhttp code that generates the page the first time it accessed. CFHTTP METHOD = get URL=#request.ServerPath#/index.cfm?fuseaction=getCard#parms# PATH=e:\#request.root#\Cache FILE=cache#NewID#.html If the page is called is accessed again, Cflocation accesses the cached version of the page, and sometimes that wierd header shows up: CFIF CheckCache.RecordCount cflocation url=/cache/#checkcache.file# . Any ideas greatly appreciated. Thanks! Andrew __ 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://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: What are these, headers?
#cfhttp.responseHeader[http_header_key]# or getHttpRequestData() depending on which headers you want :) jon - Original Message - From: Gyrus [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 28, 2002 2:13 PM Subject: Re: What are these, headers? The text below is randomly appearing at the top of some of my web pages: HTTP/1.1 200 OK Server: Microsoft-IIS/5.0 Date: Thu, 28 Feb 2002 17:45:56 GMT Content-Type: text/html Accept-Ranges: bytes Last-Modified: Thu, 28 Feb 2002 17:44:15 GMT ETag: 90e1e5897fc0c11:1df0 Content-Length: 1991537 What is this? This text seems to appear only when I am using CFLocation to redirect to a static html page that I created through CFHTTP, and it occurs randomly. This is definitely a HTTP header, AFAIK. I've not used CFHTTP much, though, so I couldn't tell you how the header's being output to random pages. But if you find out how you're doing it, let me know, I've been looking for a good way to output HTTP headers in a page for ages! ;) - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: CFHTTP origin IP
I Have posted this one 3 times an no response I don't know why but maybe someone could explain the behavior of CFHTTP on a machine with multiple IPS? It's going to behave like any other TCP/IP client application On Windows, there's a first IP address, which will show up either first or last (I forget which) in the list if you type ipconfig /all at a command prompt On other OSs, I have no idea how outgoing address selection works You don't have any control over this from within CF, just like from within any other client application Dave Watts, CTO, Fig Leaf Software http://wwwfigleafcom/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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: Visual Equation Building
Yup...that's along the lines of what I'm after (and I've thought of something along those lines), but I'm not sure if it will be user friendly enough. Any other thoughts folks? mabye CF and Flash? Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 28, 2002 10:27 AM Subject: RE: Visual Equation Building OTTOMH, What about two select boxes, one containing a list of fields, and one containing operators. Use the onChange event to fire off some Javascript to concatenate each building block to the current equation. Then have the javascript put the updated equation to a textarea or something like that. Behind the scenes you can track the IDs in a variable and put it in a database when the user is done (maybe a button to click). Does that sound like what you are looking for? Kathryn Butterly Web Developer Washington Mutual Finance 813 632-4490 [EMAIL PROTECTED] -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 1:26 PM To: CF-Talk Subject: Visual Equation Building Hey All, OK I'll do my bets to explain what I'm trying to accomplish: I want to build a tool that allows the user to visually build an equation. The building blocks for the equation are essentially fields in a database. I'd like to display these building blocks in a list and give the user the ability to pass them into a workspace on the page that will hold the equation. Ideally I'd like to allow the user to drag and drop the building blocks into the workspace, but I suppose passing them via a link and some JavaScript would suffice. I also need to give the user a way of passing operators (+,-,*,/,[,]) to the workspace to help build the equation. Another hook is that I need to ultimately store the IDs of the records of the building blocks when I store the finished equation. I have some ideas, but I thought before I head down those paths, I'd see if anyone else had any input. Thanks in advance for any comments/help/hysterical laughter ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com __ 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://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: detecting browser encryption
Need help with an issue I need to be able to detect the users encryption level set in there browser If the users browser does not support 128 bit encryption, I'm gonna bump them to a page telling them to upgrade their browser I know there is a cgi environment variable (https_keysize), but that only functions on a secure page (https) If the users browser is 40 bit, they can't get to the https page for me to able to use this variable To the best of my knowledge, you can't do this using standard CGI variables You can have an HTTP page that you use as a gateway to HTTPS, which explains what will happen if they don't support 128-bit encryption, but that's it However, you could allow the page to use 40-bit encryption, which would get around the problem I believe (though I'm not entirely sure) that, in IIS at least, you can simply enable encryption, and if both browser and server support 128-bit keys, they'll be used If not, they'll use 40-bit keys Of course, if you check the Require 128-bit keys option in IIS, that won't work Any ideas? I was also thinking of maybe doing a browser detect but I'm not certain if users could have upgraded their security levels and not their browsers I don't think that'll help, since at least with IE, security is dependent on an OS component rather than on the specific browser version Dave Watts, CTO, Fig Leaf Software http://wwwfigleafcom/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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: detecting broswer encryption
you could do a custom error page in IIS trapping error 403.5. that's the HTTP 403.5 - Forbidden: SSL 128 required christopher olive, cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: FARRAH NG [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 2:09 PM To: CF-Talk Subject: detecting broswer encryption Need help with an issue. I need to be able to detect the users encryption level set in there browser. If the users browser does not support 128 bit encryption, I'm gonna bump them to a page telling them to upgrade their browser. I know there is a cgi environment variable (https_keysize), but that only functions on a secure page (https). If the users browser is 40 bit, they can't get to the https page for me to able to use this variable. Any ideas? I was also thinking of maybe doing a browser detect... but I'm not certain if users could have upgraded their security levels and not their browsers. Thx all. - - Global Internet phone calls, voicemail, fax, e-mail and instant messaging. Sign-up today at http://www.hotvoice.com __ 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://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: Moving MSSQL DB from Dev to Prod
Just now, I used the import wizard, and there's an option to overwrite data on production (right now, the servers don't have the rights to each other's file systems). How does this compare to the backup on development/restore on production strategy? Thanks, Jamie On Thu, 28 Feb 2002 16:32:22 -, in cf-talk you wrote: Backup your dev database to a file, upload it to live server, and force a restore over the current db, works for me. -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED]] Sent: 28 February 2002 16:37 To: CF-Talk Subject: Moving MSSQL DB from Dev to Prod What's the typical way to copy one's development DB to production (SQL2000)? Changes will commonly be made on Dev, and there will be an existing version on production which will need to be overwritten. I know about the copy database wizard, but AFAIK, it doesn't work if the DB already exists on the production server. Finally, is there a resource concerning general CF/MSSQL interaction issues and best practices? Thanks, Jamie __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: What are these, headers?
Put the cfhttp inside an HTML comment !-- -- Rick -Original Message- From: Andrew Peterson [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 12:13 PM To: CF-Talk Subject: What are these, headers? Hi The text below is randomly appearing at the top of some of my web pages: HTTP/1.1 200 OK Server: Microsoft-IIS/5.0 Date: Thu, 28 Feb 2002 17:45:56 GMT Content-Type: text/html Accept-Ranges: bytes Last-Modified: Thu, 28 Feb 2002 17:44:15 GMT ETag: 90e1e5897fc0c11:1df0 Content-Length: 1991537 What is this? This text seems to appear only when I am using CFLocation to redirect to a static html page that I created through CFHTTP, and it occurs randomly. However, I've learned through testing that if I use a Meta Refresh instead of a CFLocate, text does not appear (i.e. problem solved). However, I am still curious as to what is going on. Plus, I like CFLocate better (no clicking in I.E. when page is redirected) Can anyone tell me what this is and how to guarantee its absence from my page? Below is my cfhttp code that generates the page the first time it accessed. CFHTTP METHOD = get URL=#request.ServerPath#/index.cfm?fuseaction=getCard#parms# PATH=e:\#request.root#\Cache FILE=cache#NewID#.html If the page is called is accessed again, Cflocation accesses the cached version of the page, and sometimes that wierd header shows up: CFIF CheckCache.RecordCount cflocation url=/cache/#checkcache.file# . Any ideas greatly appreciated. Thanks! Andrew __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: Visual Equation Building
CF + FLASH would/could work in theory - the visual system would have to have symbols (flash term) for each character/symbol you needed (perhaps with a scrolling up/down sort of fly-wheel system of choosing them) - which could then be dragged and dropped onto a math page - this would trigger an event that would append the associated character/symbol to each symbol into a variable - this variable string (xml string) could be added to and subtracted from (with an eraser tool that would undo the last move) - which in turn would be stored to a file/database when the equation if completed. Things to look out for would be translation of special characters/symbols (e.g. *,%,{,[ etc) as this would effect the ActiveScript (AS) - so perhaps a codex that used a number based system that could be translated from the xml/data string on saving the equation. Secondly you would have to work it so that picking up a symbol and dropping it on the math page would trigger a one off event - if the very same symbol was then picked again and moved around the page then dropped again this should not trigger the character/symbol appending function. Also is a similar symbol (another x for example) was then picked up and dropped on the math page the AS would have to realise this. Thirdly you would not be able to save the visual product though - with the placement of all the symbols on the maths page so that when a user came back they would have to re-build each equation - unless another complex logic was used in creating both x,y co-ordinates and saved these too in an array Getting complex now... What you are talking about here is a very complex integration system - perhaps a java applet may be better... Interesting concept tho. Good luck J -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 19:40 To: CF-Talk Subject: Re: Visual Equation Building Yup...that's along the lines of what I'm after (and I've thought of something along those lines), but I'm not sure if it will be user friendly enough. Any other thoughts folks? mabye CF and Flash? Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 28, 2002 10:27 AM Subject: RE: Visual Equation Building OTTOMH, What about two select boxes, one containing a list of fields, and one containing operators. Use the onChange event to fire off some Javascript to concatenate each building block to the current equation. Then have the javascript put the updated equation to a textarea or something like that. Behind the scenes you can track the IDs in a variable and put it in a database when the user is done (maybe a button to click). Does that sound like what you are looking for? Kathryn Butterly Web Developer Washington Mutual Finance 813 632-4490 [EMAIL PROTECTED] -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 1:26 PM To: CF-Talk Subject: Visual Equation Building Hey All, OK I'll do my bets to explain what I'm trying to accomplish: I want to build a tool that allows the user to visually build an equation. The building blocks for the equation are essentially fields in a database. I'd like to display these building blocks in a list and give the user the ability to pass them into a workspace on the page that will hold the equation. Ideally I'd like to allow the user to drag and drop the building blocks into the workspace, but I suppose passing them via a link and some JavaScript would suffice. I also need to give the user a way of passing operators (+,-,*,/,[,]) to the workspace to help build the equation. Another hook is that I need to ultimately store the IDs of the records of the building blocks when I store the finished equation. I have some ideas, but I thought before I head down those paths, I'd see if anyone else had any input. Thanks in advance for any comments/help/hysterical laughter ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation ·
New UDF Best Practices Article on oreilly.com
Just wanted to let the list know about an article I recently did for O'Reilly's web site oreillycom The article highlights best practices for writing UDFs and is called Top Ten ColdFusion UDF Tips You can view the article at http://wwworeillynetcom/pub/a/javascript/2002/02/22/udftipshtml; I welcome any questions or comments Thanks! -Rob __ 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=coldfusiona FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
Date Function
Hello All, Here is a good one I have been thinking about this for a while and I can not figure it out! I am doing a schedule thing and I need to see if let's say at the time it goes, if we are the 1st of the month to get yesterday's date So I cab take that and format it with dateformat Does anyone know how this would be accomplished? Thanks, Joel __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://wwwpennyhostcom/redirectcfm?adcode=coldfusionc FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
Custom error (cfthrow) question
I've used CFTRY/CFCATCH before But I've never been clear on exactly how to catch specific ODBC type of errors, to put up a custom error message I want an error message for : ODBC Error Code = 22001 (String data right truncation) If that error comes up, as opposed to any other error, I want to be able to say, Hey buddy, you're input field is too big -- trim it back) I've used CFTHROW to do something like cfif formfield is blah throw /cfif but I'm not sure I can catch and ODBC error and throw a custom error -- can I? How would you handle this? H __ 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=coldfusiona FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
RE: Date Function
I'm sorry, I'm not sure what you are asking. Are you asking how to get the previous day's date? Kathryn Butterly Web Developer Washington Mutual Finance 813 632-4490 [EMAIL PROTECTED] -Original Message- From: Joel Blanchette [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 3:11 PM To: CF-Talk Subject: Date Function Hello All, Here is a good one. I have been thinking about this for a while and I can not figure it out! I am doing a schedule thing and I need to see if let's say at the time it goes, if we are the 1st of the month to get yesterday's date. So I cab take that and format it with dateformat Does anyone know how this would be accomplished? Thanks, Joel __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Date Function
I'm not quite sure what you are asking. Are you trying to determine if you are on the first day of the month? cfif day(now()) is 1 It's the 1st. Arm the Star Destroyers /cfif === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Joel Blanchette [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 3:11 PM To: CF-Talk Subject: Date Function Hello All, Here is a good one. I have been thinking about this for a while and I can not figure it out! I am doing a schedule thing and I need to see if let's say at the time it goes, if we are the 1st of the month to get yesterday's date. So I cab take that and format it with dateformat Does anyone know how this would be accomplished? Thanks, Joel __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: Custom error (cfthrow) question
when you trap an error of type database, you're provided with SQLState and NativeErrorCode. examine these with your CATCH, then do what you like with the user. christopher olive, cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 3:03 PM To: CF-Talk Subject: Custom error (cfthrow) question I've used CFTRY/CFCATCH before. But I've never been clear on exactly how to catch specific ODBC type of errors, to put up a custom error message. I want an error message for : ODBC Error Code = 22001 (String data right truncation) If that error comes up, as opposed to any other error, I want to be able to say, Hey buddy, you're input field is too big -- trim it back) I've used CFTHROW to do something like cfif form.field is blah throw /cfif but I'm not sure I can catch and ODBC error and throw a custom error -- can I? How would you handle this? H. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Custom error (cfthrow) question
We do something like this, but instead of notifying the user, we update the field size and re-attempt the insert Note: This under controlled circumstances and is not done in an Adhoc, lets just make it bigger fashion Just look in your log (or a SQL book) to find the error codes and add clauses to a cfswitch statement for various odbcerrors !- catch code --- cftry !--- insert goes here --- cfcatch !--- catch various SQL error and attempt to fix them and re-run the insert --- cfswitch expression=#trim(cfcatchsqlstate)# cfcase value=22001 !--- data is being truncated, do something here --- /cfcase cfcase value=S0002 !--- missing table, do something here --- /cfcase /cfswitch /cfcatch /cftry Brook Davies maracasmediacom At 12:03 PM 28/02/02 -0800, you wrote: I've used CFTRY/CFCATCH before But I've never been clear on exactly how to catch specific ODBC type of errors, to put up a custom error message I want an error message for : ODBC Error Code = 22001 (String data right truncation) If that error comes up, as opposed to any other error, I want to be able to say, Hey buddy, you're input field is too big -- trim it back) I've used CFTHROW to do something like cfif formfield is blah throw /cfif but I'm not sure I can catch and ODBC error and throw a custom error -- can I? How would you handle this? H __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://wwwpennyhostcom/redirectcfm?adcode=coldfusionc FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
RE: Date Function
Yeah basically...Like tomorrow when the scheduler execute the script I need it to say if today is 1st of the month, the day before was... Joel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 2:16 PM To: CF-Talk Subject: RE: Date Function I'm sorry, I'm not sure what you are asking. Are you asking how to get the previous day's date? Kathryn Butterly Web Developer Washington Mutual Finance 813 632-4490 [EMAIL PROTECTED] -Original Message- From: Joel Blanchette [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 3:11 PM To: CF-Talk Subject: Date Function Hello All, Here is a good one. I have been thinking about this for a while and I can not figure it out! I am doing a schedule thing and I need to see if let's say at the time it goes, if we are the 1st of the month to get yesterday's date. So I cab take that and format it with dateformat Does anyone know how this would be accomplished? Thanks, Joel __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: Custom error (cfthrow) question
Lets say you wanted to throw a fieldmissing error use cfthrow like: cfthrow type=fieldmissing message=hey buddy fill in all the fields detail=missing field: first_name Then you can catch it along with your database error as follows: cftry !--- code here --- cfcatch type=Database NativeErrorCode =22001 !--- do database error processing here --- /cfcatch cfcatch type=fieldmissing !--- do missing field error processing here --- /cfcatch /cftry -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 3:03 PM To: CF-Talk Subject: Custom error (cfthrow) question I've used CFTRY/CFCATCH before. But I've never been clear on exactly how to catch specific ODBC type of errors, to put up a custom error message. I want an error message for : ODBC Error Code = 22001 (String data right truncation) If that error comes up, as opposed to any other error, I want to be able to say, Hey buddy, you're input field is too big -- trim it back) I've used CFTHROW to do something like cfif form.field is blah throw /cfif but I'm not sure I can catch and ODBC error and throw a custom error -- can I? How would you handle this? H. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SOXML
Does anyone have a copy of SOXML? Its freeware and you can get it from their site (siteobjects.com) but I cant seem to get my password emailed to me nor new accounts. I dont know if its there system or my email server. One of my DNS servers is down so maybe thats it. Anyone? Send it to : [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Date Function
You mean you want to get yesterdays date? Sounds like you've been trying to subtract 1 from the date, since your having problems if the date is on the 1st. Try using DateAdd() So if your date is march 1st. cfset yourdate = 03/01/2001 User DateAdd to subtract 1 day. cfset yesterday = DateAdd(d,-1,yourdate) And output it with dateformat. cfoutput#DateFormat(Variables.yesterday,mm/dd/)#/cfoutput _ steve oliver senior internet developer atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Joel Blanchette [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 3:11 PM To: CF-Talk Subject: Date Function Hello All, Here is a good one. I have been thinking about this for a while and I can not figure it out! I am doing a schedule thing and I need to see if let's say at the time it goes, if we are the 1st of the month to get yesterday's date. So I cab take that and format it with dateformat Does anyone know how this would be accomplished? Thanks, Joel __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: Date Function
To get the date before, just do: cfset yesterdayMyDreamsSeemedSoFarWay = dateAdd(d,-1,now()) This will simply go back one day from the current date. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Joel Blanchette [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 3:18 PM To: CF-Talk Subject: RE: Date Function Yeah basically...Like tomorrow when the scheduler execute the script I need it to say if today is 1st of the month, the day before was... Joel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 2:16 PM To: CF-Talk Subject: RE: Date Function I'm sorry, I'm not sure what you are asking. Are you asking how to get the previous day's date? Kathryn Butterly Web Developer Washington Mutual Finance 813 632-4490 [EMAIL PROTECTED] -Original Message- From: Joel Blanchette [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 3:11 PM To: CF-Talk Subject: Date Function Hello All, Here is a good one. I have been thinking about this for a while and I can not figure it out! I am doing a schedule thing and I need to see if let's say at the time it goes, if we are the 1st of the month to get yesterday's date. So I cab take that and format it with dateformat Does anyone know how this would be accomplished? Thanks, Joel __ 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://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: Date Function
cfif day(now()) is 1 cfset yesterday = dateadd(d,-1,now()) /cfif -Original Message- From: Joel Blanchette [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 3:18 PM To: CF-Talk Subject: RE: Date Function Yeah basically...Like tomorrow when the scheduler execute the script I need it to say if today is 1st of the month, the day before was... Joel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 2:16 PM To: CF-Talk Subject: RE: Date Function I'm sorry, I'm not sure what you are asking. Are you asking how to get the previous day's date? Kathryn Butterly Web Developer Washington Mutual Finance 813 632-4490 [EMAIL PROTECTED] -Original Message- From: Joel Blanchette [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 3:11 PM To: CF-Talk Subject: Date Function Hello All, Here is a good one. I have been thinking about this for a while and I can not figure it out! I am doing a schedule thing and I need to see if let's say at the time it goes, if we are the 1st of the month to get yesterday's date. So I cab take that and format it with dateformat Does anyone know how this would be accomplished? Thanks, Joel __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: What are these, headers?
Andrew Peterson wrote: Hi The text below is randomly appearing at the top of some of my web pages: HTTP/11 200 OK Server: Microsoft-IIS/50 Date: Thu, 28 Feb 2002 17:45:56 GMT Content-Type: text/html Accept-Ranges: bytes Last-Modified: Thu, 28 Feb 2002 17:44:15 GMT ETag: 90e1e5897fc0c11:1df0 Content-Length: 1991537 What is this? Standard HTML headers (although I wouldn't want to call the content length standard, 2MB is a lot :) ) This text seems to appear only when I am using CFLocation to redirect to a static html page that I created through CFHTTP, and it occurs randomly Thing to check is if this text is actually inside the static HTML page (quite unlikely because of the rest of the symptoms, but check anyway) However, I've learned through testing that if I use a Meta Refresh instead of a CFLocate, text does not appear (ie problem solved) This makes me believe you have a problem that is bigger as this Somewhere in the webserver/cfserver setup something goes wrong which means that the server is adding the HTTP headers twice And that is a problem because in that case the second occurence ends up in the page visible to the user What code is run before CFIF CheckCacheRecordCount cflocation url=/cache/#checkcachefile# Anything that does something with headers/pageflow (cfflush, cfcache, cfcontent, cfheader, cflocation etc)? What happens if you remove that code? Try putting a cfabort after the cflocation? Did you by any chance install URLScan recently? Which ISAPI filters do you have? Are you running IIS HTTP compression? Jochem __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://wwwpennyhostcom/redirectcfm?adcode=coldfusionc FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
Another ThreeSelectsRelated Question
Okay, I found the tag but am having an interesting problem If I run the following query: select companycompany_k, projectproject_k, tasktask_k, Replace(companyname, '', '') as cname, Replace(projectname, '', '') as pname, Replace(taskname, '', '') as tname from task inner join project on taskproject_k = projectproject_k inner join company on projectcompany_k = companycompany_k where IsNull(taskDel, 0) = 0 AND IsNull(projectDel, 0) = 0 AND IsNull(CompanyDel, 0) = 0 AND Task Name IS NOT NULL and companycompany_k = #whatever# AND taskstatus_k IN (select status_k from status where name = 'Open' or name = 'QA') order by companyname, projectname, taskname I get a recordset something like the following: 1 Comp a1 Proj a 1 Task a-1 1 Comp a1 Proj a 2 Task a-2 1 Comp a1 Proj a 3 Task a-3 1 Comp a2 Proj b 4 Task b-1 1 Comp a2 Proj b 5 Task b-2 1 Comp a3 Proj c 6 Task c-1 1 Comp a3 Proj c 7 Task c-2 This is what I'm supposed to be getting, right? Well if I call the tag with Default1=1 Default2=2, Default3=5 for the attributes it correctly selects Company A in the first field and Proj B in the second field, but the third field is populated with selections from Proj a Even more interesting is the fact that it's preselecting the the first row of the query Anyone have any ideas for this?! TIA! Hatton Humphrey __ 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=coldfusiona FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
RE: Custom error (cfthrow) question
Thanks all for the help! H. -Original Message- From: Christopher Olive [SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 12:18 PM To: CF-Talk Subject: RE: Custom error (cfthrow) question when you trap an error of type database, you're provided with SQLState and NativeErrorCode. examine these with your CATCH, then do what you like with the user. christopher olive, cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 3:03 PM To: CF-Talk Subject: Custom error (cfthrow) question I've used CFTRY/CFCATCH before. But I've never been clear on exactly how to catch specific ODBC type of errors, to put up a custom error message. I want an error message for : ODBC Error Code = 22001 (String data right truncation) If that error comes up, as opposed to any other error, I want to be able to say, Hey buddy, you're input field is too big -- trim it back) I've used CFTHROW to do something like cfif form.field is blah throw /cfif but I'm not sure I can catch and ODBC error and throw a custom error -- can I? How would you handle this? H. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: What are these, headers?
I've had this. It happens when a lot of code is output before the cflocation. If you can reduce the amount of code it should come right. For example, I resolved it by moving a large Javascript block from the top to the bottom. Any help? Regards, Matthew Walker /* Cabbage Tree Creative Ltd Christchurch - New Zealand http://www.matthewwalker.net.nz/ http://www.cabbagetree.co.nz/ */ -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Friday, 1 March 2002 10:39 am To: CF-Talk Subject: Re: What are these, headers? Andrew Peterson wrote: Hi The text below is randomly appearing at the top of some of my web pages: HTTP/1.1 200 OK Server: Microsoft-IIS/5.0 Date: Thu, 28 Feb 2002 17:45:56 GMT Content-Type: text/html Accept-Ranges: bytes Last-Modified: Thu, 28 Feb 2002 17:44:15 GMT ETag: 90e1e5897fc0c11:1df0 Content-Length: 1991537 What is this? Standard HTML headers (although I wouldn't want to call the content length standard, 2MB is a lot :) ). This text seems to appear only when I am using CFLocation to redirect to a static html page that I created through CFHTTP, and it occurs randomly. Thing to check is if this text is actually inside the static HTML page (quite unlikely because of the rest of the symptoms, but check anyway). However, I've learned through testing that if I use a Meta Refresh instead of a CFLocate, text does not appear (i.e. problem solved). This makes me believe you have a problem that is bigger as this. Somewhere in the webserver/cfserver setup something goes wrong which means that the server is adding the HTTP headers twice. And that is a problem because in that case the second occurence ends up in the page visible to the user. What code is run before CFIF CheckCache.RecordCount cflocation url=/cache/#checkcache.file# Anything that does something with headers/pageflow (cfflush, cfcache, cfcontent, cfheader, cflocation etc.)? What happens if you remove that code? Try putting a cfabort after the cflocation? Did you by any chance install URLScan recently? Which ISAPI filters do you have? Are you running IIS HTTP compression? Jochem __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: OT : Submit file field form via javascript
At 08:31 PM 2/28/2002, you wrote: I think it has something to do with the security in the browsers Yea I think it's to stop you from silently uploading files from the user's machine eg onLoad = documentforms[0]fileFieldvalue = 'C:\SomeSecretStufftxt'; documentforms[0]submit() a real PITA though I did a search on it, and found several discussion boards with people asking about that They wanted to use an image though instead of a button to do what you are wanting to do But noone can get it to work, they get access denied http://wwwsiteexpertscom/forums/viewConverseasp?d_id=7741Sort=0 Yeah that's more or less what I want to do Looks like I'm outa luck The only way I was able to get it to semi-work was to set the width of the file field to 80, so it sort of hides the text part, and click on the browse button form action=somepagecfm enctype=multipart/form-data method=post INPUT TYPE=FILE name=Foo onchange=documentforms[0]submit() style=width:80px /form I hadn't thought of that James Sleeman Innovative Media Ltd Phone: (03) 377 6262 http://ebsolutionsconz/ CAUTION: The information contained in this email message is confidential and may be legally privileged If the reader of this message is not the intended recipient you are notified that any use, dissemination, distribution or reproduction of this message is prohibited If you have received this message in error please notify the sender immediately and destroy the original message and any attachments Views expressed in this communication may not be those of Innovative Media Ltd __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://wwwpennyhostcom/redirectcfm?adcode=coldfusionc FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
RE: time field in access
I think you can insert a NULL value into the field if it's not required. Do something like: INSERT INTO yourtable (StartTime) VALUES ( cfif len(FORM.StartTime) '#FORM.StartTime#' cfelse NULL /cfif ) _ steve oliver senior internet developer atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 5:05 PM To: CF-Talk Subject: 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 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Custom error (cfthrow) question
I tried the nativeerrorcode attribute and I get this error (on a 5.0 server): Just in time compilation error An unknown attribute 'NATIVEERRORCODE' has been encountered at document position (171:27) to (171:41) while processing tag CFCATCH. This tag can only take the following attributes: * TYPE -Original Message- From: Fred Jambukeswaran [SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 12:19 PM To: CF-Talk Subject: RE: Custom error (cfthrow) question Lets say you wanted to throw a fieldmissing error use cfthrow like: cfthrow type=fieldmissing message=hey buddy fill in all the fields detail=missing field: first_name Then you can catch it along with your database error as follows: cftry !--- code here --- cfcatch type=Database NativeErrorCode =22001 !--- do database error processing here --- /cfcatch cfcatch type=fieldmissing !--- do missing field error processing here --- /cfcatch /cftry -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 3:03 PM To: CF-Talk Subject: Custom error (cfthrow) question I've used CFTRY/CFCATCH before. But I've never been clear on exactly how to catch specific ODBC type of errors, to put up a custom error message. I want an error message for : ODBC Error Code = 22001 (String data right truncation) If that error comes up, as opposed to any other error, I want to be able to say, Hey buddy, you're input field is too big -- trim it back) I've used CFTHROW to do something like cfif form.field is blah throw /cfif but I'm not sure I can catch and ODBC error and throw a custom error -- can I? How would you handle this? H. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: Custom error (cfthrow) question
no, the TYPE is DATABASE. you use CFCATCH.NativeErrorCode in the catch statement to dump the error code. it's all in the help files under CFTRY CFCATCH (a nice way to tell you to try to RTFM :)) christopher olive, cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 5:00 PM To: CF-Talk Subject: RE: Custom error (cfthrow) question I tried the nativeerrorcode attribute and I get this error (on a 5.0 server): Just in time compilation error An unknown attribute 'NATIVEERRORCODE' has been encountered at document position (171:27) to (171:41) while processing tag CFCATCH. This tag can only take the following attributes: * TYPE -Original Message- From: Fred Jambukeswaran [SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 12:19 PM To: CF-Talk Subject: RE: Custom error (cfthrow) question Lets say you wanted to throw a fieldmissing error use cfthrow like: cfthrow type=fieldmissing message=hey buddy fill in all the fields detail=missing field: first_name Then you can catch it along with your database error as follows: cftry !--- code here --- cfcatch type=Database NativeErrorCode =22001 !--- do database error processing here --- /cfcatch cfcatch type=fieldmissing !--- do missing field error processing here --- /cfcatch /cftry -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 3:03 PM To: CF-Talk Subject: Custom error (cfthrow) question I've used CFTRY/CFCATCH before. But I've never been clear on exactly how to catch specific ODBC type of errors, to put up a custom error message. I want an error message for : ODBC Error Code = 22001 (String data right truncation) If that error comes up, as opposed to any other error, I want to be able to say, Hey buddy, you're input field is too big -- trim it back) I've used CFTHROW to do something like cfif form.field is blah throw /cfif but I'm not sure I can catch and ODBC error and throw a custom error -- can I? How would you handle this? H. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: Custom error (cfthrow) question
I tried the nativeerrorcode attribute and I get this error (on a 50 server): Just in time compilation error An unknown attribute 'NATIVEERRORCODE' has been encountered If you're using ODBC, you'll want to reference CFCATCHSQLState CFCATCHNativeErrorCode is for native drivers, I think Dave Watts, CTO, Fig Leaf Software http://wwwfigleafcom/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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=coldfusiona FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
RE: Custom error (cfthrow) question
try scoping it with CFCATCH.NativeErrorCode not sure if that will help On the otherhand, if your CFCatch block is catching ALL errors, then you have to make sure it is a DATABASE type before you can check the value of NativeErrorCode, or SQLState. In my case, I make have a CFCatch block specifically for database types of errors. Hope that helps. Shawn Grover -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 3:00 PM To: CF-Talk Subject: RE: Custom error (cfthrow) question I tried the nativeerrorcode attribute and I get this error (on a 5.0 server): Just in time compilation error An unknown attribute 'NATIVEERRORCODE' has been encountered at document position (171:27) to (171:41) while processing tag CFCATCH. This tag can only take the following attributes: * TYPE -Original Message- From: Fred Jambukeswaran [SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 12:19 PM To: CF-Talk Subject: RE: Custom error (cfthrow) question Lets say you wanted to throw a fieldmissing error use cfthrow like: cfthrow type=fieldmissing message=hey buddy fill in all the fields detail=missing field: first_name Then you can catch it along with your database error as follows: cftry !--- code here --- cfcatch type=Database NativeErrorCode =22001 !--- do database error processing here --- /cfcatch cfcatch type=fieldmissing !--- do missing field error processing here --- /cfcatch /cftry -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 3:03 PM To: CF-Talk Subject: Custom error (cfthrow) question I've used CFTRY/CFCATCH before. But I've never been clear on exactly how to catch specific ODBC type of errors, to put up a custom error message. I want an error message for : ODBC Error Code = 22001 (String data right truncation) If that error comes up, as opposed to any other error, I want to be able to say, Hey buddy, you're input field is too big -- trim it back) I've used CFTHROW to do something like cfif form.field is blah throw /cfif but I'm not sure I can catch and ODBC error and throw a custom error -- can I? How would you handle this? H. __ 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://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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