Re: CFMX - XP SP2 and SQL Server
Qasim Rasheed [EMAIL PROTECTED] wrote: Recently I installed XP SP2 on my machine and suddenly ColdFusion MX is unable to connect to my SQL server present on the same machine. John Beynon [EMAIL PROTECTED] wrote: i think you have to do something odd like sp3 your SQL server install, I had this exact issue on the boss's demo laptop, and installing SQL Server SP3 fixed it right up. Thanks JB! K. -- Kay Smoljak http://kay.smoljak.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: New MAX 2004 CF Blackstone Sessions
looking forward to it, Damon. ~Simon Simon Horwith Member of Team Macromedia Macromedia Certified Master Instructor Editor-in-Chief, ColdFusion Developers Journal Blog - http://www.horwith.com [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: http://www.macromedia.com/macromedia/events/max/agenda/by_track.html Virtually every CF engineer will be there and we'll be having plenty of informal sessions as well to gather your feedback on CF and Blackstone.We've built time into our Blackstone schedule to ensure we account for changes due to customer feedback received from MAX to help ensure Blackstone is going to work for you. See you there! Here's some of the current CF-related list of sessions posted: Getting Started with ColdFusion Building a Basic CMS with ColdFusion and Dreamweaver Using ColdFusion to Power Flex and Flash Applications The Future of ColdFusion: Blackstone Database Design Fundamentals Structured Development, ColdFusion Done the Right Way Working with Multiple ColdFusion Instances Leveraging Web Services with ColdFusion Building for Scalability Secure ColdFusion Applications ColdFusion Performance Tips and Tricks Building Internationalized and Multi-Lingual Applications Integrating with Microsoft Office Object Oriented ColdFusion Advanced ColdFusion Components and Web Services Java Powered ColdFusion Coding for Reuse The Infrastructure Impact Blackstone Event Gateways Mobile SMS Applications Made Easy ColdFusion Printing and Reporting Damon Cooper Director of Engineering Macromedia [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ot: jrun ?
that's odd.One thing you might want to do is turn off auto-deploy. You can do this by going to the server's jrun.xml file DeployerService section and commenting out the attribute node that has a name attribute value ofdeployDirectory. If there are any file or url attribute tags (with that value in the name attribute) comment those out as well.Be aware that if you do this then nothing will deploy when you start the server - including ColdFusion.The server will then require much less memory to start, however. ~Simon Simon Horwith Member of Team Macromedia Macromedia Certified Master Instructor Editor-in-Chief, ColdFusion Developers Journal Blog - http://www.horwith.com dave wrote: ok, now does anyone know what i need to do to get back started up? reboot didnt work, starting from the control panel fails maybe i should do the right thing and uninstall it and reinstall on linux side ;) -- Original Message -- From: dave [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Wed, 22 Sep 2004 15:47:06 -0400 i turned it down from 512 mb to 128 mb and now it wont even start lol -- Original Message -- From: Dave Carabetta [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Tue, 21 Sep 2004 12:43:17 -0400 On Tue, 21 Sep 2004 11:35:05 -0500, Ben Frame [EMAIL PROTECTED] wrote: Neil, Why set the initial and max heap size the same?Is that recommendation documented from Macromedia anywhere or is that from your own experiences? Setting the two values to be the same increases performance in so far as it eliminates the need for the JVM to resize itself based on the resources being used. This can be an expensive process, which might cause a degradation with regard to your application performance. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ot: jrun ?
i think i will just sit here and kick it awhile Could not create the Java virtual machine. Unrecognized option: -server Could not create the Java virtual machine. Unrecognized option: -server Could not create the Java virtual machine. -- Original Message -- From: Simon Horwith [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Thu, 23 Sep 2004 08:07:04 +0100 that's odd.One thing you might want to do is turn off auto-deploy. You can do this by going to the server's jrun.xml file DeployerService section and commenting out the attribute node that has a name attribute value ofdeployDirectory. If there are any file or url attribute tags (with that value in the name attribute) comment those out as well.Be aware that if you do this then nothing will deploy when you start the server - including ColdFusion.The server will then require much less memory to start, however. ~Simon Simon Horwith Member of Team Macromedia Macromedia Certified Master Instructor Editor-in-Chief, ColdFusion Developers Journal Blog - http://www.horwith.com dave wrote: ok, now does anyone know what i need to do to get back started up? reboot didnt work, starting from the control panel fails maybe i should do the right thing and uninstall it and reinstall on linux side ;) -- Original Message -- From: dave [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Wed, 22 Sep 2004 15:47:06 -0400 i turned it down from 512 mb to 128 mb and now it wont even start lol -- Original Message -- From: Dave Carabetta [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Tue, 21 Sep 2004 12:43:17 -0400 On Tue, 21 Sep 2004 11:35:05 -0500, Ben Frame [EMAIL PROTECTED] wrote: Neil, Why set the initial and max heap size the same?Is that recommendation documented from Macromedia anywhere or is that from your own experiences? Setting the two values to be the same increases performance in so far as it eliminates the need for the JVM to resize itself based on the resources being used. This can be an expensive process, which might cause a degradation with regard to your application performance. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Looping....again
Thanks for the ongoing help - I am now mapping out the loops and queries, and hope to get started writing the real one soon. I have played with your looping code a little to include a couple of other conditions, mainly being you need a separate piece of paper ( ie a new script ) for Authority drugs, and Dangerous Drugs. I have managed to get this to work. I will look more into the CFSAVECONTENT tag tonight. To add to your answer below, when the doctor logs on, he will query the db based upon his own prescriber number, that each doctor has allocated to them. Each drug has been dispensed under a separate prescriber number. Thanks again. Brant _ From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED] Sent: Wednesday, 22 September 2004 6:59 PM To: CF-Talk Subject: Re: Loopingagain Brant, My CFX_PDF tag don't work inside the loops though :-( so I think I am gonna have to go back to trying to build this data into another set of DB tables, but each drug given a script number so that I can then query the data based on the doctors name, and then build the scripts again, but with a less complex looping structure, so as to be able to include the cfx_pdf tags. OK - Here's a suggestionYou'll have to have a play to work out the best way to do this... Use CFSAVECONTENT to save the output from the cfloop through the data and then pass the contents of the cfsavecontent variable to your CFX_PDF tag after the end of the loop. As I have stated, I think I need to get this data back into a DB table, and mark each drug to belong to a unique script number? The doctors can then logon, and I can again run a query of querys to get the data out. If thats the case, then youneed only do a simple loop through the query generated from the CSV file and insert each record in turn into the database.When you insert each record you are going to want to split the data into multiple tables, one for the patient, one for the medication and one to link the paitent to the medication along with the other information specific to that item on this patients script. ie. pdocpresno, sqty,srpts etc.NOTE. It may not be feasible to spilt the medications out into a seperate table, so one table for patient and one for script rows will suffice. When a doctor logs in, give him a means to search for and select a patient, then you need only query the database for that one patient and their script records.When you output the data for cfx_pdf you will still need a loop much like the one I or Pascal created for you, to make sure you only get 3 lots of medication on a script. Which ever way you do this, don't bother inserting everything into a struct/array and then inserting it into a database or outputing it to cfx_pgp.Its just another brain drain and loop that isn't really required. As a total aside:Remember that you are storing personal information in a database.You will need to make sure that the practice's Data Protection subscription allows you to do this.If you are, then security of this data is of absolute paramount. Hope this all helps Regards Stephen _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Converting query to comma separated list
My first question, though I suspect this might not be the best approach . Is it possible to turn a query (cfdirectory in this case) into a comma separated list? The reason I ask is bcos currently I have a hardcoded list of folders in my action file, and I loop through and pull all the files from each. Like so... cfloop index = thisItem list = maps,districtPlans,mgmtPlans cfdirectory name=getAllFiles action=""> directory=#serverdir##thisItem# sort=name ASC cfquery dbtype=query name=getAllFiles_#thisItem# SELECT * FROM getAllFiles /cfquery /cfloop and in the display page something like... ol cfoutput query=getAllFiles_maps #replace(listFirst(name), _, , ALL)#br / /cfoutput /ol ol cfoutput query=getAllFiles_mgmtPlans #replace(listFirst(name), _, , ALL)#br / /cfoutput /ol etc etc This is all working fine. BUT, instead of hardcoding the list, I can do another directory call like so... cfdirectory name=getAllFolders action=""> directory=#serverdir# sort=name ASC which will give me all the folders that are in the above list (ie maps,districtPlans etc). So, how to get the query to a list so I don't need to hardcode? OR, is this the wrong approach and is it possible to use the getAllFolders query directly in some fashion? TIA Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Converting query to comma separated list
Why don't you just CFLOOP over the query? You don't need to convert the query to a comma list to loop over it... CFLOOP query=qry_name) ...cf code... /CFLOOP Andrew. - Original Message - From: Mark Henderson [EMAIL PROTECTED] Date: Thu, 23 Sep 2004 21:07:07 +1200 Subject: Converting query to comma separated list To: CF-Talk [EMAIL PROTECTED] My first question, though I suspect this might not be the best approach . Is it possible to turn a query (cfdirectory in this case) into a comma separated list? The reason I ask is bcos currently I have a hardcoded list of folders in my action file, and I loop through and pull all the files from each. Like so... cfloop index = thisItem list = maps,districtPlans,mgmtPlans cfdirectory name=getAllFiles action=""> directory=#serverdir##thisItem# sort=name ASC cfquery dbtype=query name=getAllFiles_#thisItem# SELECT * FROM getAllFiles /cfquery /cfloop and in the display page something like... ol cfoutput query=getAllFiles_maps #replace(listFirst(name), _, , ALL)#br / /cfoutput /ol ol cfoutput query=getAllFiles_mgmtPlans #replace(listFirst(name), _, , ALL)#br / /cfoutput /ol etc etc This is all working fine. BUT, instead of hardcoding the list, I can do another directory call like so... cfdirectory name=getAllFolders action=""> directory=#serverdir# sort=name ASC which will give me all the folders that are in the above list (ie maps,districtPlans etc). So, how to get the query to a list so I don't need to hardcode? OR, is this the wrong approach and is it possible to use the getAllFolders query directly in some fashion? TIA Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Converting query to comma separated list
Mark, Not sure if I understand your question but maybe ValueList() May be of some help? Kola -Original Message- From: Mark Henderson [mailto:[EMAIL PROTECTED] Sent: 23 September 2004 10:07 To: CF-Talk Subject: Converting query to comma separated list My first question, though I suspect this might not be the best approach . Is it possible to turn a query (cfdirectory in this case) into a comma separated list? The reason I ask is bcos currently I have a hardcoded list of folders in my action file, and I loop through and pull all the files from each. Like so... cfloop index = thisItem list = maps,districtPlans,mgmtPlans cfdirectory name=getAllFiles action=""> directory=#serverdir##thisItem# sort=name ASC cfquery dbtype=query name=getAllFiles_#thisItem# SELECT * FROM getAllFiles /cfquery /cfloop and in the display page something like... ol cfoutput query=getAllFiles_maps #replace(listFirst(name), _, , ALL)#br / /cfoutput /ol ol cfoutput query=getAllFiles_mgmtPlans #replace(listFirst(name), _, , ALL)#br / /cfoutput /ol etc etc This is all working fine. BUT, instead of hardcoding the list, I can do another directory call like so... cfdirectory name=getAllFolders action=""> directory=#serverdir# sort=name ASC which will give me all the folders that are in the above list (ie maps,districtPlans etc). So, how to get the query to a list so I don't need to hardcode? OR, is this the wrong approach and is it possible to use the getAllFolders query directly in some fashion? TIA Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Converting query to comma separated list
Thank you for the swift replies Andrew and Kola, and you're right Andrew. I'd already tried something similar, but was making it more complicated than necessary. Here's what works cfdirectory name=getAllFolders action=""> directory=#serverdir# sort=name ASC cfloop query = getAllFolders cfdirectory name=getAllFiles action=""> directory=#serverdir##name# sort=name ASC cfquery dbtype=query name=getAllFiles_#name# SELECT * FROM getAllFiles /cfquery /cfloop adieu Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Converting query to comma separated list
That look like what I was thinking of. Just make sure that if you are using an older version of CF (CF4/5 I think) that CFDIRECTORY returned the . and .. directories, but CFMX doesn't do this. As you say it works I'm guess you are on CFMX. Andrew. - Original Message - From: Mark Henderson [EMAIL PROTECTED] Date: Thu, 23 Sep 2004 22:14:06 +1200 Subject: Re: Converting query to comma separated list To: CF-Talk [EMAIL PROTECTED] Thank you for the swift replies Andrew and Kola, and you're right Andrew. I'd already tried something similar, but was making it more complicated than necessary. Here's what works cfdirectory name=getAllFolders action=""> directory=#serverdir# sort=name ASC cfloop query = getAllFolders cfdirectory name=getAllFiles action=""> directory=#serverdir##name# sort=name ASC cfquery dbtype=query name=getAllFiles_#name# SELECT * FROM getAllFiles /cfquery /cfloop adieu Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Disabling request timeouts
I want to have a global request timeout on the server of about 30 seconds but there are a few (3 so far) templates that I need to be able to run for up to 30 minutes.Is there no way to disable the timeout for an individual template or am I going to have to disable it in the administrator and then enable it one page at a time with the cfsetting tag? -- James Smith [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Disabling request timeouts
Just add cfsetting... to your Application.cfm file and all pages will inherit the timeout if required. _ From: James Smith [mailto:[EMAIL PROTECTED] Sent: 23 September 2004 11:55 To: CF-Talk Subject: Disabling request timeouts I want to have a global request timeout on the server of about 30 seconds but there are a few (3 so far) templates that I need to be able to run for up to 30 minutes.Is there no way to disable the timeout for an individual template or am I going to have to disable it in the administrator and then enable it one page at a time with the cfsetting tag? -- James Smith [EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Disabling request timeouts
Though really if you are running a page for 30 mins then I would look at an alternative approach...I would assume that the length of time to run it due to SQL...maybe look at DTS. _ From: James Smith [mailto:[EMAIL PROTECTED] Sent: 23 September 2004 11:55 To: CF-Talk Subject: Disabling request timeouts I want to have a global request timeout on the server of about 30 seconds but there are a few (3 so far) templates that I need to be able to run for up to 30 minutes.Is there no way to disable the timeout for an individual template or am I going to have to disable it in the administrator and then enable it one page at a time with the cfsetting tag? -- James Smith [EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Disabling request timeouts
The time is actually caused by looking up a couple of thousand web pages (by cfhttp) and processing the returned pages to extract some info. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 23 September 2004 12:00 To: CF-Talk Subject: RE: Disabling request timeouts Though really if you are running a page for 30 mins then I would look at an alternative approach...I would assume that the length of time to run it due to SQL...maybe look at DTS. _ From: James Smith [mailto:[EMAIL PROTECTED] Sent: 23 September 2004 11:55 To: CF-Talk Subject: Disabling request timeouts I want to have a global request timeout on the server of about 30 seconds but there are a few (3 so far) templates that I need to be able to run for up to 30 minutes.Is there no way to disable the timeout for an individual template or am I going to have to disable it in the administrator and then enable it one page at a time with the cfsetting tag? -- James Smith [EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Disabling request timeouts
No good, the templates that require extra time would also inherit the timeout.I could use some cfif logic to use the cfsetting on all pages except a couple listed, i.e cfif CGI.SCRIPT_NAME IS NOT . cfsetting . /cfif But really I want the control to be on the templates for the long pages. If... cfsetting requesttimeout=0 worked as a disable that would be perfect because I could set a global 30 seconds in the administrator (or application.cfm) then just disable it on the few, but it doesn't.I am reluctant to use cfsetting requesttimeout=2 as I really want to disable the timeout, not just extend it. -- Jay -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 23 September 2004 11:59 To: CF-Talk Subject: RE: Disabling request timeouts Just add cfsetting... to your Application.cfm file and all pages will inherit the timeout if required. _ From: James Smith [mailto:[EMAIL PROTECTED] Sent: 23 September 2004 11:55 To: CF-Talk Subject: Disabling request timeouts I want to have a global request timeout on the server of about 30 seconds but there are a few (3 so far) templates that I need to be able to run for up to 30 minutes.Is there no way to disable the timeout for an individual template or am I going to have to disable it in the administrator and then enable it one page at a time with the cfsetting tag? -- James Smith [EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Disabling request timeouts
Jeez..hefty! _ From: James Smith [mailto:[EMAIL PROTECTED] Sent: 23 September 2004 12:07 To: CF-Talk Subject: RE: Disabling request timeouts The time is actually caused by looking up a couple of thousand web pages (by cfhttp) and processing the returned pages to extract some info. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 23 September 2004 12:00 To: CF-Talk Subject: RE: Disabling request timeouts Though really if you are running a page for 30 mins then I would look at an alternative approach...I would assume that the length of time to run it due to SQL...maybe look at DTS. _ From: James Smith [mailto:[EMAIL PROTECTED] Sent: 23 September 2004 11:55 To: CF-Talk Subject: Disabling request timeouts I want to have a global request timeout on the server of about 30 seconds but there are a few (3 so far) templates that I need to be able to run for up to 30 minutes.Is there no way to disable the timeout for an individual template or am I going to have to disable it in the administrator and then enable it one page at a time with the cfsetting tag? -- James Smith [EMAIL PROTECTED] _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Disabling request timeouts
Yeah, fortunately most of the time is spent waiting for the http responses which uses no system resources so the templates just run in the background and don't even make a noticeable mark on the CPU usage. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 23 September 2004 12:14 To: CF-Talk Subject: RE: Disabling request timeouts Jeez..hefty! _ From: James Smith [mailto:[EMAIL PROTECTED] Sent: 23 September 2004 12:07 To: CF-Talk Subject: RE: Disabling request timeouts The time is actually caused by looking up a couple of thousand web pages (by cfhttp) and processing the returned pages to extract some info. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 23 September 2004 12:00 To: CF-Talk Subject: RE: Disabling request timeouts Though really if you are running a page for 30 mins then I would look at an alternative approach...I would assume that the length of time to run it due to SQL...maybe look at DTS. _ From: James Smith [mailto:[EMAIL PROTECTED] Sent: 23 September 2004 11:55 To: CF-Talk Subject: Disabling request timeouts I want to have a global request timeout on the server of about 30 seconds but there are a few (3 so far) templates that I need to be able to run for up to 30 minutes.Is there no way to disable the timeout for an individual template or am I going to have to disable it in the administrator and then enable it one page at a time with the cfsetting tag? -- James Smith [EMAIL PROTECTED] _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Disabling request timeouts
You can't disable it, and you shouldn't. Set it to a high value and don't place the tag in the Application.cfm, but in the template that needs it. Pascal -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: 23 September 2004 13:14 To: CF-Talk Subject: [Spam?] RE: Disabling request timeouts No good, the templates that require extra time would also inherit the timeout.I could use some cfif logic to use the cfsetting on all pages except a couple listed, i.e cfif CGI.SCRIPT_NAME IS NOT . cfsetting . /cfif But really I want the control to be on the templates for the long pages. If... cfsetting requesttimeout=0 worked as a disable that would be perfect because I could set a global 30 seconds in the administrator (or application.cfm) then just disable it on the few, but it doesn't.I am reluctant to use cfsetting requesttimeout=2 as I really want to disable the timeout, not just extend it. -- Jay [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFPOP Issues
Hi, One of my hosting clients is having an issue withn CFPOP and I'm not sure how to advise him: I have been accessing the emails coming into my main account ([EMAIL PROTECTED]) for some time now, using CFPOP as it is a requirement for a process within my application. For a time I was getting in ok, but then I started receiving the following message: java.lang.IllegalStateException: Folder is not Open I did some research into this error and discovered that in J2EE applications it sometimes occurs when trying to access the mail server via a proxy and not directly - the mail body retrieval eg: cfpop action="" out if you have just asked for the email header in the preceding request. The problem seems to have degenrated even further now, and I can't gain access to my mail box via CFPOP anymore at all, it just hangs and eventually reports the same folder not open message (even though I'm only trying to get the first 10 emails). Any ideas? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CF Webmail
Hi guys! Do you know a webmail built on CF ? I need it on a BlueDragon server but if it works on CF5 or CFMX I will make it work on BD if the source is available. Thanks, mack / [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Disabling request timeouts
Not sure what you mean? If you place it in the Application.cfm page and set the value high then only the pages which need that high value will utilize it...the others will parse as normal You cant disable the timeout. I cannot see why adding it to Application is a problem?! N From: James Smith [mailto:[EMAIL PROTECTED] Sent: 23 September 2004 12:14 To: CF-Talk Subject: RE: Disabling request timeouts No good, the templates that require extra time would also inherit the timeout. I could use some cfif logic to use the cfsetting on all pages except a couple listed, i.e cfif CGI.SCRIPT_NAME IS NOT . cfsetting . /cfif But really I want the control to be on the templates for the long pages. If... cfsetting requesttimeout=0 worked as a disable that would be perfect because I could set a global 30 seconds in the administrator (or application.cfm) then just disable it on the few, but it doesn't. I am reluctant to use cfsetting requesttimeout=2 as I really want to disable the timeout, not just extend it. -- Jay -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 23 September 2004 11:59 To: CF-Talk Subject: RE: Disabling request timeouts Just add cfsetting... to your Application.cfm file and all pages will inherit the timeout if required. _ From: James Smith [mailto:[EMAIL PROTECTED] Sent: 23 September 2004 11:55 To: CF-Talk Subject: Disabling request timeouts I want to have a global request timeout on the server of about 30 seconds but there are a few (3 so far) templates that I need to be able to run for up to 30 minutes. Is there no way to disable the timeout for an individual template or am I going to have to disable it in the administrator and then enable it one page at a time with the cfsetting tag? -- James Smith [EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Quick and Easy way to submit/enter all form fields
I am looking for an easy way of submitting something like 100 form fields into the corresponding fields in a database, assuming that the field names in the database match the field names on the form. Is there a method to grabbing all of the fields from the form and submitting into the equivalent fields in the database, or do I need to resort to the mile-long ISERT blah blah blah INTO blah blah blah? Thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Quick and Easy way to submit/enter all form fields
Tried the wizard in dreamweaver? MD On Wed, 22 Sep 2004 15:55:18 -0400, Claremont, Timothy [EMAIL PROTECTED] wrote: I am looking for an easy way of submitting something like 100 form fields into the corresponding fields in a database, assuming that the field names in the database match the field names on the form. Is there a method to grabbing all of the fields from the form and submitting into the equivalent fields in the database, or do I need to resort to the mile-long ISERT blah blah blah INTO blah blah blah? Thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Quick and Easy way to submit/enter all form fields
Try cfinsert. http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p66.htm#wp110047 2 -- Jay -Original Message- From: Claremont, Timothy [mailto:[EMAIL PROTECTED] Sent: 22 September 2004 20:55 To: CF-Talk Subject: Quick and Easy way to submit/enter all form fields I am looking for an easy way of submitting something like 100 form fields into the corresponding fields in a database, assuming that the field names in the database match the field names on the form. Is there a method to grabbing all of the fields from the form and submitting into the equivalent fields in the database, or do I need to resort to the mile-long ISERT blah blah blah INTO blah blah blah? Thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ot: jrun ?
that looks like the error generated when you use the JMC to update
your class path or something.Need to edit {jrunhome}/bin/jvm.config
and get it fixored.Below is a copy of one from a vanilla install
that you can use as a guide perhaps. IIRC, you said you are on linux,
the below is from windows.The args to the JVM and such should be the
same, but the paths are all different.HTH
#
# VM configuration
#
# Where to find JVM, if {java.home}/jre exists then that JVM is used
# if not then it must be the path to the JRE itself
java.home=D:/JRun4/runtime/jre
#
# If no java.home is specified a VM is located by looking in these
places in this
# order:
#
#1) bin directory for java.dll (windows) or lib/ARCH/libjava.so (unix)
#2) ../jre
#3) registry (windows only)
#4) JAVA_HOME env var plus jre (ie $JAVA_HOME/jre)
#
# Arguments to VM
java.args=-server -Xms512m -Xmx512m -Dsun.io.useCanonCaches=false
-Xbootclasspath/a:{application.home}/servers/cfusion/cfusion-ear/cfusion-war/WEB-INF/cfusion/lib/webchartsJava2D.jar
-XX:MaxPermSize=128m -XX:+UseParallelGC -DJINTEGRA_NATIVE_MODE
-DJINTEGRA_PREFETCH_ENUMS
#
# commas will be converted to platform specific separator and the
result will be passed
# as -Djava.ext.dirs= to the VM
java.ext.dirs={jre.home}/lib/ext
#
# where to find shared libraries
java.library.path={application.home}/servers/cfusion/cfusion-ear/cfusion-war/WEB-INF/cfusion/lib,{application.home}/servers/cfusion/cfusion-ear/cfusion-war/WEB-INF/cfusion/jintegra/bin,{application.home}/servers/cfusion/cfusion-ear/cfusion-war/WEB-INF/cfusion/jintegra/bin/international,{application.home}/servers/cfusion/cfusion-ear/cfusion-war/WEB-INF/cfusion/lib/_nti40/bin
system.path.first=false
# JVM classpath
java.class.path={application.home}/servers/lib,{application.home}/servers/cfusion/cfusion-ear/cfusion-war/WEB-INF/cfusion/lib/cfusion.jar,{application.home}/servers/cfusion/cfusion-ear/cfusion-war/WEB-INF/cfusion/lib,{application.home}/lib/jrun.jar,{application.home}/lib
- Original Message -
From: dave [EMAIL PROTECTED]
Date: Thu, 23 Sep 2004 03:21:49 -0400
Subject: Re: ot: jrun ?
To: CF-Talk [EMAIL PROTECTED]
i think i will just sit here and kick it awhile
Could not create the Java virtual machine.
Unrecognized option: -server
Could not create the Java virtual machine.
Unrecognized option: -server
Could not create the Java virtual machine.
-- Original Message --
From: Simon Horwith [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:Thu, 23 Sep 2004 08:07:04 +0100
that's odd.One thing you might want to do is turn off auto-deploy.
You can do this by going to the server's jrun.xml file DeployerService
section and commenting out the attribute node that has a name
attribute value ofdeployDirectory. If there are any file or url
attribute tags (with that value in the name attribute) comment those
out as well.Be aware that if you do this then nothing will deploy when
you start the server - including ColdFusion.The server will then
require much less memory to start, however.
~Simon
Simon Horwith
Member of Team Macromedia
Macromedia Certified Master Instructor
Editor-in-Chief, ColdFusion Developers Journal
Blog - http://www.horwith.com
dave wrote:
ok, now does anyone know what i need to do to get back started up?
reboot didnt work, starting from the control panel fails
maybe i should do the right thing and uninstall it and reinstall on
linux side ;)
-- Original Message --
From: dave [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:Wed, 22 Sep 2004 15:47:06 -0400
i turned it down from 512 mb to 128 mb and now it wont even start lol
-- Original Message --
From: Dave Carabetta [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:Tue, 21 Sep 2004 12:43:17 -0400
On Tue, 21 Sep 2004 11:35:05 -0500, Ben Frame [EMAIL PROTECTED] wrote:
Neil,
Why set the initial and max heap size the same?Is that
recommendation documented from Macromedia anywhere or is that from
your own experiences?
Setting the two values to be the same increases performance in so far
as it eliminates the need for the JVM to resize itself based on the
resources being used. This can be an expensive process, which might
cause a degradation with regard to your application performance.
Regards,
Dave.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: Quick and Easy way to submit/enter all form fields
I would say INSERT if you are 100% certain that all field names match up.However, if you want a manual way of doing it, here's a quick hack of a suggestion. cfset columnList = cfset valueList = cfloop index=formField list=#form.fieldnames# delimiters=, cfset columnList = ListAppend(columnList, formField, ,) cfset valueList = ListAppend(valueList, form[formField], ,) /cfloop cfquery name=q_insert_form_fields INSERT INTO MyTable ( #columnList# ) VALUES ( #valueList# ) /cfquery [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Quick and Easy way to submit/enter all form fields
ugh, use of cfinsert is commonly disuaded.Like Mark mentioned, check out the wizardy gizmos in DW to generate your insert SQL. Doug - Original Message - From: James Smith [EMAIL PROTECTED] Date: Thu, 23 Sep 2004 13:48:51 +0100 Subject: RE: Quick and Easy way to submit/enter all form fields To: CF-Talk [EMAIL PROTECTED] Try cfinsert. http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p66.htm#wp110047 2 -- Jay -Original Message- From: Claremont, Timothy [mailto:[EMAIL PROTECTED] Sent: 22 September 2004 20:55 To: CF-Talk Subject: Quick and Easy way to submit/enter all form fields I am looking for an easy way of submitting something like 100 form fields into the corresponding fields in a database, assuming that the field names in the database match the field names on the form. Is there a method to grabbing all of the fields from the form and submitting into the equivalent fields in the database, or do I need to resort to the mile-long ISERT blah blah blah INTO blah blah blah? Thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Quick and Easy way to submit/enter all form fields
Something worth noting is that with either this method or the cfinsert method you will have errors generated by the submit button (unless you have a field for it in the BD!) but the simple workaround is to have the submit button with a blank name, ie: input type=submit name= value=Insert That should do it. -- Jay -Original Message- From: Steve Brownlee [mailto:[EMAIL PROTECTED] Sent: 23 September 2004 13:56 To: CF-Talk Subject: Re: Quick and Easy way to submit/enter all form fields I would say INSERT if you are 100% certain that all field names match up.However, if you want a manual way of doing it, here's a quick hack of a suggestion. cfset columnList = cfset valueList = cfloop index=formField list=#form.fieldnames# delimiters=, cfset columnList = ListAppend(columnList, formField, ,) cfset valueList = ListAppend(valueList, form[formField], ,) /cfloop cfquery name=q_insert_form_fields INSERT INTO MyTable ( #columnList# ) VALUES ( #valueList# ) /cfquery [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: JAVASCRIPT and textarea
Micheal will you please give me an example how to replace i.e. you mean to do the server side validation???
I need the client side validation.
Ryan, does DOM works in mac as well??
thanks
I agree.Simply replace after the submit.
Also, you can strip complicated things out using DOM.
We use the DOM to strip out HTML tags such as: Removing FONT tag.
if(child.tagName.toUpperCase() == 'FONT'){
child.removeNode();
}
Good luck.
Ryan Duckworth
Macromedia ColdFusion Certified Professional
Uhlig Communications
10983 Granada Lane
Overland Park, KS 66211
(913) 754-4272
_
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 22, 2004 3:58 PM
To: CF-Talk
Subject: RE: _javascript_ and textarea
You handle the keyCode event but not the change (onChange) event which
you need to check also to ensure that a copy past fires off the routine
needed to validate the entry into the box.
Michael T. Tangorre
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: Quick and Easy way to submit/enter all form fields
Is there a method to grabbing all of the fields from the form and submitting into the equivalent fields in the database, or do I need to resort to the mile-long ISERT blah blah blah INTO blah blah blah? I would strongly recommend that you stick with the mile-long INSERT statement. You only have to write the code once, and you'll be able to use CFQUERYPARAM, which you should always use when using data from the browser in your SQL statement. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: debug question
I'm on CF 5 still =( any idea where I can find it on that? _ From: Qasim Rasheed [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 5:41 PM To: CF-Talk Subject: Re: debug question Jason, If you didn't find a custom made function, I think you can take a look at debug.cfm under C:\CFusionMX\wwwroot\WEB-INF\debug and get a head start. - Original Message - From: Jason Reichenbach [EMAIL PROTECTED] Date: Wed, 22 Sep 2004 17:27:38 -0400 Subject: RE: debug question To: CF-Talk [EMAIL PROTECTED] It needs to dump all the info the debug dump ie pages that are executed, time it took to execute, sessionvars, urlvars,formvars. Everything you can think of. _ From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 5:15 PM To: CF-Talk Subject: RE: debug question Jay: Does it have to be a function?Why not just do something like: CFMAIL ... Here's the SESSION debug data: CFDEBUG VAR=#SESSION# /CFMAIL -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ Jason Reichenbach wrote: Is there a function out there that mimics CF's Debug? I'm looking for something along these lines to provide in an email. The function would have to act almost exactly as CF's dbug? TIA _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Disabling request timeouts
Yeah, fortunately most of the time is spent waiting for the http responses which uses no system resources so the templates just run in the background and don't even make a noticeable mark on the CPU usage. While it might not affect CPU usage, it almost certainly affects server throughput. While that long request is running, the thread processing that request can't process any other requests. CF has a fixed number of threads with which to process requests. If possible, I'd recommend that you perform this long-running task using something other than CF. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: Reliable SEO company recommendations?
My company is looking for someone to do search engine optimization on our sites. Can anyone recommend a reliable, reputable company for the job? We're in the DC area. Please reply to me off list. Thanks! Rachel Maxim - - - - - - - - - - - - - - - - - - - - - - - - Creative Director Case Design/Remodeling, Inc. Case Handyman Services, LLC 301.229.9380x283 [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Converting query to comma separated list
Mark, I posted a CFC called queryTool to my site (http://clearsoftware.net - downloads - queryTool) and to cfcZone.org that converts queries to delimited formats, XML, arrays, and structures.Perfectly free, seems to work pretty well. Cheers, Joe - Original Message - From: Mark Henderson [EMAIL PROTECTED] Date: Thu, 23 Sep 2004 22:14:06 +1200 Subject: Re: Converting query to comma separated list To: CF-Talk [EMAIL PROTECTED] Thank you for the swift replies Andrew and Kola, and you're right Andrew. I'd already tried something similar, but was making it more complicated than necessary. Here's what works cfdirectory name=getAllFolders action=""> directory=#serverdir# sort=name ASC cfloop query = getAllFolders cfdirectory name=getAllFiles action=""> directory=#serverdir##name# sort=name ASC cfquery dbtype=query name=getAllFiles_#name# SELECT * FROM getAllFiles /cfquery /cfloop adieu Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT: JS Gateway Question
Mike, Sure send me the page and I will take a look at it.Friday's are best for me because that's the day I work from home.No less busy, but it's easier to fit in some extra stuff that day. Rick Mason - Original Message - From: Michael T. Tangorre [EMAIL PROTECTED] Date: Thu, 23 Sep 2004 01:38:10 -0400 Subject: RE: OT: JS Gateway Question To: CF-Talk [EMAIL PROTECTED] So you want to be able to return to the page with the values the user saved the first time already selected?As opposed to returning to the beginning? Yes, return right away or in the future, no difference in desired functionality. It is one form with 35 form elements. Have you thought about having an optional where statement in both queries that only returns one value?So that when the user returned to the page the query for A fires and only his selected value for A is returned and ditto for B. This is where the problem lies. The form elements in question are intAgency and intBureau. The user saved the form initially with intAgency = 1000 and intBureau = 1011. Now the desired result upon returning to the form would be for the form to populate with the selected values, including intAgency and intBureau. However, since intAgency and intBureau are tied to the gateway, the intAgency field must first be populated before the value can be set... and, once set, the gateway routines need to run to get the value of intAgency, pass it into the gateway, returning the values to populate into intBureau. At that point intBureau can be set. The biggest problem is trying to find out what specific order the gateway runs in compared to the rest of the page rendering and also how to control the gateway to avoid the endless loop I find myself in when trying to take such control within the predefined methods. Does all that make better sense? I am confusing myself I think :-) If I could show you the page, it would be much easier!!!... but its on our intranet in development. Maybe tomorrow at work I will save the rendered page and send you a zip file of the files so you can get a better sense of what in the heck I am trying to do... unless you follow me now. I appreciate your input... hopefully I find a solution before moving on to an alternate solution. Regards, Mike T. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfc variables
Barney suggested adding your DSN, UN, and PW as actual arguments to the function. I've been using the way of the Jedi, Ray Camden :), lately.Setup a config.ini file with your dsn name, un, pw, etc.. and have your CFC read theses values in when its instantiated.I've actually gone a step further and created a 'parent' CFC that my other CFCs extend. This parent holds the config.ini settings. Doug - Original Message - From: dave [EMAIL PROTECTED] Date: Wed, 22 Sep 2004 21:45:39 -0400 Subject: Re: cfc variables To: CF-Talk [EMAIL PROTECTED] not real sure how that would work say i have the cfc !--- get agents name --- cfcomponent cffunction name=mainpage access=public returntype=query hint=get mainpage info !--- set site dsn connection --- cfset dsn = whenever cfset un = whoever cfset pw = whatever cfquery name=qMP datasource=#dsn# username=#un# password=#pw# SELECT * FROM mainpage /cfquery cfreturn qMP /cffunction /cfcomponent and then the object call from the application.cfm template cfobject name=amainPage component=components.mainpage how would it be put in? thanks :) -- Original Message -- From: Barney Boisvert [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Wed, 22 Sep 2004 18:17:07 -0700 What scope are you setting them into?Each CFC instance has it's own 'variables' scope, but it can reference any of the shared scopes (app, session, server) and any of the request scopes (url, form, request, client). However, before you change that, you're almost always better off passing in values to your CFCs (with the init() method), rather than letting your CFCs reference any external variables.When you instantiate your CFC, just pass along your DSN and whatever else, and store it inside the CFC.That way you stick with only having a single place to record the data (Application.cfm), and you don't have your CFCs referencing external variables anywhere. cheers, barneyb On Wed, 22 Sep 2004 21:09:43 -0400, dave [EMAIL PROTECTED] wrote: i have never seen an explanation for this and maybe i am on crack again but. say i have the db connection variables in cfc why wont they read from the Application.cfm file? or will they? when i set it up to read it that way it fails kinda a PITA to go into every cfc to do it [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Authorize.net Tag Problem
I've never had any problems before, but recently I started getting the following error using the authorize_net_3 custom tag.I am just trying to work out if my server (CF 5) is having a general problem with CFHTTP or if authorize.net made a change, or something like that.The error that's been popping up is: An error occurred while evaluating the _expression_: product.response_subcode = ListGetAt(cfhttp.fileContent, '2') Error near line 144, column 8. - In function ListGetAt(list, index [, delimiters]) the value of index, which is 2, is not a valid index for the list given as a the first argument (this list has 1 elements). Valid indexes are in the range 1 through the number of elements in the list Caught an exception, type = _expression_ Thank you. - Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Authorize.net Tag Problem
May this have something to do with it? http://www.theregister.co.uk/2004/09/23/authorize_ddos_attack/ -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Authorize.net Tag Problem
Authorize.net is currently suffering from intermittent outages caused by distributed denial of service attacks. - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Converting query to comma separated list
Joe,
Got the following error trying to access your site
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Could not allocate space for
object 'clearsoftware_visitors' in database 'clearsoftware_net_01' because
the 'PRIMARY' filegroup is full.
The error occurred in
D:\Inetpub\wwwroot\clearsoftware.net\wwwroot\client\tracker.cfc: line 21
Called from
D:\Inetpub\wwwroot\clearsoftware.net\wwwroot\client\Application.cfm: line 26
Called from D:\Inetpub\wwwroot\clearsoftware.net\wwwroot\client\tracker.cfc:
line 21
Called from
D:\Inetpub\wwwroot\clearsoftware.net\wwwroot\client\Application.cfm: line 26
19 : cfprocparam cfsqltype=cf_sql_varchar
value=#arguments.firstName# /
20 : cfprocparam cfsqltype=cf_sql_varchar
value=#arguments.lastName# /
21 : cfprocresult name=result maxrows=1 /
22 :/cfstoredproc
23 :
_
SQL
{call clearsoftware_createVisitor( (param 1) , (param 2) , (param 3) ,
(param 4) , (param 5) , (param 6) )}
DATASOURCE
clearsoftware_glass
VENDORERRORCODE
1105
SQLSTATE
HY000
Please try the following:
* Check the ColdFusion http://www.macromedia.com/go/proddoc_getdoc
documentation to verify that you are using the correct syntax.
* Search the Knowledge http://www.macromedia.com/support/coldfusion/
Base to find a solution to your problem.
Browser
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)
Remote Address
65.242.127.130
Referrer
Date/Time
23-Sep-04 09:21 AM
Stack Trace (click to expand) _javascript_:;
Scott A. Stewart,
Web Application Developer
Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt Place, Suite 100
Chantilly, VA 20151
Phone: (703) 471-8400
Fax: (703) 834-5527
-Original Message-
From: Joe Rinehart [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 23, 2004 09:37 am
To: CF-Talk
Subject: Re: Converting query to comma separated list
Mark,
I posted a CFC called queryTool to my site (http://clearsoftware.net
- downloads - queryTool) and to cfcZone.org that converts queries to
delimited formats, XML, arrays, and structures.Perfectly free, seems
to work pretty well.
Cheers,
Joe
- Original Message -
From: Mark Henderson [EMAIL PROTECTED]
Date: Thu, 23 Sep 2004 22:14:06 +1200
Subject: Re: Converting query to comma separated list
To: CF-Talk [EMAIL PROTECTED]
Thank you for the swift replies Andrew and Kola,
and you're right Andrew. I'd already tried something similar, but was making
it more complicated than necessary. Here's what works
cfdirectory
name=getAllFolders
action="">
directory=#serverdir#
sort=name ASC
cfloop query = getAllFolders
cfdirectory
name=getAllFiles
action="">
directory=#serverdir##name#
sort=name ASC
cfquery dbtype=query name=getAllFiles_#name#
SELECT *
FROM getAllFiles
/cfquery
/cfloop
adieu
Mark
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: Authorize.net Tag Problem
Eron, Are you still using https://www.authorize.net? We were told yesterday by tech cupport that the address needs to be https://secure.authorize.net This instantly speeded up the requests, and many more are going through. (Note: we are still having intermittent problems, but much less than on www.) Jerry Johnson [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Authorize.net Tag Problem
Darn. That was supposed to go direct. Stupid reply-all! Jerry Johnson [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: Problems with subversion (1.1)?
I'm about to move from Perforce and CVS to using Subversion for our revision management.Has anyone had any problems with it?I'm going to start using the v1.1 release (just 'cause I can)... -- *Damien McKenna* - Web Developer - [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 Nothing endures but change. - Heraclitus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Problems with subversion (1.1)?
I'm about to move from Perforce and CVS to using Subversion for our revision management.Has anyone had any problems with it?I'm going to start using the v1.1 release (just 'cause I can)... I moved from CVS to Subversion and I will never look back. But I avoided v 1.1 so far since it's still a release candidate (even if the new FSF based repository would be handy for me), so I can't comment on it From a user perspective migrating from CVS is quite simple; still, I would suggest to start with a pilot project to get a better feeling I guess you are already aware of the book, I think it's a great resource: http://svnbook.red-bean.com/ Massimo Foti http://www.massimocorner.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT: Problems with subversion (1.1)?
Speaking of which, is anyone else having problems getting through to tigris.org?I was there last night and this morning at home but am completely unable to get to it from work. -- *Damien McKenna* - Web Developer - [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 Nothing endures but change. - Heraclitus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SOT: Windows to Unix Link capitalization problem
That would be a good idea, but I don't have access to that server at all...and it would take alot to get them to do it or to get them to let me do it.I was hoping for some kind of automated tool that would go through and look for these case sensitive issues.I guess it may not exist. E C list wrote: Does anyone know of a tool that will look for capitalization of file names in URL links and convert them to lower case? Look up how to do URL rewriting (mod_rewrite in apache). __ Do You Yahoo!? Tired of spam?Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFMX - XP SP2 and SQL Server
I had the same problem too, the event log on XP told me that SQL was diabled as it wasn't patched to prevent the SQL slammer and the like. -t - Original Message - From: Kay Smoljak [EMAIL PROTECTED] Date: Thu, 23 Sep 2004 14:23:10 +0800 Subject: Re: CFMX - XP SP2 and SQL Server To: CF-Talk [EMAIL PROTECTED] Qasim Rasheed [EMAIL PROTECTED] wrote: Recently I installed XP SP2 on my machine and suddenly ColdFusion MX is unable to connect to my SQL server present on the same machine. John Beynon [EMAIL PROTECTED] wrote: i think you have to do something odd like sp3 your SQL server install, I had this exact issue on the boss's demo laptop, and installing SQL Server SP3 fixed it right up. Thanks JB! K. -- Kay Smoljak http://kay.smoljak.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Authorize.net Tag Problem
Since September 15th... At 07:18 AM 9/23/2004, you wrote: Authorize.net is currently suffering from intermittent outages caused by distributed denial of service attacks. - Rick -- [http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads] [http://www.houseoffusion.com/lists.cfm/link=i:4:179463This Message] [http://www.houseoffusion.com/lists.cfm/link=s:4Subscription] [http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=649.569.4Fast Unsubscribe] [http://www.houseoffusion.com/signin/User Settings] [https://www.paypal.com/cgi-bin/webscr?amount=item_name=House+of+Fusionbusiness=donations%40houseoffusion.comundefined_quantity=cmd=_xclickDonations and Support] -- http://www.houseoffusion.com/banners/view.cfm?bannerid=36 28b96b1a.jpg [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT: Problems with subversion (1.1)?
Damien McKenna wrote: I'm about to move from Perforce and CVS to using Subversion for our revision management.Has anyone had any problems with it?I'm going to start using the v1.1 release (just 'cause I can)... I'm using the 1.0 version, and it works quite well. The only difference you will see is that more programs will support CVS than subversion. __ Pete Freitag http://www.cfdev.com/ Author of the CFMX Developers Cookbook http://www.petefreitag.com/bookshelf/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Distribute cf as java bytecode atop a J2EE server: What do I need?
Hi, I love the idea of being able to distribute compiled Java bitecode, without CFML source, on top of a J2EE server. Blackstone will let me do this. However, I have no knowledge regarding the building of a J2EE server. What do I need? This J2EE server will be used internally, and the web apps will be on an intranet by a dozen or so people. We're all running Windows. Is this even possible? Thanks in advance for any assistance. Sincerely, Andrew [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Question about CFHTTP running on CF4.5
Hi, First let me say I know that it is an old very version of CF but thats what I have to use on these servers as they have not been upgraded yet. My problem is that my one server is running 4.5.1 and the other is running 4.5 and I trying to do a CFHTTP call to an internal server to get a list of stock quotes. The problem is that it works on 4.5.0 but not on 4.5.1.On the 4.5.1 box I get a connect refused error but on the 4.5.0 I do not. Is there a setting on the CF server that needs to change or is there a setting (security) on the box that I call to get the page that needs to be set. Here is the very simple code: CFHTTP METHOD=Get URL="" http://www.csfb.net/CSFBToday/intranet/ http://www.csfb.net/CSFBToday/intranet/ RESOLVEURL=YES cfoutput #CFHTTP.StatusCode#br #CFHTTP.MimeType#br #CFHTTP.Header#br #CFHTTP.FileContent#br /cfoutput Thanks Mario [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
SOT - Crystal Reports Training
I am looking for Crystal Reports training.Has anyone ever taken any classes like this?What companies would you reccomend?Cost isn't really an issue.I would like something in either N.C. or S.C, but anywhere will do.Time is the most important factor here.The sooner I can find a class, the better. Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: Oracle 9i
If I have am building an extremely large string (40,000 chars) in a PL/SQL stored procedure.Would it be better to keep concatenating a variable of a CLOB datatype?Or build 10 varchars and concatenate them at the end into a CLOB? I have noticed that my stored procedure runs very slow using the clob. if I use a single varchar(4000) the procedure runs very fast. If I limit the data to 4000 chars and do the same with a clob it runs very slow. The way I am doing this is concat(ClobString, 'some more text') over and over and over again. Slow Thanks, David [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Doug White - clickdoug.com
I noticed there was a thread in CF-Community from a few weeks ago of people who were hosting with Doug White (www.clickdoug.com) who had experienced his outage that never came back up and are having trouble contacting him.Has anyone had any luck with this?We were hosting with him and moved all of our sites to rackspace.com but are in serious need of some files and stuff off of the server that Doug White has. Calling and emailing has resulted in nothing.We've filed a report with the San Antonio Police Department and are in the process of filing a law suit.I'd like to avoid all of that by getting in touch with him, but it appears that he's trying to skip out of the business with everyone's money and files.Anyone have any information that could help?Thanks. John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Question about CFHTTP running on CF4.5
My problem is that my one server is running 4.5.1 and the other is running 4.5 and I trying to do a CFHTTP call to an internal server to get a list of stock quotes. The problem is that it works on 4.5.0 but not on 4.5.1.On the 4.5.1 box I get a connect refused error but on the 4.5.0 I do not. Are you able to connect to that URL from the console of the problematic server using a browser? Very often, problems with CFHTTP are really problems with the network configuration. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Doug White - clickdoug.com
Yikes... Good luck with getting your files... -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 11:17 AM To: CF-Talk Subject: Doug White - clickdoug.com I noticed there was a thread in CF-Community from a few weeks ago of people who were hosting with Doug White (www.clickdoug.com) who had experienced his outage that never came back up and are having trouble contacting him.Has anyone had any luck with this?We were hosting with him and moved all of our sites to rackspace.com but are in serious need of some files and stuff off of the server that Doug White has. Calling and emailing has resulted in nothing.We've filed a report with the San Antonio Police Department and are in the process of filing a law suit.I'd like to avoid all of that by getting in touch with him, but it appears that he's trying to skip out of the business with everyone's money and files.Anyone have any information that could help? Thanks. John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT: Oracle 9i
Have you tried using the DBMS_LOB.Append function? -Adam - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Thu, 23 Sep 2004 11:16:02 -0400 Subject: OT: Oracle 9i To: CF-Talk [EMAIL PROTECTED] If I have am building an extremely large string (40,000 chars) in a PL/SQL stored procedure.Would it be better to keep concatenating a variable of a CLOB datatype?Or build 10 varchars and concatenate them at the end into a CLOB? I have noticed that my stored procedure runs very slow using the clob. if I use a single varchar(4000) the procedure runs very fast. If I limit the data to 4000 chars and do the same with a clob it runs very slow. The way I am doing this is concat(ClobString, 'some more text') over and over and over again. Slow Thanks, David [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Doug White - clickdoug.com
John, contact me off list. -Adam - Original Message - From: Burns, John D [EMAIL PROTECTED] Date: Thu, 23 Sep 2004 11:17:24 -0400 Subject: Doug White - clickdoug.com To: CF-Talk [EMAIL PROTECTED] I noticed there was a thread in CF-Community from a few weeks ago of people who were hosting with Doug White (www.clickdoug.com) who had experienced his outage that never came back up and are having trouble contacting him.Has anyone had any luck with this?We were hosting with him and moved all of our sites to rackspace.com but are in serious need of some files and stuff off of the server that Doug White has. Calling and emailing has resulted in nothing.We've filed a report with the San Antonio Police Department and are in the process of filing a law suit.I'd like to avoid all of that by getting in touch with him, but it appears that he's trying to skip out of the business with everyone's money and files.Anyone have any information that could help?Thanks. John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Reliable SEO company recommendations?
Rachel, The company I work for offers this, would it be ok to contact you off list? Thanks, Scott -Original Message- From: Rachel Maxim [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 8:37 AM To: CF-Talk Subject: OT: Reliable SEO company recommendations? My company is looking for someone to do search engine optimization on our sites. Can anyone recommend a reliable, reputable company for the job? We're in the DC area. Please reply to me off list. Thanks! Rachel Maxim - - - - - - - - - - - - - - - - - - - - - - - - Creative Director Case Design/Remodeling, Inc. Case Handyman Services, LLC 301.229.9380x283 [EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Doug White - clickdoug.com
I'm actually right in the middle of trying to get the 'situation' resolved myself.I lost a little data...but it's personal stuff, not business related...so there's no money loss there (or customers to deal with). But on Aug 5, I paid for 1 year of hosting.Doug and his servers disappeared about 1 month later.So I'd love to at least make an attempt to get my $ back.I had paid with paypal, and they don't even talk to you about disputing a charge after 30 days.Wouldn't have mattered, as they told me today that they don't support intangible services such as web hosting (as far as disputing a charge).Had called the bank a few days ago to see if they could do something about the charge...they did.They overturned the PayPal payment.So now the $ is back in my bank account, but my PayPal balance is negative. Which essentially means that PayPal will charge my secondary source (credit card), which puts me right back at square 1. I'm wondering if anybody who was involved has made any attempts to get their money back?Who would I go to to make an attempt?If there are others, maybe forming a group would help (strength in numbers)? Charlie On Thu, 23 Sep 2004 11:17:24 -0400, Burns, John D [EMAIL PROTECTED] wrote: I noticed there was a thread in CF-Community from a few weeks ago of people who were hosting with Doug White (www.clickdoug.com) who had experienced his outage that never came back up and are having trouble contacting him.Has anyone had any luck with this?We were hosting with him and moved all of our sites to rackspace.com but are in serious need of some files and stuff off of the server that Doug White has. Calling and emailing has resulted in nothing.We've filed a report with the San Antonio Police Department and are in the process of filing a law suit.I'd like to avoid all of that by getting in touch with him, but it appears that he's trying to skip out of the business with everyone's money and files.Anyone have any information that could help?Thanks. John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: print output
I am looking at using CFX_PDF to generate the output for my prescription application as I can use it to accurately place text element on the page, and generate new pages etc based on cfif statements. Is there any other way ?? I have considered using a Crystal Reports file, but then I need to install CR on my Coldfusion server. Just looking for ideas for something to generate print output from a web page. Thanks You could use HTMLDoc to generate a PDF via a custom tag like Michael Schieber's cf_html2pdf3 or Jordan Michael's cf_CreatePDF. Then you just have to encapsulate your output between the opening and closing pdf generator tags. For example with cf_html2pdf, CF_HTML2PDF3 myHTMLDOC=c:\cfusion\htmldoc.exe OPTIONS=--landscape --fontsize 10pt TABLE //--- Output the results of your query ---// CFOUTPUT QUERY=myQuery TRTD#myData#/TD/TR /CFOUTPUT /TABLE /CF_HTML2PDF3 and with cf_createPDF: CF_CreatePDF !-- content you want converted to PDF -- /CF_CreatePDF hth, larry -- Larry C. Lyons Web Analyst BEI Resources American Type Culture Collection email: llyons(at)atcc(dot)org tel: 703.365.2700.2678 -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Doug White - clickdoug.com
Call up and get a new CC # then Paypal can't charge you. KP -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 11:28 AM To: CF-Talk Subject: Re: Doug White - clickdoug.com I'm actually right in the middle of trying to get the 'situation' resolved myself.I lost a little data...but it's personal stuff, not business related...so there's no money loss there (or customers to deal with). But on Aug 5, I paid for 1 year of hosting.Doug and his servers disappeared about 1 month later.So I'd love to at least make an attempt to get my $ back.I had paid with paypal, and they don't even talk to you about disputing a charge after 30 days.Wouldn't have mattered, as they told me today that they don't support intangible services such as web hosting (as far as disputing a charge). Had called the bank a few days ago to see if they could do something about the charge...they did.They overturned the PayPal payment.So now the $ is back in my bank account, but my PayPal balance is negative. Which essentially means that PayPal will charge my secondary source (credit card), which puts me right back at square 1. I'm wondering if anybody who was involved has made any attempts to get their money back?Who would I go to to make an attempt?If there are others, maybe forming a group would help (strength in numbers)? Charlie On Thu, 23 Sep 2004 11:17:24 -0400, Burns, John D [EMAIL PROTECTED] wrote: I noticed there was a thread in CF-Community from a few weeks ago of people who were hosting with Doug White (www.clickdoug.com) who had experienced his outage that never came back up and are having trouble contacting him.Has anyone had any luck with this?We were hosting with him and moved all of our sites to rackspace.com but are in serious need of some files and stuff off of the server that Doug White has. Calling and emailing has resulted in nothing.We've filed a report with the San Antonio Police Department and are in the process of filing a law suit.I'd like to avoid all of that by getting in touch with him, but it appears that he's trying to skip out of the business with everyone's money and files.Anyone have any information that could help? Thanks. John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Question about CFHTTP running on CF4.5
IIRC CFHTTP was changedin 4.5.1 to fix a number of issues that cropped up in 4.5.Then it got changed again in the 2 SP's (or maybe just SP2?)to fix the fixes.Or something like that.I ran 4.5.1sp2 as recently as January of this year and cfhttp worked great. If you aren't running on SP2, I still have the update file.Since you need your valid CF pwd to plug it in there shouldn't be any licensing issues with me passing it to you.Contact me off-list if you'd like it. Cheers, -- --Matt Robertson-- MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: OT: Oracle 9i
I have not, will this increase the performance? I read that clobs could be used the same as varchars so I didn't think I would have to. Thanks, David -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 11:23 AM To: CF-Talk Subject: Re: OT: Oracle 9i Have you tried using the DBMS_LOB.Append function? -Adam - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Thu, 23 Sep 2004 11:16:02 -0400 Subject: OT: Oracle 9i To: CF-Talk [EMAIL PROTECTED] If I have am building an extremely large string (40,000 chars) in a PL/SQL stored procedure.Would it be better to keep concatenating a variable of a CLOB datatype?Or build 10 varchars and concatenate them at the end into a CLOB? I have noticed that my stored procedure runs very slow using the clob. if I use a single varchar(4000) the procedure runs very fast. If I limit the data to 4000 chars and do the same with a clob it runs very slow. The way I am doing this is concat(ClobString, 'some more text') over and over and over again. Slow Thanks, David [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Doug White - clickdoug.com
On Thursday 23 Sep 2004 16:17 pm, Burns, John D wrote: with him and moved all of our sites to rackspace.com but are in serious need of some files and stuff off of the server that Doug White has. Repeat after me: Back up, back up, back up. Not that that helps :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT: Reliable SEO company recommendations?
I doubt you will find a company that will do a better job than yourself. -Yours - Original Message - From: Rachel Maxim [EMAIL PROTECTED] Date: Thu, 23 Sep 2004 09:36:59 -0400 Subject: OT: Reliable SEO company recommendations? To: CF-Talk [EMAIL PROTECTED] My company is looking for someone to do search engine optimization on our sites. Can anyone recommend a reliable, reputable company for the job? We're in the DC area. Please reply to me off list. Thanks! Rachel Maxim - - - - - - - - - - - - - - - - - - - - - - - - Creative Director Case Design/Remodeling, Inc. Case Handyman Services, LLC 301.229.9380x283 [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT: Oracle 9i
I'm not sure what the performance measurments are vs. concat. I've never had to build a LOB in that way. Are you trying to combine multiple columns or somthing? -Adam - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Thu, 23 Sep 2004 11:34:32 -0400 Subject: RE: OT: Oracle 9i To: CF-Talk [EMAIL PROTECTED] I have not, will this increase the performance? I read that clobs could be used the same as varchars so I didn't think I would have to. Thanks, David -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 11:23 AM To: CF-Talk Subject: Re: OT: Oracle 9i Have you tried using the DBMS_LOB.Append function? -Adam - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Thu, 23 Sep 2004 11:16:02 -0400 Subject: OT: Oracle 9i To: CF-Talk [EMAIL PROTECTED] If I have am building an extremely large string (40,000 chars) in a PL/SQL stored procedure.Would it be better to keep concatenating a variable of a CLOB datatype?Or build 10 varchars and concatenate them at the end into a CLOB? I have noticed that my stored procedure runs very slow using the clob. if I use a single varchar(4000) the procedure runs very fast. If I limit the data to 4000 chars and do the same with a clob it runs very slow. The way I am doing this is concat(ClobString, 'some more text') over and over and over again. Slow Thanks, David [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Doug White - clickdoug.com
On Thu, 23 Sep 2004 11:31:08 -0400, Kristopher Pilles [EMAIL PROTECTED] wrote: Call up and get a new CC # then Paypal can't charge you. KP Well, PayPal really shouldn't get screwed in this...they weren't at fault anywhere. Plus, I just recently made a purchase on ebay, and told the seller I'd be paying Friday (tomorrow) via PayPal. -- Charlie Griefer Marta was watching the football game with me when she said, You know, most of these sports are based on the idea of one group protecting its territory from invasion by another group. Yeah, I said, trying not to laugh. Girls are funny. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Backing Up off of server (WAS RE: Doug White - clickdoug.com)
OK,I back-up, but to my current service provider's stuff (Please, CFDynamics, don't pull a Dougie!). Question:How could I perform a backup to my computer.MS SQL.I am looking for data, tables, indices and relationships. Andy -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 10:37 AM To: CF-Talk Subject: Re: Doug White - clickdoug.com On Thursday 23 Sep 2004 16:17 pm, Burns, John D wrote: with him and moved all of our sites to rackspace.com but are in serious need of some files and stuff off of the server that Doug White has. Repeat after me: Back up, back up, back up. Not that that helps :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Doug White - clickdoug.com
Charlie Griefer wrote: Well, PayPal really shouldn't get screwed in this...they weren't at fault anywhere. Other payment services will get involved in situations like this, but Paypal won't.They act like a bank / credit card company but don't follow the regulations associated with those industries. -- *Damien McKenna* - Web Developer - [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 Nothing endures but change. - Heraclitus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Distribute cf as java bytecode atop a J2EE server: What do I need?
On Thursday 23 Sep 2004 16:03 pm, Peterson, Andrew S. wrote: this. However, I have no knowledge regarding the building of a J2EE server. What do I need? This J2EE server will be used internally, and Apache have built one for you (tomcat), as have Macromedia (jrun) and many others. All are fairly easy to administer and run just about anywhere. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Reliable SEO company recommendations?
www.stepforth.com Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Backing Up off of server (WAS RE: Doug White - clickdoug.com)
Well if you use SQL Server you must have Enterprise Managerif so then whenever you feel like it your should be able to use DTS to suck a copy to your local machine (of course now that there seems to be no server to suck from...well...life just sucks) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Doug White - clickdoug.com
Well it seems that the vast majority of User Group sites were being hosted by Doug so this topic has been brought up a billion times on that list. Here are some of the relevant post: The following was posted by Tom May on Aug 19: Doug reports his provider (SBC) has incurred a major fiber cable cut. Consequently, his server is completely dead.The latest info says it should be off two weeks - SBC hasn't interrupted his service for more than 15 minutes in 5 years and many SBC customers are involved. Anyhow, he apologies for the inconvenience this is causing and if you need to route information to him, please send it to me and I'll forward it on! Tom I talked to Doug yesterday, and it's a backbone issue Doug's is experiencing issues and he is aware of them and trying to fix asap, but currently does not have a timetable when the issue will be resolved. I just called the phone number I have for Doug, and after three weeks of busy signals, it now says:The number you have entered is incorrect. I have nothing to do with Doug or his crappy servers or service. I'm just passing on information. My opinion as a spectator reading all these posts in the past month, Doug stole your money. -Adam - Original Message - From: Thomas Chiverton [EMAIL PROTECTED] Date: Thu, 23 Sep 2004 16:37:17 +0100 Subject: Re: Doug White - clickdoug.com To: CF-Talk [EMAIL PROTECTED] On Thursday 23 Sep 2004 16:17 pm, Burns, John D wrote: with him and moved all of our sites to rackspace.com but are in serious need of some files and stuff off of the server that Doug White has. Repeat after me: Back up, back up, back up. Not that that helps :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Question about CFHTTP running on CF4.5
Doug, That was the exact problem, Thanks Mario -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 11:26 AM To: CF-Talk Subject: RE: Question about CFHTTP running on CF4.5 My problem is that my one server is running 4.5.1 and the other is running 4.5 and I trying to do a CFHTTP call to an internal server to get a list of stock quotes. The problem is that it works on 4.5.0 but not on 4.5.1.On the 4.5.1 box I get a connect refused error but on the 4.5.0 I do not. Are you able to connect to that URL from the console of the problematic server using a browser? Very often, problems with CFHTTP are really problems with the network configuration. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Converting query to comma separated list
My first question, though I suspect this might not be the best approach . Is it possible to turn a query (cfdirectory in this case) into a comma separated list? Mark, There's a UDF on CFLib called QueryToCsv that does exactly that, turn query results into a CSV list: http://www.cflib.org/udf.cfm?ID=556. very simple to use cfset whatever = QueryToCsv(YourQueryNameGoesHere) hth, larry -- Larry C. Lyons Web Analyst BEI Resources American Type Culture Collection email: llyons(at)atcc(dot)org tel: 703.365.2700.2678 -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: JAVASCRIPT and textarea
here is the function.
It like that fuction is working, but only problem I am having that I need to change the value in the textarea as well so user can see that what his output will be.
And those textarea(s) are dynamic.
so I am passing two values to the function. rcv=what ever they typed and
nm = the name of the textarea
now when I do dest = removebr that should be
document.theForm.story1.value = removebr
and its not working. is there anyother way to do the same
function Remove(rcv, nm){
dest = document.theForm. + nm + .value;
removebr = rcv.replace(/[\n\r]/g, );
dest = removebr;
alert(this is dest\n + dest);
}
Micheal will you please give me an example how to replace i.e. you
mean to do the server side validation???
I need the client side validation.
Ryan, does DOM works in mac as well??
thanks
I agree.Simply replace after the submit.
Also, you can strip complicated things out using DOM.
We use the DOM to strip out HTML tags such as: Removing FONT tag.
if(child.tagName.toUpperCase() == 'FONT'){
child.removeNode();
}
Good luck.
Ryan Duckworth
Macromedia ColdFusion Certified Professional
Uhlig Communications
10983 Granada Lane
Overland Park, KS 66211
(913) 754-4272
_
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 22, 2004 3:58 PM
To: CF-Talk
Subject: RE: _javascript_ and textarea
You handle the keyCode event but not the change (onChange) event
which
you need to check also to ensure that a copy past fires off the
routine
needed to validate the entry into the box.
Michael T. Tangorre
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: Reliable SEO company recommendations?
Do either companies (stepforth or accurateimaging) offer a gaurantee that your ranking will increase. IE if your ranking dont improve, you dont get billed? -Ada, - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] Date: Thu, 23 Sep 2004 08:46:13 -0700 Subject: Re: Reliable SEO company recommendations? To: CF-Talk [EMAIL PROTECTED] www.stepforth.com Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: JAVASCRIPT and textarea
Yes.This is possible.
1.Create 2 hidden DIVs on the page.
2.Use code similar to this to copy to temp area, fix, then copy back
to original area.
fullCleanWorkSpace.innerHTML ='div' + aeObject.DOM.body.innerHTML +
'/div';
removeAllTags(fullCleanWorkSpace,fullCleanWorkSpace2);
aeObject.DOM.body.innerHTML = fullCleanWorkSpace2.innerHTML;
Ryan Duckworth
Macromedia ColdFusion Certified Professional
Uhlig Communications
10983 Granada Lane
Overland Park, KS 66211
(913) 754-4272
_
From: Asim Manzur [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 23, 2004 11:08 AM
To: CF-Talk
Subject: Re: _javascript_ and textarea
here is the function.
It like that fuction is working, but only problem I am having that I
need to change the value in the textarea as well so user can see that
what his output will be.
And those textarea(s) are dynamic.
so I am passing two values to the function. rcv=what ever they typed and
nm = the name of the textarea
now when I do dest = removebr that should be
document.theForm.story1.value = removebr
and its not working. is there anyother way to do the same
function Remove(rcv, nm){
dest = document.theForm. + nm + .value;
removebr = rcv.replace(/[\n\r]/g, );
dest = removebr;
alert(this is dest\n + dest);
}
Micheal will you please give me an example how to replace i.e. you
mean to do the server side validation???
I need the client side validation.
Ryan, does DOM works in mac as well??
thanks
I agree.Simply replace after the submit.
Also, you can strip complicated things out using DOM.
We use the DOM to strip out HTML tags such as: Removing FONT tag.
if(child.tagName.toUpperCase() == 'FONT'){
child.removeNode();
}
Good luck.
Ryan Duckworth
Macromedia ColdFusion Certified Professional
Uhlig Communications
10983 Granada Lane
Overland Park, KS 66211
(913) 754-4272
_
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 22, 2004 3:58 PM
To: CF-Talk
Subject: RE: _javascript_ and textarea
You handle the keyCode event but not the change (onChange) event
which
you need to check also to ensure that a copy past fires off the
routine
needed to validate the entry into the box.
Michael T. Tangorre
_
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: Reliable SEO company recommendations?
To be honest I'm sure if StepForth (or any other SEO company for that matter) offers such a gaurantee.I think this may be due to the fact that they generally advise you on what changes to make on your site, but don't have control to force their implementation.So if they don't have full control then they can't offer a gaurantee. This is not to say that StepForth is not reliablehave a look at their client listyou may have heard of ACD Systems ;-)Another major client which I'm not sure I can mention yet owns...lets say...a lot of media related companiesand when they do anything new...everybody talks about it. Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com - Original Message - From: Adrocknaphobia To: CF-Talk Sent: Thursday, September 23, 2004 9:09 AM Subject: Re: Reliable SEO company recommendations? Do either companies (stepforth or accurateimaging) offer a gaurantee that your ranking will increase. IE if your ranking dont improve, you dont get billed? -Ada, - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] Date: Thu, 23 Sep 2004 08:46:13 -0700 Subject: Re: Reliable SEO company recommendations? To: CF-Talk [EMAIL PROTECTED] www.stepforth.com Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SQL: Passing vars to a LIKE statement
Eric,
Can you try just doing this first?
AND demographicvaluedesc LIKE @month+'%'
And do you still get the error?
Then also try this, don't know if it will solve the problem, but it looks like SQL is actually trying to do an arithmetic add on the values, rather than concatenating the strings in the searchstring.
Try using a different variable for year and declare it as a varchar.
@year_temp varchar(4).Put spaces before and after the '+' sign, don't know if it'll help.
and then in the searchstring do this again.
AND demographicvaluedesc LIKE @month + '%' + @year_temp + '%'
Hope this works,
Ali
Pass the percent signs as part of your var... Don't know why it works
but it does. There is a way to do it in a stored proc but I don't
remember off the top of my head.
_
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 22, 2004 4:15 PM
To: CF-Talk
Subject: RE: SQL: Passing vars to a LIKE statement
thanks but it is not helping, here is my stored proc and the error msg I
receive
CREATE PROCEDURE GetMonthlyJoins AS
DECLARE
@MONTH varchar(3),
@MONTHNBRint,
@YEARint,
@did datetime,
@countint,
@likevar varchar(25)
IF object_id('#MonthlyJoins') is not null
BEGIN
TRUNCATE TABLE #MonthyJoins;
END
ELSE
BEGIN
CREATE TABLE #MonthyJoins
(
rptmonth varchar(3),
rptmonthnbr int,
rptyear int,
total int
);
END
DECLARE didCursor cursor local static
FOR
SELECT DISTINCT rptdate
FROM ALL_DAILY_TOTALS
WHERE convert(varchar(10),rptdate,101) like '%/01/%'
ORDER BY rptdate
open didCursor
fetch didCursor into @did
WHILE @@fetch_status=0
BEGIN
SET @year = (SELECT DATEPART(year, @did))
SET @month =(SELECT UPPER(LEFT(DATENAME(month, @did),3)))
SET @monthnbr =(SELECTMONTH(@did))
SELECT @count=COUNT(*)
FROM avectraprod.dbo.persondemographic(nolock)
WHERE demographicgroupid =4
AND demographicitemid =7
AND demographicvaluedesc LIKE @month+'%'[EMAIL PROTECTED]'%'
INSERT INTO #MonthyJoins
( rptmonth,rptmonthnbr,rptyear, total )
VALUES
(@month,@monthnbr,@year,@count)
fetch next FROM didCursor into @did
END
close didCursor
deallocate didCursor
SELECT * FROM #MonthyJoins
GO
Error Message:
Server: Msg 245, Level 16, State 1, Procedure GetMonthlyJoins, Line 51
Syntax error converting the varchar value 'FEB%' to a column of data
type int.
-Original Message-
From: Ali Awan [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 22, 2004 1:21 PM
To: CF-Talk
Subject: Re: SQL: Passing vars to a LIKE statement
I need to pass some varibles into a LIKE clause in a SELECT statement.
I am having trouble with the format.
AND valuedesc LIKE '[EMAIL PROTECTED]@year%' is what I was doing and know this
is wrong cause it see that garb as a literal string. How do I pass
this so the vars
show?
Eric,
I recently ran into this same problem recently.The correct way to do
this is:
AND valuedesc LIKE '%'[EMAIL PROTECTED]'%'[EMAIL PROTECTED]'%'
You need to put the + signs in and remember to put the single quotes
properly.Whenever you use variables, you have to build the statement
as a string.
Hope this helps,
Ali
_
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Reply-To Header observance
We have a fairly large web application used by multiple corporations/organizations.The application is a web-based mentoring application (where mentees find mentors and communicate with each other). The application is designed to send out e-mails (using CF-MAIL) to one group (say the mentor) so that they can hit reply to send a response back to the other group (mentees).However, the mail server is set up to prevent relaying, so the messages need to have our system in the from address (so, the from would be something like:John Smith [EMAIL PROTECTED], where John Smith is the mentee). Because we want tthe mentor to be able to just hit Reply to send a response back to the mentee, we're including the standard reply-to header with the mentee's actual e-mail address. We're running into some instances where the response is being sent back the [EMAIL PROTECTED] address instead of the reply-to address.We're not able to reproduce this, and we're not really able to contact the individual users to investigate it with them. So, my questions are basically this: 1) Are there any common e-mail clients which don't honor the reply-to header? 2) Are there any settings in common e-mail clients which can prevent the reply-to header from being honored? 3)Are there different forms of the reply-to header that we can also try? Thanks! Scott -- - Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Doug White - clickdoug.com
If you went this route, Paypal can then place a negative mark on your credit report.They can also send it to collections which will further negatively impact your credit.So if you're looking to buy a home or car or get life insurance (worse credit = worse rates) or approval for any other line of credit I highly suggest that you not go this route. --Jeff On 9/23/2004 11:31 AM, Kristopher Pilles wrote: Call up and get a new CC # then Paypal can't charge you. KP -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 11:28 AM To: CF-Talk Subject: Re: Doug White - clickdoug.com I'm actually right in the middle of trying to get the 'situation' resolved myself.I lost a little data...but it's personal stuff, not business related...so there's no money loss there (or customers to deal with). But on Aug 5, I paid for 1 year of hosting.Doug and his servers disappeared about 1 month later.So I'd love to at least make an attempt to get my $ back.I had paid with paypal, and they don't even talk to you about disputing a charge after 30 days.Wouldn't have mattered, as they told me today that they don't support intangible services such as web hosting (as far as disputing a charge). Had called the bank a few days ago to see if they could do something about the charge...they did.They overturned the PayPal payment.So now the $ is back in my bank account, but my PayPal balance is negative. Which essentially means that PayPal will charge my secondary source (credit card), which puts me right back at square 1. I'm wondering if anybody who was involved has made any attempts to get their money back?Who would I go to to make an attempt?If there are others, maybe forming a group would help (strength in numbers)? Charlie On Thu, 23 Sep 2004 11:17:24 -0400, Burns, John D [EMAIL PROTECTED] wrote: I noticed there was a thread in CF-Community from a few weeks ago of people who were hosting with Doug White (www.clickdoug.com) who had experienced his outage that never came back up and are having trouble contacting him.Has anyone had any luck with this?We were hosting with him and moved all of our sites to rackspace.com but are in serious need of some files and stuff off of the server that Doug White has. Calling and emailing has resulted in nothing.We've filed a report with the San Antonio Police Department and are in the process of filing a law suit.I'd like to avoid all of that by getting in touch with him, but it appears that he's trying to skip out of the business with everyone's money and files.Anyone have any information that could help? Thanks. John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: SQL: Passing vars to a LIKE statement
Ok that worked Horray! and thank you so much for stating the obvious that I was too blind to see.
Ok with that I have another problem kind of the same thing, but I ma now building a date sting to filter but I keep getting an error: Syntax error converting datetime from character string.
Here is the code:
CREATE PROCEDURE GetFirstRenewalActual AS
DECLARE
@rptMONTHint,
@rptmonth_vvarchar(2),
@AdvMONTHvarchar(2),
@peopleint,
@companyint,
@rptYEARvarchar(4),
@did int,
@rentablevarchar(10),
@totalint,
@chkdatedatetime
IF object_id('#FirstRunTotals') is not null
BEGIN
DROP TABLE #FirstRunTotals;
END
ELSE
BEGIN
CREATE TABLE #FirstRunTotals
(
rptrenewal varchar(7) NULL,
people int,
company int,
total int
);
END
DECLARE didCursor cursor local static
FOR
SELECT rptid
FROM RenewalMonths
WHERE completed = 1
ORDER BY rptyear,rptmonth
open didCursor
fetch didCursor into @did
WHILE @@fetch_status=0
BEGIN
SELECT@rptyear=rptyear,@rptmonth=rptmonth,@rptmonth_v = rptmonth
FROM RenewalMonths
WHERE rptid = @did
SELECT @AdvMonth = @rptmonth +1
SELECT @rentable =@[EMAIL PROTECTED]'_ren'
SELECT @chkdate =CAST(@AdvMonth+'/1/'[EMAIL PROTECTED] as datetime)
--- DIES RIGHT HERE !!!
SELECT
(
SELECTcount(*)
FROM persondem(nolock)
WHERE expdate @chkdate
ANDCAST(eaanum as integer) IN (
SELECT CAST(EAANUM as integer)
[EMAIL PROTECTED])
)+(
SELECTcount(*)
FROM companydem(nolock)
WHERE expdate @chkdate
ANDCAST(eaanum as integer) IN (
SELECT CAST(EAANUM as integer)
[EMAIL PROTECTED])
)
INSERT INTO #FirstRunTotals
(rptrenewal,people,company,total)
VALUES
(@rptyear+'-'[EMAIL PROTECTED],@people,@company,@total)
fetch next FROM didCursor into @did
END
close didCursor
deallocate didCursor
SELECT * FROM #FirstDayTotals
GO
-Original Message-
From: Ali Awan [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 23, 2004 11:21 AM
To: CF-Talk
Subject: Re: SQL: Passing vars to a LIKE statement
Eric,
Can you try just doing this first?
AND demographicvaluedesc LIKE @month+'%'
And do you still get the error?
Then also try this, don't know if it will solve the problem, but it looks like SQL is actually trying to do an arithmetic add on the values, rather than concatenating the strings in the searchstring.
Try using a different variable for year and declare it as a varchar.
@year_temp varchar(4).Put spaces before and after the '+' sign, don't know if it'll help.
and then in the searchstring do this again.
AND demographicvaluedesc LIKE @month + '%' + @year_temp + '%'
Hope this works,
Ali
Pass the percent signs as part of your var... Don't know why it works
but it does. There is a way to do it in a stored proc but I don't
remember off the top of my head.
_
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 22, 2004 4:15 PM
To: CF-Talk
Subject: RE: SQL: Passing vars to a LIKE statement
thanks but it is not helping, here is my stored proc and the error msg I
receive
CREATE PROCEDURE GetMonthlyJoins AS
DECLARE
@MONTH varchar(3),
@MONTHNBRint,
@YEARint,
@did datetime,
@countint,
@likevar varchar(25)
IF object_id('#MonthlyJoins') is not null
BEGIN
TRUNCATE TABLE #MonthyJoins;
END
ELSE
BEGIN
CREATE TABLE #MonthyJoins
(
rptmonth varchar(3),
rptmonthnbr int,
rptyear int,
total int
);
END
DECLARE didCursor cursor local static
FOR
SELECT DISTINCT rptdate
FROM ALL_DAILY_TOTALS
WHERE convert(varchar(10),rptdate,101) like '%/01/%'
ORDER BY rptdate
open didCursor
fetch didCursor into @did
WHILE @@fetch_status=0
BEGIN
SET @year = (SELECT DATEPART(year, @did))
SET @month =(SELECT UPPER(LEFT(DATENAME(month, @did),3)))
SET @monthnbr =(SELECTMONTH(@did))
SELECT @count=COUNT(*)
FROM avectraprod.dbo.persondemographic(nolock)
WHERE demographicgroupid =4
AND demographicitemid =7
AND demographicvaluedesc LIKE @month+'%'[EMAIL PROTECTED]'%'
INSERT INTO #MonthyJoins
( rptmonth,rptmonthnbr,rptyear, total )
VALUES
(@month,@monthnbr,@year,@count)
fetch next FROM didCursor into @did
END
close didCursor
deallocate didCursor
SELECT * FROM #MonthyJoins
GO
Error Message:
Server: Msg 245, Level 16, State 1, Procedure GetMonthlyJoins, Line 51
Syntax error converting the varchar value 'FEB%' to a column of data
type int.
-Original Message-
From: Ali Awan [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 22, 2004 1:21 PM
To: CF-Talk
Subject: Re: SQL: Passing vars to a LIKE statement
I need to pass some varibles into a LIKE clause in a SELECT statement.
I am having trouble with the format.
AND valuedesc LIKE '[EMAIL PROTECTED]@year%' is what I was doing and know this
is wrong cause it see that garb as a literal string. How do I pass
this so the vars
show?
Eric,
I recently ran into this same problem recently.The correct way to do
this is:
AND valuedesc LIKE '%'[EMAIL PROTECTED]'%'[EMAIL PROTECTED]'%'
You need to put the + signs in and remember to put the single quotes
properly.Whenever you use variables, you have
RE: JAVASCRIPT and textarea
Yes.This is possible.
1.Create 2 hidden DIVs on the page.
2.Use code similar to this to copy to temp area, fix, then copy back
to original area.
fullCleanWorkSpace.innerHTML ='div' + aeObject.DOM.body.innerHTML +
'/div';
removeAllTags(fullCleanWorkSpace,fullCleanWorkSpace2);
aeObject.DOM.body.innerHTML = fullCleanWorkSpace2.innerHTML;
More DOM information can be found here:
http://msdn.microsoft.com/library/default.asp?url="">
/reference/methods/removenode.asp
Good luck!
Ryan Duckworth
Macromedia ColdFusion Certified Professional
Uhlig Communications
10983 Granada Lane
Overland Park, KS 66211
(913) 754-4272
_
From: Asim Manzur [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 23, 2004 11:08 AM
To: CF-Talk
Subject: Re: _javascript_ and textarea
here is the function.
It like that fuction is working, but only problem I am having that I
need to change the value in the textarea as well so user can see that
what his output will be.
And those textarea(s) are dynamic.
so I am passing two values to the function. rcv=what ever they typed and
nm = the name of the textarea
now when I do dest = removebr that should be
document.theForm.story1.value = removebr
and its not working. is there anyother way to do the same
function Remove(rcv, nm){
dest = document.theForm. + nm + .value;
removebr = rcv.replace(/[\n\r]/g, );
dest = removebr;
alert(this is dest\n + dest);
}
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: Backing Up off of server (WAS RE: Doug White - clickdoug.com)
Tried that, copied data, but not indices, stored proc's, relationships, etc...How do I do that? Andy -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 10:49 AM To: CF-Talk Subject: Re: Backing Up off of server (WAS RE: Doug White - clickdoug.com) Well if you use SQL Server you must have Enterprise Managerif so then whenever you feel like it your should be able to use DTS to suck a copy to your local machine (of course now that there seems to be no server to suck from...well...life just sucks) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SOT - Crystal Reports Training
We teach one, though it's not listed on ColdFusionTraining.com.We had used CR since V4 days (it's now at V10), and we needed to support some pathologists that wanted to learn the product, so it was relatively straightforward for us to develop a curriculum and teach a very nice two-day course. What level of Crystal Reports functionality are you trying to learn? Respectfully, Adam Phillip Churvis Member of Team Macromedia Advanced Intensive Training: * C# ASP.NET for ColdFusion Developers * ColdFusion MX Master Class * Advanced Development with CFMX and SQL Server 2000 http://www.ColdFusionTraining.com Download CommerceBlocks V2.1 and LoRCAT from http://www.ProductivityEnhancement.com The ColdFusion MX Bible is in bookstores now! - Original Message - From: Todd [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 23, 2004 11:09 AM Subject: SOT - Crystal Reports Training I am looking for Crystal Reports training.Has anyone ever taken any classes like this?What companies would you reccomend?Cost isn't really an issue.I would like something in either N.C. or S.C, but anywhere will do.Time is the most important factor here.The sooner I can find a class, the better. Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Backing Up off of server (WAS RE: Doug White - clickdoug.com)
Ahhh...you didn't pick the right optiondon't just pick the copy all tables option (or whatever it's called...it's the default selection)...there's another option on the same screen that says something along the lines of Copy objects and data After picking that you can pick which objects to pick (think the default is everything) HTH Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com - Original Message - From: Andy Ousterhout To: CF-Talk Sent: Thursday, September 23, 2004 9:56 AM Subject: RE: Backing Up off of server (WAS RE: Doug White - clickdoug.com) Tried that, copied data, but not indices, stored proc's, relationships, etc...How do I do that? Andy -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 10:49 AM To: CF-Talk Subject: Re: Backing Up off of server (WAS RE: Doug White - clickdoug.com) Well if you use SQL Server you must have Enterprise Managerif so then whenever you feel like it your should be able to use DTS to suck a copy to your local machine (of course now that there seems to be no server to suck from...well...life just sucks) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Doug White - clickdoug.com
All you can do is take him to small claims court.You will win, but then it's on you to find him and collect. Unless this service was phenomenally expensive and you can find a few thousand other users, a class action suit is not going to happen. Caveat: I have been through all manner of legal BS trying to collect or recover money.Sometimes you win, sometimes you don't.I am not an attorney. I don't even play one on TV. Cary Gordon The Cherry Hill Company [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFPOP Issues
If you're running on Windows, you could try CFX_POP3. If you want to try before you buy, then contact me offlist! Paul [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: print output
Make sure you have access to using cfexecute for their product to work. How about this http://gilgamesh-solutions.com/products.cfm#p1 - Original Message - From: Brant Winter [EMAIL PROTECTED] Date: Wed, 22 Sep 2004 15:00:32 +1000 Subject: RE: print output To: CF-Talk [EMAIL PROTECTED] Timeframe : 6 months ago - like everything else round here. _ From: dave [mailto:[EMAIL PROTECTED] Sent: Wednesday, 22 September 2004 2:41 PM To: CF-Talk Subject: Re: print output whats the time frame? i hear that the new blackstone has some great new printing tags The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. Please carry out such virus and other checks, as you consider appropriate. To the fullest extent allowed by law, no responsibility is accepted by Haematology Oncology Clinics of Australasia for any virus damage caused by this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SQL: Passing vars to a LIKE statement
Eric,
Glad that worked :)
I have a suggestion as to your next problem.
First create a new variable
Then set the variable to the string you were converting.
Then do a convert on that variable.
@string_to_convert varchar(10)
SELECT @string_to_convert = @AdvMonth + '/01/'+ @rptyear
SELECT @chkdate = CONVERT(datetime, @string_to_convert)
Ali
Ok that worked Horray! and thank you so much for stating the obvious
that I was too blind to see.
Ok with that I have another problem kind of the same thing, but I ma
now building a date sting to filter but I keep getting an error:
Syntax error converting datetime from character string.
Here is the code:
CREATE PROCEDURE GetFirstRenewalActual AS
DECLARE
@rptMONTHint,
@rptmonth_vvarchar(2),
@AdvMONTHvarchar(2),
@peopleint,
@companyint,
@rptYEARvarchar(4),
@did int,
@rentablevarchar(10),
@totalint,
@chkdatedatetime
IF object_id('#FirstRunTotals') is not null
BEGIN
DROP TABLE #FirstRunTotals;
END
ELSE
BEGIN
CREATE TABLE #FirstRunTotals
(
rptrenewal varchar(7) NULL,
people int,
company int,
total int
);
END
DECLARE didCursor cursor local static
FOR
SELECT rptid
FROM RenewalMonths
WHERE completed = 1
ORDER BY rptyear,rptmonth
open didCursor
fetch didCursor into @did
WHILE @@fetch_status=0
BEGIN
SELECT@rptyear=rptyear,@rptmonth=rptmonth,@rptmonth_v = rptmonth
FROM RenewalMonths
WHERE rptid = @did
SELECT @AdvMonth = @rptmonth +1
SELECT @rentable =@[EMAIL PROTECTED]'_ren'
SELECT @chkdate =CAST(@AdvMonth+'/1/'[EMAIL PROTECTED] as datetime)
--- DIES RIGHT HERE !!!
SELECT
(
SELECTcount(*)
FROM persondem(nolock)
WHERE expdate @chkdate
ANDCAST(eaanum as integer) IN (
SELECT CAST(EAANUM as integer)
[EMAIL PROTECTED])
)+(
SELECTcount(*)
FROM companydem(nolock)
WHERE expdate @chkdate
ANDCAST(eaanum as integer) IN (
SELECT CAST(EAANUM as integer)
[EMAIL PROTECTED])
)
INSERT INTO #FirstRunTotals
(rptrenewal,people,company,total)
VALUES
(@rptyear+'-'[EMAIL PROTECTED],@people,@company,@total)
fetch next FROM didCursor into @did
END
close didCursor
deallocate didCursor
SELECT * FROM #FirstDayTotals
GO
-Original Message-
From: Ali Awan [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 23, 2004 11:21 AM
To: CF-Talk
Subject: Re: SQL: Passing vars to a LIKE statement
Eric,
Can you try just doing this first?
AND demographicvaluedesc LIKE @month+'%'
And do you still get the error?
Then also try this, don't know if it will solve the problem, but it
looks like SQL is actually trying to do an arithmetic add on the
values, rather than concatenating the strings in the searchstring.
Try using a different variable for year and declare it as a varchar.
@year_temp varchar(4).Put spaces before and after the '+' sign,
don't know if it'll help.
and then in the searchstring do this again.
AND demographicvaluedesc LIKE @month + '%' + @year_temp + '%'
Hope this works,
Ali
Pass the percent signs as part of your var... Don't know why it
works
but it does. There is a way to do it in a stored proc but I don't
remember off the top of my head.
_
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 22, 2004 4:15 PM
To: CF-Talk
Subject: RE: SQL: Passing vars to a LIKE statement
thanks but it is not helping, here is my stored proc and the error
msg I
receive
CREATE PROCEDURE GetMonthlyJoins AS
DECLARE
@MONTH varchar(3),
@MONTHNBRint,
@YEARint,
@did datetime,
@countint,
@likevar varchar(25)
IF object_id('#MonthlyJoins') is not null
BEGIN
TRUNCATE TABLE #MonthyJoins;
END
ELSE
BEGIN
CREATE TABLE #MonthyJoins
(
rptmonth varchar(3),
rptmonthnbr int,
rptyear int,
total int
);
END
DECLARE didCursor cursor local static
FOR
SELECT DISTINCT rptdate
FROM ALL_DAILY_TOTALS
WHERE convert(varchar(10),rptdate,101) like '%/01/%'
ORDER BY rptdate
open didCursor
fetch didCursor into @did
WHILE @@fetch_status=0
BEGIN
SET @year = (SELECT DATEPART(year, @did))
SET @month =(SELECT UPPER(LEFT(DATENAME(month, @did),3)))
SET @monthnbr =(SELECTMONTH(@did))
SELECT @count=COUNT(*)
FROM avectraprod.dbo.persondemographic(nolock)
WHERE demographicgroupid =4
AND demographicitemid =7
AND demographicvaluedesc LIKE @month+'%'[EMAIL PROTECTED]'%'
INSERT INTO #MonthyJoins
( rptmonth,rptmonthnbr,rptyear, total )
VALUES
(@month,@monthnbr,@year,@count)
fetch next FROM didCursor into @did
END
close didCursor
deallocate didCursor
SELECT * FROM #MonthyJoins
GO
Error Message:
Server: Msg 245, Level 16, State 1, Procedure GetMonthlyJoins, Line
51
Syntax error converting the varchar value 'FEB%' to a column of data
type int.
Re: Converting query to comma separated list
Thanks Scott,
This pops up every 24-36 hours until I run a script to empty some
logs, as CF-Dynamics still hasn't completed a help desk ticket I left
with them a while back...
I'll be moving to a completely new service over the next few weeks,
and this should all go away.
Cheers,
Joe
- Original Message -
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Thu, 23 Sep 2004 10:18:25 -0400
Subject: RE: Converting query to comma separated list
To: CF-Talk [EMAIL PROTECTED]
Joe,
Got the following error trying to access your site
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Could not allocate space for
object 'clearsoftware_visitors' in database 'clearsoftware_net_01' because
the 'PRIMARY' filegroup is full.
The error occurred in
D:\Inetpub\wwwroot\clearsoftware.net\wwwroot\client\tracker.cfc: line 21
Called from
D:\Inetpub\wwwroot\clearsoftware.net\wwwroot\client\Application.cfm: line 26
Called from D:\Inetpub\wwwroot\clearsoftware.net\wwwroot\client\tracker.cfc:
line 21
Called from
D:\Inetpub\wwwroot\clearsoftware.net\wwwroot\client\Application.cfm: line 26
19 : cfprocparam cfsqltype=cf_sql_varchar
value=#arguments.firstName# /
20 : cfprocparam cfsqltype=cf_sql_varchar
value=#arguments.lastName# /
21 : cfprocresult name=result maxrows=1 /
22 :/cfstoredproc
23 :
_
SQL
{call clearsoftware_createVisitor( (param 1) , (param 2) , (param 3) ,
(param 4) , (param 5) , (param 6) )}
DATASOURCE
clearsoftware_glass
VENDORERRORCODE
1105
SQLSTATE
HY000
Please try the following:
* Check the ColdFusion http://www.macromedia.com/go/proddoc_getdoc
documentation to verify that you are using the correct syntax.
* Search the Knowledge http://www.macromedia.com/support/coldfusion/
Base to find a solution to your problem.
Browser
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)
Remote Address
65.242.127.130
Referrer
Date/Time
23-Sep-04 09:21 AM
Stack Trace (click to expand) _javascript_:;
Scott A. Stewart,
Web Application Developer
Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt Place, Suite 100
Chantilly, VA 20151
Phone: (703) 471-8400
Fax: (703) 834-5527
-Original Message-
From: Joe Rinehart [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 23, 2004 09:37 am
To: CF-Talk
Subject: Re: Converting query to comma separated list
Mark,
I posted a CFC called queryTool to my site (http://clearsoftware.net
- downloads - queryTool) and to cfcZone.org that converts queries to
delimited formats, XML, arrays, and structures.Perfectly free, seems
to work pretty well.
Cheers,
Joe
- Original Message -
From: Mark Henderson [EMAIL PROTECTED]
Date: Thu, 23 Sep 2004 22:14:06 +1200
Subject: Re: Converting query to comma separated list
To: CF-Talk [EMAIL PROTECTED]
Thank you for the swift replies Andrew and Kola,
and you're right Andrew. I'd already tried something similar, but was making
it more complicated than necessary. Here's what works
cfdirectory
name=getAllFolders
action="">
directory=#serverdir#
sort=name ASC
cfloop query = getAllFolders
cfdirectory
name=getAllFiles
action="">
directory=#serverdir##name#
sort=name ASC
cfquery dbtype=query name=getAllFiles_#name#
SELECT *
FROM getAllFiles
/cfquery
/cfloop
adieu
Mark
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: Backing Up off of server
I am getting error on NT User cfd/Kruyon.Not sure why.Don't know who this user is or why Export is looking for this name.Any suggestions would be appreciated -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 12:21 PM To: CF-Talk Subject: Re: Backing Up off of server (WAS RE: Doug White - clickdoug.com) Ahhh...you didn't pick the right optiondon't just pick the copy all tables option (or whatever it's called...it's the default selection)...there's another option on the same screen that says something along the lines of Copy objects and data After picking that you can pick which objects to pick (think the default is everything) HTH [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Converting query to comma separated list
No problem Joe,I saw that you're CFC will do something that I need, and
when the page choked
But I downloaded it from CFZone, I'll let ya know how it works out.
sas
Scott A. Stewart,
Web Application Developer
Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt Place, Suite 100
Chantilly, VA 20151
Phone: (703) 471-8400
Fax: (703) 834-5527
-Original Message-
From: Joe Rinehart [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 23, 2004 01:37 pm
To: CF-Talk
Subject: Re: Converting query to comma separated list
Thanks Scott,
This pops up every 24-36 hours until I run a script to empty some
logs, as CF-Dynamics still hasn't completed a help desk ticket I left
with them a while back...
I'll be moving to a completely new service over the next few weeks,
and this should all go away.
Cheers,
Joe
- Original Message -
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Thu, 23 Sep 2004 10:18:25 -0400
Subject: RE: Converting query to comma separated list
To: CF-Talk [EMAIL PROTECTED]
Joe,
Got the following error trying to access your site
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Could not allocate space for
object 'clearsoftware_visitors' in database 'clearsoftware_net_01' because
the 'PRIMARY' filegroup is full.
The error occurred in
D:\Inetpub\wwwroot\clearsoftware.net\wwwroot\client\tracker.cfc: line 21
Called from
D:\Inetpub\wwwroot\clearsoftware.net\wwwroot\client\Application.cfm: line 26
Called from D:\Inetpub\wwwroot\clearsoftware.net\wwwroot\client\tracker.cfc:
line 21
Called from
D:\Inetpub\wwwroot\clearsoftware.net\wwwroot\client\Application.cfm: line 26
19 : cfprocparam cfsqltype=cf_sql_varchar
value=#arguments.firstName# /
20 : cfprocparam cfsqltype=cf_sql_varchar
value=#arguments.lastName# /
21 : cfprocresult name=result maxrows=1 /
22 :/cfstoredproc
23 :
_
SQL
{call clearsoftware_createVisitor( (param 1) , (param 2) , (param 3) ,
(param 4) , (param 5) , (param 6) )}
DATASOURCE
clearsoftware_glass
VENDORERRORCODE
1105
SQLSTATE
HY000
Please try the following:
* Check the ColdFusion http://www.macromedia.com/go/proddoc_getdoc
documentation to verify that you are using the correct syntax.
* Search the Knowledge http://www.macromedia.com/support/coldfusion/
Base to find a solution to your problem.
Browser
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)
Remote Address
65.242.127.130
Referrer
Date/Time
23-Sep-04 09:21 AM
Stack Trace (click to expand) _javascript_:;
Scott A. Stewart,
Web Application Developer
Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt Place, Suite 100
Chantilly, VA 20151
Phone: (703) 471-8400
Fax: (703) 834-5527
-Original Message-
From: Joe Rinehart [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 23, 2004 09:37 am
To: CF-Talk
Subject: Re: Converting query to comma separated list
Mark,
I posted a CFC called queryTool to my site (http://clearsoftware.net
- downloads - queryTool) and to cfcZone.org that converts queries to
delimited formats, XML, arrays, and structures.Perfectly free, seems
to work pretty well.
Cheers,
Joe
- Original Message -
From: Mark Henderson [EMAIL PROTECTED]
Date: Thu, 23 Sep 2004 22:14:06 +1200
Subject: Re: Converting query to comma separated list
To: CF-Talk [EMAIL PROTECTED]
Thank you for the swift replies Andrew and Kola,
and you're right Andrew. I'd already tried something similar, but was making
it more complicated than necessary. Here's what works
cfdirectory
name=getAllFolders
action="">
directory=#serverdir#
sort=name ASC
cfloop query = getAllFolders
cfdirectory
name=getAllFiles
action="">
directory=#serverdir##name#
sort=name ASC
cfquery dbtype=query name=getAllFiles_#name#
SELECT *
FROM getAllFiles
/cfquery
/cfloop
adieu
Mark
_
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Data returned from a cfc function
Here's a simple cfc function: !--- List users method --- CFFUNCTION NAME=List RETURNTYPE=query HINT=Get complete user list !--- Get users --- CFQUERY NAME=users DATASOURCE=exampleapps SELECT EmployeeID AS UserID, FirstName, LastName FROM tblEmployees ORDER BY LastName, FirstName /CFQUERY CFRETURN users /CFFUNCTION Now, do you think CFRETURN users is the equivalent of cfset users = Duplicate(users) or cfset users = StructCopy(users) another OR probably is not very likely. Though in most cases, I believe both would return same resultsets. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Quick and Easy way to submit/enter all form fields
cfinsert ? _ From: Claremont, Timothy [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 3:55 PM To: CF-Talk Subject: Quick and Easy way to submit/enter all form fields I am looking for an easy way of submitting something like 100 form fields into the corresponding fields in a database, assuming that the field names in the database match the field names on the form. Is there a method to grabbing all of the fields from the form and submitting into the equivalent fields in the database, or do I need to resort to the mile-long ISERT blah blah blah INTO blah blah blah? Thanks! _ [HYPERLINK http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads] [HYPERLINK http://www.houseoffusion.com/lists.cfm/link=i:4:179446This Message] [HYPERLINK http://www.houseoffusion.com/lists.cfm/link=s:4Subscription] [HYPERLINK http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=678.598.4Fast Unsubscribe] [HYPERLINK http://www.houseoffusion.com/signin/User Settings] [HYPERLINK https://www.paypal.com/cgi-bin/webscr?amount=item_name=House+of+Fusionbus iness=donations%40houseoffusion.comundefined_quantity=cmd=_xclickDonation s and Support] _ HYPERLINK http://www.houseoffusion.com/banners/view.cfm?bannerid=37 \n --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.767 / Virus Database: 514 - Release Date: 9/21/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.767 / Virus Database: 514 - Release Date: 9/21/2004 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Backing Up off of server
Hmmm...best guess is that there could be some sort of restriction on the use of DTS or perhaps there is a table or something else in the remote DB that is put there and only accessible by the ISP. Basically you're at the point where you should contact your ISPs tech support and pass along that info and ask what's up.Chances are they'll know who that user is and be able to advise you on how to proceed. Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Quick and Easy way to submit/enter all form fields
and of coures when using CFINSERT you had better make dang sure EVERYTHING matches and ALL data is verified before trying to insert or it's gonna be a major PITA for ya ;-) Personally I'd resort to the mile long approach...far easier to debug and you can use CFQUERYPARAM (which I highly suggest you use) Now if you field names are EXACTLY the same as your form fileds you could always lopp through the form structure and dynamically build your insert list and value list. HTH Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Backing Up off of server
Thanks.This will help keep what little hair I have left on my head and out of my hands. Andy -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 1:14 PM To: CF-Talk Subject: Re: Backing Up off of server Hmmm...best guess is that there could be some sort of restriction on the use of DTS or perhaps there is a table or something else in the remote DB that is put there and only accessible by the ISP. Basically you're at the point where you should contact your ISPs tech support and pass along that info and ask what's up.Chances are they'll know who that user is and be able to advise you on how to proceed. Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
