Re: Annoying undelivered email issue
The mail server in question is our own server. It was down for a few hours while we upgraded it. It's up now, but during the time it was down, several messages were undeliverable. Now that the server is back up, they should be going out. Even so, though, if they're not deliverable, they should at least be moving over to the Undelivr folder instead of simply sitting in the Spool folder. Protoculture wrote: Hi Richard, I think the bigger problem is why they aren't being sent in the first place. Check that your email isn't being flagged as spam by the recipient's server ( or whoever handles the MX records for your company ). We had a similar issue and it wound up to be that AOL was refusing our emails as we were not on their white list. We're still using MX around here (because of an incredibly sloppy setup by my predecessor, upgrading to 6.1 is impractical at best), and we're having a problem with our unsent e-mail. When CF cannot send an e-mail, it puts that e-mail in the /Mail/Undelivr directory with the filename 'Undelievered_Mailx.cfmail'. I should be able to rename that message to 'Mailx.cfmail' and move it to /Mail/Spool and restart the server, and have those messages sent out (or at least put back into the Undelivr diretory. However, these messages are not getting resent; they're just sitting in the Spool directory. What am I doing wrong? This has worked before, and no changes have been made to our installation. -- Richard Crawford, Programmer III UC Davis Extension Distance Education Group http://unexdlc.ucdavis.edu http://www.extensiondlc.net 2901 K Street, Suite 200C Sacramento, CA 95620 Tel: (916)327-7793 e-mail: [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212322 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Annoying undelivered email issue
We're still using MX around here (because of an incredibly sloppy setup by my predecessor, upgrading to 6.1 is impractical at best), and we're having a problem with our unsent e-mail. When CF cannot send an e-mail, it puts that e-mail in the /Mail/Undelivr directory with the filename 'Undelievered_Mailx.cfmail'. I should be able to rename that message to 'Mailx.cfmail' and move it to /Mail/Spool and restart the server, and have those messages sent out (or at least put back into the Undelivr diretory. However, these messages are not getting resent; they're just sitting in the Spool directory. What am I doing wrong? This has worked before, and no changes have been made to our installation. -- Richard Crawford, Programmer III UC Davis Extension Distance Education Group http://unexdlc.ucdavis.edu http://www.extensiondlc.net 2901 K Street, Suite 200C Sacramento, CA 95620 Tel: (916)327-7793 e-mail: [EMAIL PROTECTED] ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212264 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF vs LAMP
On Thursday 02 June 2005 09:27, Calvin Ward wrote: This is true code running in production I had to review once (because there was an error somewhere) http://www.mschopman.demon.nl/horror.txt Oh, God. The horror! The horror! My eyes are melting! Aii!! (And this only supports my contention that the programming language doesn't matter, for the Zen or horrific coding transcends them all.) -- Richard S. Crawford Programmer III UC Davis Extension Distance Education Group 2901 K Street Sacramento, CA 95816 (916)327-7793 http://unexdlc.ucdavis.edu ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208405 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF vs LAMP
On Thursday 02 June 2005 09:35, Kevin Aebig wrote: Coldfusion... PHP... dotNET... truely guys, its all the same thing with different implementations. Now Perl on the other hand Why won't that language just die already... For CGI scripting, Perl has its uses (though I personally haven't used it for that purpose in years). For server-side scripting, though -- like when you need to go through all 4,000 files in all 600 subdirectories from your webroot with a specific naming convention and replace the form action tag with with a new string, the contents of which depend on the name of the directory just above the current subdirectory if that directory name contains a capital letter or a number -- why there ain't nothin' better than Perl. Pound out a four line script, chmod to executable, execute it with perl -w script_name.pl, and you're in business. Assuming you know what the heck you're doing with those regular expressions. And yes, that is something I really have faced. Several times. -- Richard S. Crawford Programmer III UC Davis Extension Distance Education Group 2901 K Street Sacramento, CA 95816 (916)327-7793 http://unexdlc.ucdavis.edu ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208410 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF vs LAMP
On Thursday 02 June 2005 13:42, dave wrote: I guess Simon is trying to say that if I buy a car and everytime it breaks down they will send someone to fix it (even from germany) and he thinks thats a BAD thing? I guess it would be better to take it down to jimmy joes house and confer with the locals about what to do with it, maybe google the problem a bit, maybe find a half-assed answer and then try it and if it gets messed up to bad cause there is really noone to back it up. Sounds good to me, guess i'm gunna ditch cfm and go with that cause gee it sure sounds swell wally. Well, you gotta figure that there are people who *prefer* that approach. If you want to keep the hood of your car welded shut, that's fine with me, and have fun with your 'Vette. I'm personally not going to give you grief about it, because you're probably quite a capable driver. There are those of us, though, who aren't too sure about the mechanics. Seems like every time we call them out to fix the car, they end up breaking something else, then putting in a whole bunch of stuff that I don't want or need and that just hinders what I want to do. Automatic transmission may be nice, but I know I can maximize my standard transmission to get better performance from the car, and I resent the fact that I can't even *get* manual transmission. There's also the fact that I don't really want my car reporting back to the manufacturer, making sure I'm driving it properly. And when I open the hood of my car, I can see exactly what's going on, where all the parts are, what they're doing to each other, and so on. If I don't want that fancy flywheel that does nothing but sit there looking pretty, I can take it out. If I'm having a problem with a specific component, I can open the hood and fix it myself; or I can Google the problem, or contact other experts who have better insight into the problem than I do, and I can do it for free. (To be fair, though, you can do the same with your sealed-hood 'Vette, so comparing how the two different approaches set up and maintain support systems and knowledge bases is probably irrelevant. I *could* pay lots more money for a dedicated help system for my 'Vette, but why bother when the help I can get for free is just as good?) And, of course, there are the issues of security. The 'Vette may have a sealed hood, a nice support system, may go fast and have great performance, but it does me no good if the lock is broken. I could keep putting new keyholes in the same lock, but I'd prefer the option of opening the lock mechanism and fixing it directly. So I think it's all a matter of philosophy, worldview, and personal preference. You like your shiny 'Vette which you pay good money to maintain, and I prefer my old Dodge which is cheaper and older but seems to perform just as well and which I built myself and maintain myself. Where it breaks down -- and where I personally take offense -- is the point where I'm no longer given the choice. Just as I resent the fact that I cannot buy a car with manual transmission, I seriously resent the manufacturers who tell me that a sealed hood is my only option. I don't resent those who tell me that a sealed hood is the *better* option (because I tell them that an open hood is the better option), but if I don't even have a choice to invest in a cheaper option that I can maintain myself, then I'm going to get mad. I'll stop this rant short, though, before I get into issues of politics and economy. ;-) -- Richard S. Crawford Programmer III UC Davis Extension Distance Education Group 2901 K Street Sacramento, CA 95816 (916)327-7793 http://unexdlc.ucdavis.edu ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208443 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF vs LAMP
On Thursday 02 June 2005 14:14, Kevin Aebig wrote: We can drop the example anytime... I'm sure everyone here is smart enough to get it. Sorry to bother you. I was hoping to expand on Dave's metaphor to explain why I have a different viewpoint than he does. It certainly wasn't my intention to annoy you. On the whole, though, this is probably a thread that's better off being ignored anyway. -- Richard S. Crawford Programmer III UC Davis Extension Distance Education Group 2901 K Street Sacramento, CA 95816 (916)327-7793 http://unexdlc.ucdavis.edu ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208448 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF vs LAMP
On Tuesday 31 May 2005 11:03, Joe Rinehart wrote: The 'P' in LAMP usually refers to PHP - which is a pain to read, write, and maintain unless you're very well versed in PHP ;);) Wow. My experience has been very different. I find PHP very easy to work with and quite intuitive, while Cold Fusion frequently puzzles and frustrates me (of course, as has been pointed out here before, it's very easy to write bad code in just about any language; good code in PHP is a LOT easier to read than bad code in Cold Fusion, no matter how well versed you are in either language). I think the IIS vs. Apache for maintanence is a toss-up - IIS's GUI is nice at times, but sometimes I'd kill to just be able to edit httpd.conf. The GUI for IIS really turns me off, since I feel like I have far less control over the server and its capacities than when I can go in and edit httpd.conf directly. But then, I'm a CLI guy instead of a GUI guy, so I'm less likely to use an MS product is something more flexible exists. Running CFMX + MySql is certainly an option - if you do MS SQL, changing to MySql is no big deal. It's very easy to maintain with the new MySql admin and query analyzer tools. In addition to phpmyadmin (which I've grown to love) there is also the mysql control center and a couple of other GUI tools which have been developed. And for the hardcore, there's always the MySQL command line, which I would frequently kill -- or at least maim -- to have in MS-SQL Server. Ultimately, I believe, the choice between LAMP and proprietary technologies falls down to a choice between flexibility and power (LAMP) vs. simplicity and ease of use (MS/CF)*. With flexibility and power comes complexity, and you do frequently have to pay more for expert knowledge; on the other hand, with simplicity and ease of use comes lack of security, so you'll end up paying more for that. Six of one, half dozen of the other, IMO. Personally, though, I am philosophically in favor of F/OS software and opposed to vendor lock-in and proprietary standards (probably because my parents were hippies and I have a background in library science), so I almost always recommend LAMP and F/OSS whenever possible. * Do not trust any studies you might encounter which recommends one approach over the other based on TCO; invariably, these studies are biased and paid for either by MS (or some other major software vendor) or by organizations such as OSDL. -- Richard S. Crawford Programmer III UC Davis Extension Distance Education Group 2901 K Street Sacramento, CA 95816 (916)327-7793 http://unexdlc.ucdavis.edu ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208091 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF vs LAMP
On Tuesday 31 May 2005 12:42, Russ wrote: In addition to phpmyadmin (which I've grown to love) there is also the mysql control center and a couple of other GUI tools which have been developed. And for the hardcore, there's always the MySQL command line, which I would frequently kill -- or at least maim -- to have in MS-SQL Server. Isn't that what SQL Query Analyzer is? Not quite, no. To elaborate, here is a situation which came up for me last week. I was working at home due to illness, and I needed to debug some problems we were having with our SQL Server database. At home, I do not have a copy of either the Enterprise Manager (licensing issues) or the Query Analyzer (not compatible with my computer). I would love to be able to shell in via ssh to the server and execute SQL straight from a command prompt (but then, as I've mentioned, I usually prefer a CLI interface), but I can't do that with SQL Server. If I have SQL Qery Analyzer on my desktop then yes, it's more or less adequate. So what I'd like is the ability to shell in to the remote server and execute commands there, rather than on my desktop. -- Richard S. Crawford Programmer III UC Davis Extension Distance Education Group 2901 K Street Sacramento, CA 95816 (916)327-7793 http://unexdlc.ucdavis.edu ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208094 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: There's got to be a way around this
On Tuesday 24 May 2005 06:54, S. Isaac Dealey wrote: cfparam name=x default= instead of this: cfparam name=form.x default= I'm still not entirely certain how that comes across as the question he asked, except perhaps that he's trying to scope his variables as say variables.x instead of form.x without first copying them down from the form scope into the variables scope, so the server produces an error when it doesn't see variables.firstname even though the firstname input element was a text input. I'm trying to remember if cfparam name=x default= inserts a value into the variables scope if there's a form field matching that variable name... It's been so long since I've used cfparam without scoping the name that I can't remember what the behavior is. Sort of. I don't want to have to include the cfparam line at all, though, since there are so many times when I won't know what parameters are going to be used in a page at the tim that I write it -- such as when a form has been dynamically generated and can contain different fields each time it is generated, based on user input or results from a database query. -- Richard S. Crawford http://www.mossroot.com -- Richard S. Crawford Programmer III UC Davis Extension Distance Education Group 2901 K Street Sacramento, CA 95816 (916)327-7793 http://unexdlc.ucdavis.edu ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207530 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: There's got to be a way around this
On Monday 23 May 2005 22:03, Jim Davis wrote: The developer in question used it as an example of how hard it was to do simple things in CF compared to Java in meeting. I wrote #listfirst(var, -)# and #listlast(var, -)# on the whiteboard. ;^) In general, I prefer to program in PHP since I feel like I have much more control over the code in PHP than I do in Cold Fusion. However, I have come to appreciate CF more over the past few months as I've learned that the code that I've been working with around here is not typical of the kind of code that CF professionals generally produce. -- Richard S. Crawford Programmer III UC Davis Extension Distance Education Group 2901 K Street Sacramento, CA 95816 (916)327-7793 http://unexdlc.ucdavis.edu ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207532 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: There's got to be a way around this
On Tuesday 24 May 2005 10:12, Jim Davis wrote: In my company however this is the norm: we moved away from CF almost purely on the say-so of the Java programmers like the one I mentioned and their assertions that Java was easier to work with. In short they produced complete crap and blamed the language. Sounds like you're working with the results of that kind of thinking. ;^) I tend to agree with you on the whole, though I think I will be spending several days trying to get my head around the idea that Java is easier than anything. I've never been able to figure Java out. -- Richard S. Crawford Programmer III UC Davis Extension Distance Education Group 2901 K Street Sacramento, CA 95816 (916)327-7793 http://unexdlc.ucdavis.edu ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207557 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: js popup resizing ?
On Tuesday 24 May 2005 16:57, Bryan Stevenson wrote: How the heck does that change the window size in any browser? looks to me that it hardcodes the window size to 200x200...which is what IE is doing...what's that about the good browsers Dave?? ;-);-) Uh oh... *donning asbestos pajamas* -- Richard S. Crawford Programmer III UC Davis Extension Distance Education Group 2901 K Street Sacramento, CA 95816 (916)327-7793 http://unexdlc.ucdavis.edu ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207607 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
There's got to be a way around this
It seems that on every Cold Fusion page that processes variables from a previous page -- say a form and the page that processes the form -- every variable on the form must be accounted for. This is fine if the form is unchanging, but if the form is dynamic and might change every time it's loaded, the number and name of the variables that it passes to the processing page may change. In PHP you can cope with this quite nicely by directly accessing the HTTP_POST[] array, casting it to an object and looping through the properties, but I can't find a similar way to do that in Cold Fusion. In Cold Fusion, it looks like I have to use CFPARAM var=value for every single possible variable that might come from the form page. Is there a way around that? -- Richard S. Crawford Programmer III UC Davis Extension Distance Education Group 2901 K Street Sacramento, CA 95816 (916)327-7793 http://unexdlc.ucdavis.edu ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207495 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: There's got to be a way around this
On Monday 23 May 2005 18:22, Ben Forta wrote: FORM is a structure that contains all HTTP POST fields, and you can loop through it easily. Thanks! I'm trying to figure out some old code written by some previous developers, and they used some incredibly complicated tricks to deal with having to have all variables pre-defined, including a special stored procedure that creates a temporary file which contains all the fields... As you can imagine, it has a slight impact on performance. -- Richard S. Crawford Programmer III UC Davis Extension Distance Education Group 2901 K Street Sacramento, CA 95816 (916)327-7793 http://unexdlc.ucdavis.edu ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207504 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: import from MySQL to MS SQL
On Thursday 05 May 2005 10:32, Bryan Stevenson wrote: MySQL is not file based like Access. You need to have a copy of MySQL installed and running. I do JochemMySQL 4.1.11...with an imported copy of the live database ;-);-) As I mentionedI can't figure out how to setup the ODBC connection to my local copy of the MySQL DBthere do not seem to be any suitable drivers listed in the Windows ODBC setupany ideas?? If you insist on converting from MySQL to MS SQL Server (a concept which boggles me, to be honest), try executing a mysqldump from the DOS command line to get a copy of the database, then importing the resulting file into SQL Server. Mind you, I've never tried this personally, but I have done it the other way around. I'm not sure ODBC drivers exist for MySQL. Although I work with both platforms, I've never had a need to connect a SQL Server database to a MySQL database. -- Richard S. Crawford Programmer III UC Davis Extension Distance Education Group 2901 K Street Sacramento, CA 95816 (916)327-7793 http://unexdlc.ucdavis.edu ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205721 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: import from MySQL to MS SQL
On Thursday 05 May 2005 10:53, Bryan Stevenson wrote: LMAO...I was waiting for this one...umm Richard...it's because MySQL no matter what anybody says is not an enterprise level DB (yet)refrerential integrity comes to mind ;-);-) Heh. Well, note that I didn't go into *why* it boggled my mind (in the first draft of my e-mail, I did, but then decided to go ahead and delete that part). Personally, even for the biggest sites I've run, I've never needed a full-fledged enterprise level database. If I did, though, I'd probably go with Oracle or some other vendor, if only because we're a Linux shop and I'd prefer to avoid a multiplicity of platforms. Of course, Oracle has its own issues; among them, the corporation is run by a madman bent on world domination, who makes Hank Scorpio look like a smalltime crook. Hm, one organization that I interact with which has enterprise scale database needs uses PostGreSQL, another FLOSS product; however, I'm not sure if that one is available for 'doze. -- Richard S. Crawford Programmer III UC Davis Extension Distance Education Group 2901 K Street Sacramento, CA 95816 (916)327-7793 http://unexdlc.ucdavis.edu ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205733 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: import from MySQL to MS SQL
On Thursday 05 May 2005 13:09, Bryan Stevenson wrote: Personally, even for the biggest sites I've run, I've never needed a full-fledged enterprise level database. If I did, though, I'd probably go with Oracle or some other vendor and that's exactly where we're headingbut the VC has to come in first ;-);-) with MySQL...my feeling is that you need to add all sorts of things that come standard in MS SQL and Oracle...hell...even Access If I had a huge data repository that was never changed...I'd use MySQL for the speed...but that ain't what I'm up to...I need Stored Procs...ref integrity among other useful tidbits Damn...and I even said to leave this debate alone I just figure it's a matter of personal preference. If I need added functionality in MySQL, I'll just whip together something in Perl. Others prefer not to spend the time or the brainpower. Though I really thought that the meat of my earlier post lay in my joke about Larry Ellison. -- Richard S. Crawford Programmer III UC Davis Extension Distance Education Group 2901 K Street Sacramento, CA 95816 (916)327-7793 http://unexdlc.ucdavis.edu ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205746 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: import from MySQL to MS SQL
On Thursday 05 May 2005 10:53, Bryan Stevenson wrote: LMAO...I was waiting for this one...umm Richard...it's because MySQL no matter what anybody says is not an enterprise level DB (yet)refrerential integrity comes to mind ;-);-) Heh. Well, note that I didn't go into *why* it boggled my mind (in the first draft of my e-mail, I did, but then decided to go ahead and delete that part). Personally, even for the biggest sites I've run, I've never needed a full-fledged enterprise level database. If I did, though, I'd probably go with Oracle or some other vendor, if only because we're a Linux shop and I'd prefer to avoid a multiplicity of platforms. Of course, Oracle has its own issues; among them, the corporation is run by a madman bent on world domination, who makes Hank Scorpio look like a smalltime crook. Hm, one organization that I interact with which has enterprise scale database needs uses PostGreSQL, another FLOSS product; however, I'm not sure if that one is available for 'doze. -- Richard S. Crawford http://www.mossroot.com -- Richard S. Crawford Programmer III UC Davis Extension Distance Education Group 2901 K Street Sacramento, CA 95816 (916)327-7793 http://unexdlc.ucdavis.edu ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205763 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: import from MySQL to MS SQL
On Thursday 05 May 2005 14:46, Bryan Stevenson wrote: Here's some justification for all you MySQL fans Ya wanna know why 21 tables are not importing??...huh...do ya?? Because MySQL has allowed NULLS to be entered into NOT NULL fields!!! MySQL can kiss my. Free = data corruption That's kinda bizarre. I've never seen that behavior before. Ever. Well, actually, yes I have, but only when the data was imported into the MySQL tables from another database, and the not null rule was applied to the field *after* the data was already put into place. Sounds like you've inherited a strange, strange setup. -- Richard S. Crawford Programmer III UC Davis Extension Distance Education Group 2901 K Street Sacramento, CA 95816 (916)327-7793 http://unexdlc.ucdavis.edu ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205767 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: import from MySQL to MS SQL
On Thursday 05 May 2005 15:01, Bryan Stevenson wrote: Yeah...but if apply the NOT NULL rrule after...it still shouldn't let you if there are NULLs in the data ;-);-) (not that this is the case here...straight import from live DB to local MySQL.and off to MS SQL) I don't see how it's possible, though it obviously is. Looking back in my own work journal here, I see that I encountered the exact same problem once myself; the source table contained null values in a field which had a not-null constraint, as well as text data in a numeric-only field, and non-boolean values in a boolean-only field. In my case, however, the target database was Oracle and the source database was... MS SQL. Could it be that there is no such thing as a perfect database? Nah. -- Richard S. Crawford Programmer III UC Davis Extension Distance Education Group 2901 K Street Sacramento, CA 95816 (916)327-7793 http://unexdlc.ucdavis.edu ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205781 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: macromedia and Adobe?!
On Monday 18 April 2005 09:47, Connie DeCinko wrote: I think he was just looking for an excuse, any excuse to ditch CF. Now he thinks he has it. Whereas in our office we'll be migrating from CF to PHP over the next few months. But that's been in the works for over a year now. -- Richard S. Crawford Programmer III UC Davis Extension Distance Education Group 2901 K Street Sacramento, CA 95816 (916)327-7793 http://unexdlc.ucdavis.edu ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203329 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: macromedia and Adobe?!
On Monday 18 April 2005 14:40, Damien McKenna wrote: Let's face it, the internet needs and overhaul at this stage, and RIA's show promise. Several companies have attempted to provide an alternative method of interacting with the internet. One of the best was Rebol (http://www.rebol.com/) but they've been on life support for several years. RIAs are another attempt. XUL applications are another attempt. Microsoft's Avalon is yet another attempt. Which will gain substantial marketshare and last past the next three years is hard to say, I suspect Microsoft will possibly become the defacto standard simply because people always upgrade their Windows machines to the latest and greatest. The Internet has been around for, what, twenty years, and it's only been in the last six or seven years that anyone outside a few universities and government agencies has even taken an interest in it. The World Wide Web is but one part of the Internet, although it's certainly one that's growing in importance (because a website that you can look at in Firefox is a heck of a lot more interesting than an SCP session to the average user). Microsoft has attempted several times to gain control over the user's experience of the Internet, without success. Hopefully, MS will continue to fail in its attempt to dominate the Internet; I, for one, would really hate to see the Internet Microsized. -- Richard S. Crawford Programmer III UC Davis Extension Distance Education Group 2901 K Street Sacramento, CA 95816 (916)327-7793 http://unexdlc.ucdavis.edu ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203447 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Escaping #
I have to do something like this: replace bob #1 with bob \#1 I tried, cfset downLoadFile = replace(attachment.attName, \#, \\#, all) But that only gave me an error; I suspect that CF is still trying to process the octothorpe as a variable delimiter. Is there a way to escape the # so that I can include a literal # in my replace function? -- Richard S. Crawford Programmer III UC Davis Extension Distance Education Group (http://unexdlc.ucdavis.edu) 2901 K Street, Suite 200C Sacramento, CA 95816 (916)327-7793 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201910 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Processing quiz with a non-existent script?!!?
I'm trying to track down a serious bug on our website, which is really starting to annoy me. Basic rundown: We have two servers, a development server and a production server. The directory structure is identical in both servers (with the exception of some permissions issues which should not be relevant). In both servers, there is a form called something like: page1.cfm In page1.cfm, there is a form which calls, as its action, page2.cfm. Page2.cfm does not exist on either server. So why should the form work on the development server and not the production server? Why should it work at all? There *is* a page to process the form, called formDo.cfm, but page2.cfm doesn't exist. Worse, when I view the source on the processed form after the form has been submitted, the page name is given as page2.cfm, in the same directory as page1.cfm. The form tag simply refers to page2.cfm, with no directory structure. I hope I've made this dilemma clear. It's really confusing, especially since the developer only tested on the development server and not the production server, so the problem wasn't caught until after we went live. Thoughts? Solutions? Sympathy? -- Richard S. Crawford Programmer III UC Davis Extension Distance Education Group (http://unexdlc.ucdavis.edu) 2901 K Street, Suite 200C Sacramento, CA 95816 (916)327-7793 ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191097 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Processing quiz with a non-existent script?!!?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ben Doom wrote: | On occasion, I've seen deleted .cfm files continue to work. I had to | manually recompile the directory to make them go away, so I think that | the compiled form gets cached and not deleted properly. That might be the problem. I've cleared out the browser cache and done everything else I can think of. By messing with some database values I was able to produce the error I wanted, but I still have no idea why this happened. Thanks. - -- Richard S. Crawford Programmer III UC Davis Extension Distance Education Group (http://unexdlc.ucdavis.edu) 2901 K Street, Suite 200C Sacramento, CA 95816 (916)327-7793 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.0 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFB7tYX748l/yH/c8YRApAnAKCxRnIIXmPwAWzQxewQ4ibOg60AsQCeKYnE BB5IPM5G+9SE61C23S6px1w= =M5ac -END PGP SIGNATURE- ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191123 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF_HappyHolidays
Barney Boisvert wrote: Need to edit that. The 25th is the first day of Christmas, and the 12th day is the 5th of January of the next year (the day before Epiphany, which is the 6th). But funny none the less. I always thought that Epiphany *was* the twelfth day of Christmas. I guess I just never counted. ;-) cheers, barneyb On Wed, 22 Dec 2004 13:20:19 -0800, Spike [EMAIL PROTECTED] wrote: And to you too http://www.spike.org.uk/funny/12days.cfm :) Spike -- Richard S. Crawford Programmer III UC Davis Extension Distance Education Group (http://unexdlc.ucdavis.edu) 2901 K Street, Suite 200C Sacramento, CA 95816 (916)327-7793 ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188588 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Intercepting Flash....?
I hope I'm explaining this right. We have a Flash movie built by someone else outside of our department. The movie takes in a number of values and then sends them to a Cold Fusion script to send the values to the instructor via e-mail cfmail . The Flash movie then continues. I would like to be able to display all of the values that are sent by the movie prior to the values being sent by cfmail. I've tried putting a simple cfdump in the same script with the cfmail tag, but that did not do the job. Any thoughts? Have I made myself clear at all? -- Richard S. Crawford Programmer III UC Davis Extension Distance Education Group (http://unexdlc.ucdavis.edu) 2901 K Street, Suite 200C Sacramento, CA 95816 (916)327-7793 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187126 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Intercepting Flash....?
dave wrote: depends on how its getting its values either add a few frames to the movie or get the values in the cfm file and return to flash but ur gunna have to edit the flash movie to do it cfdump aint gunna help at all I was afraid of that. I do not have access to the source code of the Flash movie, so I'll have to get in touch with the original developer. -- Richard S. Crawford Programmer III UC Davis Extension Distance Education Group (http://unexdlc.ucdavis.edu) 2901 K Street, Suite 200C Sacramento, CA 95816 (916)327-7793 ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187136 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Undeliverable CFMAIL
Here's what I've tried so far: Moving one test message from /Undelivr to /Spool. Of course there's a typo in the name, so I changed it from Undelievered_Mailx to Undelivered_Mailx. I also tried removing the Undelivered part of the mail. Once I had moved and renamed it, I restarted the JRun server. Then I watched the Spool directory to see when the message would leave the spool. Eventually, the message vanished from the Spool directory but it was not delivered. When I checked the Undeliv directory, the message was there. I checked the mailsent.log file and saw only that the message had been moved, but there was no reason listed for why the message was undeliverable. In order to test this process, I introduced a deliberate error into the Mail Server settings of the Cold Fusion administrator, so that the system would not be able to contact the mail server. Any help would be greatly appreciated. -- Richard S. Crawford Programmer III UC Davis Extension Distance Education Group (http://unexdlc.ucdavis.edu) 2901 K Street, Suite 200C Sacramento, CA 95816 (916)327-7793 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184160 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Undeliverable CFMAIL
Richard Crawford wrote: Here's what I've tried so far: Moving one test message from /Undelivr to /Spool. Of course there's a typo in the name, so I changed it from Undelievered_Mailx to Undelivered_Mailx. I also tried removing the Undelivered part of the mail. Once I had moved and renamed it, I restarted the JRun server. Then I watched the Spool directory to see when the message would leave the spool. Eventually, the message vanished from the Spool directory but it was not delivered. When I checked the Undeliv directory, the message was there. I checked the mailsent.log file and saw only that the message had been moved, but there was no reason listed for why the message was undeliverable. In order to test this process, I introduced a deliberate error into the Mail Server settings of the Cold Fusion administrator, so that the system would not be able to contact the mail server. Any help would be greatly appreciated. All right, I'm a goober. When I set the log option to debug, I was able to find out the exact error. Turns out that I had to fix the mail server IP address in the undelivered message file. Once I moved the file, renamed it, and fixed the IP address, then restarted the JRun server, the mail was delivered and received properly. Like I said, I'm a goober. Thanks to everyone who offered up suggestions and assistance. -- Richard S. Crawford Programmer III UC Davis Extension Distance Education Group (http://unexdlc.ucdavis.edu) 2901 K Street, Suite 200C Sacramento, CA 95816 (916)327-7793 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184176 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Undeliverable CFMAIL
In about two weeks, our mail server will be going down for a couple of days. Consequently, any messages sent by Cold Fusion during that time will not be delivered. Does the CF server maintain these undelivered messages anywhere? -- Richard S. Crawford Programmer III: Oracle/Solaris Wrangler UC Davis Extension Distance Education Group (http://unexdlc.ucdavis.edu) 2901 K Street, Suite 200C Sacramento, CA 95816 (916)327-7793 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183792 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Undeliverable CFMAIL
Peterson, Andrew S. wrote: C:\cfusionmx\mail\undelivr Not sure of your path, but look for the undelivr folder. When the mail server goes back online, cut and paste those files into the Spool folder in the same directory I'm actually running CF in a Solaris environment. I executed the following command: $ cd Undelvr $ cp Undelievered_Mailx.cfmail ../Spool But that didn't quite do it. I assume that I need to change the filename when I move it to the Spool directory. -- Richard S. Crawford Programmer III: Oracle/Solaris Wrangler UC Davis Extension Distance Education Group (http://unexdlc.ucdavis.edu) 2901 K Street, Suite 200C Sacramento, CA 95816 (916)327-7793 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183796 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Undeliverable CFMAIL
Venable, John wrote:
They will be in {cfroot}/Mail/Undelivr
Just respool and you should be good to go.
How does one respool?
--
Richard S. Crawford
Programmer III: Oracle/Solaris Wrangler
UC Davis Extension Distance Education Group (http://unexdlc.ucdavis.edu)
2901 K Street, Suite 200C
Sacramento, CA 95816
(916)327-7793
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183797
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Undeliverable CFMAIL: code to handle
Anders Green wrote: At 03:58 PM 11/9/2004, you wrote: In about two weeks, our mail server will be going down for a couple of days. Consequently, any messages sent by Cold Fusion during that time will not be delivered. Does the CF server maintain these undelivered messages anywhere? As mentioned, in the spool directory. But in addition to your planned outage, if there are hiccups or whatever, you'll end up with some emails there on occasion. I set up a task that runs every 15 minutes or so to copy anything it finds in undelivr to spool. Here's the code. You've probably got some sitting in there right now. ;) I do. I experimented and tried copying one of the files to the Spool directory (after changing the To: line so that the recipient wouldn't get confused). Nothing happened, though, and that file is still sitting in my Spool directory. -- Richard S. Crawford Programmer III: Oracle/Solaris Wrangler UC Davis Extension Distance Education Group (http://unexdlc.ucdavis.edu) 2901 K Street, Suite 200C Sacramento, CA 95816 (916)327-7793 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183802 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Undeliverable CFMAIL: code to handle
Al Everett wrote: I always assumed that the current name was just to have a directory name that was 8 characters or less, for compatibility with something ancient. I was speaking to Richard Crawford's message: I'm actually running CF in a Solaris environment. I executed the following command: $ cd Undelvr $ cp Undelievered_Mailx.cfmail ../Spool But that didn't quite do it. I assume that I need to change the filename when I move it to the Spool directory. That's the misspelling I was talking about. Just one of many reasons to get past 6.0 as fast as possible. I wish. Unfortunately, very poor planning on the part of the original implementer (NOT ME!!) would make upgrading to 6.1 incredibly difficult. -- Richard S. Crawford Programmer III: Oracle/Solaris Wrangler UC Davis Extension Distance Education Group (http://unexdlc.ucdavis.edu) 2901 K Street, Suite 200C Sacramento, CA 95816 (916)327-7793 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183810 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Forcing CF to send a request back to Apache?
Okay, this is complicated, and I apologize for that. First of all, our website runs a mix of Cold Fusion and Perl scripts. This is generally fine, except that Perl scripts don't run if the context-root in included in the path to the script. Is there a way to force the Cold Fusion server to send an HTTP request back to Apache?Thus, http://mysite.com/cfmx/perl/script.pl would become http://mysite.com/perl/script.pl As it is, if the context-root is included in the URL for the Perl script, the script doesn't run and the user sees the Perl source code instead. Any thoughts? -- Richard S. Crawford Programmer III: Oracle/Solaris Wrangler UC Davis Extension Distance Education Group (http://unexdlc.ucdavis.edu) 2901 K Street, Suite 200C Sacramento, CA95816 (916)327-7793 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Forcing CF to send a request back to Apache?
Barney Boisvert wrote: You can't make CF do it, but you can certainly do that with mod_rewrite.These two rules should be pretty close, though they might not be perfect.(obviously assume your server has mod_rewrite enabled): RewriteEngine On RewriteRule ^/cfmx(.*\.pl)$ /$1.pl [L] The rewrite phase of Apache's request processing happens before it hand off to JRun/CFMX, so the request will be moved out of the CFMX context root before being sent to CF at all. It worked with a bit of modification: RewriteRule ^/cfmx(.*\.pl)$ /$1 [L] This puts two /'s in the URL before the filename for some reason, but if I insert another / between cfmx and (.*\.pl), I get a redirection error. This will do for now.Also, with the .pl after the $1, the URL had two .pl's appended. ;-) Thanks! -- Richard S. Crawford Programmer III: Oracle/Solaris Wrangler UC Davis Extension Distance Education Group (http://unexdlc.ucdavis.edu) 2901 K Street, Suite 200C Sacramento, CA95816 (916)327-7793 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Automated Scripts?
I'm trying to figure out how to run some Cold Fusion scripts automatically. For example: our users have logins that expire every three months.I'd like to set up a script which would run each morning to scan all of the users in the database, and send an e-mail to those users whose logins will be expiring in a week. I've looked through the CF Admin page, and haven't found any settings or anything which would set this up. -- Richard S. Crawford Programmer III: Oracle/Solaris Wrangler UC Davis Extension Distance Education Group (http://unexdlc.ucdavis.edu) 2901 K Street, Suite 200C Sacramento, CA95816 (916)327-7793 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Automated Scripts?
Ah.Okay. Looks like I picked the wrong week to give up coffee.;-) Bryan Stevenson wrote: ummm...scheduled tasks in CF Adminbeen there for ever!! You write the code to be run...setup a task to run it when you want. That's it...easy like pie ;-) 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: Richard Crawford To: CF-Talk Sent: Monday, August 23, 2004 9:39 AM Subject: Automated Scripts? I'm trying to figure out how to run some Cold Fusion scripts automatically. For example: our users have logins that expire every three months.I'd like to set up a script which would run each morning to scan all of the users in the database, and send an e-mail to those users whose logins will be expiring in a week. I've looked through the CF Admin page, and haven't found any settings or anything which would set this up. -- Richard S. Crawford Programmer III: Oracle/Solaris Wrangler UC Davis Extension Distance Education Group (http://unexdlc.ucdavis.edu) 2901 K Street, Suite 200C Sacramento, CA95816 (916)327-7793 -- Richard S. Crawford Programmer III: Oracle/Solaris Wrangler UC Davis Extension Distance Education Group (http://unexdlc.ucdavis.edu) 2901 K Street, Suite 200C Sacramento, CA95816 (916)327-7793 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Retrieving old CFMAIL messages
Jochem van Dieten wrote: Richard Crawford wrote: We have a situation where we need to retrieve the text of all messages sent through our servers with the CFMAIL tag over the past year to a particular e-mail address.I have already looked at the mailsent.log file, but it only indicates whether the mail was sent successfully or not. Is there a way to pull out the text of those messages?Or are they gone for good? Gone for good (unless you have an Echelon account). That's pretty much what we had figured.Ah, well. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Retrieving old CFMAIL messages
We have a situation where we need to retrieve the text of all messages sent through our servers with the CFMAIL tag over the past year to a particular e-mail address.I have already looked at the mailsent.log file, but it only indicates whether the mail was sent successfully or not. Is there a way to pull out the text of those messages?Or are they gone for good? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFINCLUDE question
I'm using CFINCLUDE to bring in a file from another directory into my current file.The problem is that the file being included contains references to images in other folders, via relative paths.Thus, when I load the main page into a browser, the images do not show up. Is there a way around this, short of using absolute paths to the image files? -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Why don't query variables persist?
I have the following bit of code: cfstoredproc datasource=DLCampus procedure=dlc_sp_verifyLogin debug=yes cfprocparam type=in value=#trim(FORM.sLogin)# cfsqltype=cf_sql_varchar cfprocparam type=in value=#trim(FORM.sPassword)# cfsqltype=cf_sql_varchar cfprocparam type=in value=#CGI.REMOTE_HOST# cfsqltype=cf_sql_varchar cfprocparam type=in value=#cgi.http_user_agent# cfsqltype=cf_sql_varchar cfprocparam type=in value=#screenSize# cfsqltype=cf_sql_varchar cfprocparam type=out variable=studentID cfsqltype=cf_sql_integer cfprocparam type=out variable=success cfsqltype=cf_sql_integer cfprocparam type=out variable=lastLoginDate cfsqltype=cf_sql_date /cfstoredproc ...and later on, I have... h1cfoutput#studentID#/cfoutput/h1 Unfortunately, by the time the second snippet is executed, which is supposed to print out the value of #studentID#, which is determined in the stored procedure, the value has changed to 0.I know it's not 0 earlier on, since other stored procedures which depend on a non-zero value for this variable do not throw exceptions. The worst part about this is that it *used* to work.It seems to have broken when I changed the datasource to point to a different Oracle database.The new database is identical to the old one, as far as I can tell, but... things just don't work, and I can't find any errors in any logs. Any thoughts? -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Replacing strings as part of a query
Deanna Schneider wrote: What database are you using? This sounds like something that would be best handled at the database level, instead of running it through CF. Deanna, I'm using SQL Server 7.The problem is that the field with the characters to be replaced is a TEXT field, and you can't use the REPLACE function on a TEXT field.And, unfortunately, the data is too big in some of the records to CAST to VARCHAR. Here is the SQL that I've tried using: - select msgID, msgSent, msgFromType, msgFromID, msgSubject, REPLACE (CAST(msgMessage AS varchar(8000)), CHAR(13), 'BR') AS newMessage, msgOriginal, attID into tblMessageNew from tblMessage -- In records where the value of msgMessage is greater than 8000 characters, the SQL bombs and no results are returned. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Replacing strings as part of a query
Deanna Schneider wrote: Don't know SQL Server. Sorry. But, as for your 500 error - make sure that show friendly http errors is turned off in your IE preferences. Then, you should at least see more info. That in itself isn't an issue (I don't use IE if I can possibly avoid it).I had hoped that I could find more information by checking the CF server log, but it was unrevealing. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Good, free (or cheap) webmail application
Burns, John D wrote: Can anyone recommend webmail application that works with POP3 that works well and has a good UI?CF would be nice, but not a necessity.It's a Windows 2003 Server and we have PHP and ASP enabled.Easy to set up would be a good thing.It's actually working with iMail installed directly on that server but the iMail web interface can only be accessed over non-standard ports (default is 8383) and some of my clients are running into problems with accessing that because of firewalls and such. iMail does it all through it's own web server so there's no way to point IIS to a directory and make it work.If someone knows of a good app that interfaces with iMail and all of it's features that'd be even better, as long as it can be under port 80.Otherwise, just a simple POP3 email application would be great.Thanks! I haven't found a good webmail app that works well with POP3.If IMAP is an option for you, look up Squirrel Mail.It's written in PHP and has pretty decent functionality.It should work on Windows, as long as you have PHP installed. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Replacing special characters in a string
I have a set of strings that contain carriage returns.I'd like to go through and strip them out.I figure the REPLACE function would do the job but I'm not sure how to refer to the carriage returns. INPUT STRING: I am a string with a carriage return OUTPUT STRING: I am a string with a carriage return Any hints out there? -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Replacing strings as part of a query
Actually, my question about replacing special characters (thanks to all who answered, by the way) was part of a larger question.What I really need to do is select all rows of one table, modify the value of one field, and insert all of the rows, with that one modified field, into another table. Here is the code I've written as an attempt: cfset sourceTable=tblMessage cfset targetTable=tblMessageNew cfquery name=get datasource=DLCampus select * from tblMessage /cfquery pbAll rows selected.Processing.../b/p cfquery name=put datasource=DLCampus cfoutput query=get cfset newMessage = replace(#get.msgMessage#,chr(13)chr(10),BR) insert into tblMessageNew (msgID, msgSent, msgFromType, msgFromID, msgSubject, msgMessage, msgOriginal, attID) values #get.msgID#, '#get.msgSent#', #get.msgFromType#, #get.msgFromID#, '#get.msgSubject#', '#get.msgMessage#', #get.msgOriginal#, #get.attID# /cfoutput /cfquery Unfortunately, it doesn't seem to be quite working.No errors are returned; when I try to run the code, I get a 500 Null error, which is astonishingly uninformative.;-) -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Secure FTP?
Burns, John D wrote: I asked a question earlier about transferring files from one server to another automatically.The 2 servers are not on the same network and the files that are being copied are sensitive HR-type files.What is the most secure way to transfer files like that?Secure FTP?Is there some other method? SCP is probably your best bet. I'm assuming that the two servers are both *nix servers, and you've got a Windows desktop.Check out WinSCP or FileZilla, both of which can handle SCP transfers with a clean GUI interface. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Secure FTP?
If you're using Windows servers, then why are you even bothering with secure FTP? ;-) Seriously, I don't know if these tools will work with Windows servers. Good luck. Burns, John D wrote: I believe the servers are windows.Will this still work?Is there a server for windows to support SCP? John Burns -Original Message- From: Richard Crawford [mailto:[EMAIL PROTECTED] Sent: Thursday, June 03, 2004 1:56 PM To: CF-Talk Subject: Re: Secure FTP? Burns, John D wrote: I asked a question earlier about transferring files from one server to another automatically.The 2 servers are not on the same network and the files that are being copied are sensitive HR-type files.What is the most secure way to transfer files like that?Secure FTP?Is there some other method? SCP is probably your best bet. I'm assuming that the two servers are both *nix servers, and you've got a Windows desktop.Check out WinSCP or FileZilla, both of which can handle SCP transfers with a clean GUI interface. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMAIL... won't.
Using CFMX under JRun 4 on Solaris 9. I've got a Cold Fusion script which uses the CFMAIL function to send the results of a quiz to an instructor.Unfortunately, no matter what I do, I can't get the mail to go through.I've checked that I'm using the proper syntax for CFMAIL, that my mail server is available and is accepting connections from the CF server, and I've reviewed the mailsend log and found no errors.The mail just doesn't get sent. Where else can I look? -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: One slow server...
Dave Watts wrote: I've also checked the SQL in the SP's that CF calls, and there seems to be nothing wrong there; when I run them in the command line they only take a few seconds to run.However, it takes several minutes for the login to process on the web. I'm at a loss. Anyone got any ideas as to what I could check next? As Jochem suggested, you should check the patch history of the Windows machine. You might also try connecting from other clients on other machines, to see if you can narrow down the cause of the slowdown. You might use ViennaSQL and the MS SQL Server JDBC driver to test. I don't maintain the server myself.I hate working with Windows servers, so I'm quite happy that I don't have to maintain this one.;-) As far as I know, our NT babysitter keeps it up to date. I've tracked the problem down, actually, to a single table in the database which appears to be corrupted.It may have happened during a recent attempt to replicate the table from another database.At any rate, it's moved beyond a CF question to a SQL Server question. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
One slow server...
I am at a loss here. Here's the setup: Webserver running Cold Fusion MX on JRun4 on Solaris9, talking to MS SQL Server database on a different machine. About two weeks ago, we started experiencing serious slow-downs on our site.Neither computer is responsible -- the Solaris box is running normally, as is the Windows box (we just put in a brand new hard drive, too, defragged it and everything).There seems to be no hardware problems. I've also checked the SQL in the SP's that CF calls, and there seems to be nothing wrong there; when I run them in the command line they only take a few seconds to run.However, it takes several minutes for the login to process on the web. I'm at a loss.Anyone got any ideas as to what I could check next? -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Generic Table Copy from one DB to another
I'm trying to write a script which will take as an argument a table name, then copy the data from that table in one table to an identical table in another database (assuming that the target database has a blank table with an identical structure). Has anyone attempted this sort of task before?How would I go about starting this project? -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Generic Table Copy from one DB to another
Dick Applebaum wrote: are the source and target db's 1) on the same db server? 2) on different db servers local to the same host 3) on different db servers local to different hosts. 4) are you trying to create an exact duplicate of the source in the target or update the target? what db servers? The databases are on two different servers, but I don't believe that's an issue since both are accessible to Cold Fusion, and I believe I can maintain two separate datasources at once.Both databases are in SQL Server. The two databases are... DBA - DBB tab1A tab1B tab2A tab2B ... tabnA tabnB I want to replace all of the data in tab1B with the data in tab1A, then all the data in tab2B with all the data in tab2A, and so on. Ordinarily I would use the bcp utility to take care of this task, but there are a couple of reasons why I can't this time. Depending on the above answers, you may be able to: 1) use built-in db server commands/features Won't work, unfortunately.See above. 2) write a CF query of the source and iterate over it, doing inserts/updates with the target That was my plan.I can't figure out how to insert into the target table without specifically referencing the field names of the source table, which I'm hoping to avoid. 3) you may have to do some data exchange using WDDX with a stub program on the target host and do the above Haven't got a clue how to do that. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Generic Table Copy from one DB to another
Tony Weeg wrote: why not use select into? I am still looking for information about select into. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Generic Table Copy from one DB to another
Tony Weeg wrote: ok... here ya go...simple but effective. select * INTO server_B.something.dbo.database_B from server_A.something.dbo.database_A that will take everything from a to b, table structure etc. tw I must need more coffee this morning, because I can't find any reference to this in my CF manuals.Can you point me to an on-line reference with some more information? -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Generic Table Copy from one DB to another
Doug James wrote: Presuming M$ SQL Server, one could write a stored procedure the perform the 'select into'. One note, if the goal is to be able to pass in any source table and any matching destination table then the stored proc would have to build a string and then use 'exec sp_executesql' to execute the string. We won't be using stored procedures for this particular task.The goal, for various reasons, is to stick with CF. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Generic Table Copy from one DB to another
Tony Weeg wrote:
with cf?
cfquery name=get datasource=dsn1
select * from thisTable
/cfquery
cfloop query=get
cfquery name=set datasource=dsn2
insert into newTable
(column1, column2, column3)
values
('#get.value1#','#get.value2#','#get.value3#')
/cfquery
/cfloop
that's just one way...that I usually use!
Spiffy!
Is there a way to do this without specifically listing all of the table
names?
--
Richard S. Crawford
Programmer III,
UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu)
(916)327-7793 / [EMAIL PROTECTED]
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: Generic Table Copy from one DB to another
Tony Weeg wrote:
uhh, Im not sure what ya mean.I guess you could have a random word
generator, and hope that it matches a table in your database or something
like that.
:) seriously...tho', not sure what you mean, or where/why it would come into
play...im sure you have a valid need...just wondering.
-Original Message-
From: Richard Crawford [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 22, 2004 2:42 PM
To: CF-Talk
Subject: Re: Generic Table Copy from one DB to another
Tony Weeg wrote:
with cf?
cfquery name=get datasource=dsn1
select * from thisTable
/cfquery
cfloop query=get
cfquery name=set datasource=dsn2
insert into newTable
(column1, column2, column3)
values
('#get.value1#','#get.value2#','#get.value3#')
/cfquery
/cfloop
that's just one way...that I usually use!
Spiffy!
Is there a way to do this without specifically listing all of the table
names?
Gonzo gave me a pretty good start, actually.
But the problem is this: I want to be able to specify a table at
runtime, and not have to worry about its structure.In the script you
gave, you specifically give the column names: column1, column2, etc.I
need a script where I don't have to write out the column names.
In other words, in my simple book database, I have two tables: a table
for authors and a table for titles, both with different structures.I
want to be able to run the same generic script on both tables without
having to make changes to the script itself.
--
Richard S. Crawford
Programmer III,
UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu)
(916)327-7793 / [EMAIL PROTECTED]
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: CFIF Insanity
Matthew Walker wrote: Maybe you know this already but CF still processes content inside HTML comments. So you shouldn't comment out CFML with HTML comment markup. The strange thing is that the troublesome comment markers worked fine before I rearranged some of the code inside the script to make it more manageable. This might be one of those situations where the previous developer wrote code that depended on a quirk of the processor in order to make his page work.Bad practice, in my opinion. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFIF Insanity
I have a rather long script that I've been editing with HomeSite.When I try to run it, I keep getting this error: Context validation error for tag cfif. The end tag /cfif requires a matching start tag. I've gone over this code with a fine-toothed comb several times and even rewritten big parts of it, even introduced extra CFIF tags (along the lines of CFIF 1 IS 1) and I have not been able to get rid of this error.HomeSite also has a feature which allows you to examine all tags and find matching close or start tags, and I found no unmatched /CFIF tags. I conclude that it's not REALLY a CFIF error, but something more insidious and subtle, the true intention of which is to piss me off. ;-) Anyone have any ideas where else I could be looking? -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFIF Insanity
J E VanOver wrote: Can you postyour code? Unmatched comment tags? It turned out to be something similar.Some parts of the code contained comments that started with !--- and some that started with !--.I went ahead and replaced all of the latter with !--- and that seems to have fixed it. Weird. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFIF Insanity
Barney Boisvert wrote: With DMWX I've run into sporadic situations where it will replace certain things with this big long string of nastiness that seems to be some form of metadata markup about a given variable or tag.I've got a couple files in my app (of about 2000) that I can't edit in DW, I have to use a different editor. Don't know if that's the problem, but you might try opening the offending template in notepad/textpad and seeing if there is any extra crap lying around. Thanks for the suggestion. HomeSite is wonderful in that it is mostly just a fancy text editor with built-in CFML and HTML (and PHP, too) validation and a built-in FTP client.It doesn't insert one bit of code that you don't want in there.:) The solution was a minor issue with comments.For some reason, standard HTML comments !-- like this -- were screwing it up.I replaced them with CFML comments !--- like this ---. Who knew? Time for a beer. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Oracle/CF issue apparently resolved
I was receiving an error, Wrong number of type of parameters passed whenever trying to call my Oracle stored procedure from Cold Fusion.I received this error in one stored procedure, fixed it, and then got it with another stored procedure. Both of the stored procedures, as it turned out, were in the same package body in Oracle.I separated them out of the package body, and this seems to have resolved the issue. I have many, many other issues getting Oracle to work successfully with Cold Fusion (a large part of the problem is the really bizarre database design that I've inherited), but I'm smashing my way through them one by one. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Even more CF and Oracle stuff: Closing a cursor
After I've executed an Oracle Stored procedure and brought the results into Cold Fusion, is there a way to close the ref cursor within Cold Fusion?I've tried calling a second stored procedure that closes the cursor, but this doesn't seem to do the trick. Is it even necessary to close the cursor? -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Even more CF and Oracle stuff: Closing a cursor
Deanna Schneider wrote: My understanding is that if you use a cursor for it gets closed implicitly. I've used this syntax before (without closing) successfully: BEGIN OPEN mycursor FOR select blah blah; END; That makes sense to me.It's what I've been assuming as well. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
More Oracle/CF fun!
Consider this stored procedure (part of package DLC): PROCEDURE dlc_mail_countMsg ( studentID IN number, mailInfo OUT types.cursorType ) AS BEGIN OPEN mailInfo FOR SELECT count(*) AS msgCount FROM tblMail WHERE mIndividID = studentID AND mToType = 1 AND mRecipActive = '1' AND mRead IS NULL; END dlc_mail_countMsg; ...and this CFSTOREDPROC call: cfstoredproc datasource=DLCampus procedure=dlc.dlc_mail_countMsg cfprocparam type=in value=#cookieID# cfsqltype=cf_sql_integer cfprocresult name=msgCount /cfstoredproc ...and, finally, this error message: Error Executing Database Query. [Macromedia][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'DLC_MAIL_COUNTMSG' ORA-06550: line 1, column 7: PL/SQL: Statement ignored In tblMail, the datatypes are: mIndividID number mToType number mRecipActive char(1) mRead date I can't see the error.It looks like all of the paramters are being passed, and nothing unusual is going on.I've Googled but couldn't find anything that looks relevant. Anyone have any ideas? -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cold Fusion and Oracle
Nick Han wrote: You need the ref cursor.types.cursorType---don't take this out. studentInfo types.cursorType; did you declare types.cursorType in the package spec?, and it has to be a ref cursor type! example: TYPE cursorType IS REF CURSOR; =you need this line in the package spec or else it will not work! again, it looks like you need to wrap this procedure in a package and invoke it through Cold Fusion via [package_name.procedure_name] in the storeproc tag. Yep, I've got a package called dlc and this procedure is part of the package body; I invoke the procedure with dlc.test_dlc_sp_getstudentinfo.types.cursorType is defined as a ref cursor in the package called types. Nick Han [EMAIL PROTECTED] 03/08/04 03:35PM It yields this error: Variable GETNAME is undefined Rob wrote: what does cfdump var=#getName# yield? On Mon, 2004-03-08 at 15:25, Richard Crawford wrote: Well, I altered the stored procedure as follows: = PROCEDURE test_dlc_sp_getStudentInfo ( studentID IN number ) as studentInfo types.cursorType; sFirst varchar2(50); sLast varchar2(50); sOrient char(1); begin open studentInfo for select sFirst, sLast, sOrient from tblStudentInfo where sid = studentID; CLOSE studentInfo; END test_dlc_sp_getStudentInfo; = Essentially, I removed the studentInfo ref cursor from the parameter list. Now, I run the Cold Fusion page, and the Unsupported Data Conversion error message is gone.Woo hoo! However, if I call the Stored Procedure from Cold Fusion like this: = cfstoredproc datasource=DLCampus procedure=dlc.test_dlc_sp_getStudentInfo cfprocparam type=in value=1881 cfsqltype=cf_sql_decimal cfprocresult name=getName /cfstoredproc = I would hope that I could get at the value of sOrient like this: cfoutput#getName.sOrient#/cfoutput Unfortunately, now I get a new error: = Element SORIENT is undefined in GETNAME = I don't know if I'm making progress or not. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cold Fusion and Oracle
Janet, Thanks for the suggestion.I tried it, but continue to receive the unsupported data conversion error. This is getting mighty frustrating. Janet Schmitt wrote: I would try something like this for the Oracle portion: CREATE OR REPLACE PACKAGE schemaname.studentpackage IS TYPE student_type_ref_cursor IS REF CURSOR; PROCEDURE test_dlc_sp_getStudentInfo(studentID IN number, student_cursor IN OUT student_type_ref_cursor); END; Create or replace package body schemaname.studentpackage IS PROCEDURE test_dlc_sp_getStudentInfo ( studentID IN number, student_cursor IN OUT student_type_ref_cursor) is begin open student_cursor for select sFirst, sLast, sOrient from tblStudentInfo where sid = studentID; end; END studentpackage; [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cold Fusion and Oracle
Stacy Young wrote: Perhaps I spoke too soon...I just remembered an unsolved mystery with our CF servers relating to an occasional JDBC error involving CF_SQL_NUMBER and a numeric field in oracle. Thanks for the tip! Stace Stace, How did you resolve the issue?I think I'm having the same problem. _ From: Doug Keen [mailto:[EMAIL PROTECTED] Sent: Monday, March 08, 2004 2:19 PM To: CF-Talk Subject: Re: Cold Fusion and Oracle I've had similar issues when migrating a CF/Oracle app from CF 4.5 to CF 6.1.During that adventure I found this resource: http://www.blinex.com/~sam/CF_SQL_TYPES.cfm This chart maps CF_SQL_TYPE's to types specific to different database platforms, including Oracle.In your case, you might have some luck if you change you CF_SQL_NUMBER parameters to CF_SQL_FLOAT (it worked for me, and as that chart shows, it's a better match for Oracle's NUMBER type). Doug Keen Senior Consultant, The Seva Group http://www.sevagroup.com Phone: 443-703-2087 Fax: 443-703-2097 Toll-Free: 1-888-230-1576 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cold Fusion and Oracle
Janet Schmitt wrote: Richard - What is the format of the table tblStudentInfo?What are the datatypes specified for sFirst, sLast, sOrient and studentId? What is the CFSTOREDPROC code that was used to call this procedure? Janet. Janet, Here is the table definition: SID NUMBER NOT NULL SFIRST VARCHAR2(30) NOT NULL SLAST VARCHAR2(50) NOT NULL SORIENT CHAR(1) NOT NULL There are a few other fields in the table, but I'm not referencing them, so they don't seem relevant. Here is the CFSTOREDPROC code: cfstoredproc datasource=DLCampus procedure=dlc.test_dlc_sp_getStudentInfo cfprocparam type=in value=1881 cfsqltype=cf_sql_integer cfprocresult name=getName /cfstoredproc And, just for completeness's sake, here is the package definition, including the SP: CREATE OR REPLACE PACKAGE dlc AS PROCEDURE test_dlc_sp_getstudentinfo ( studentID IN integer, studentInfo OUT types.cursorType ); END dlc; / CREATE OR REPLACE PACKAGE BODY dlc AS PROCEDURE test_dlc_sp_getStudentInfo ( studentID IN integer, studentInfo OUT types.cursorType ) as sFirst varchar2(30); sLast varchar2(50); sOrient char(1); begin open studentInfo for select sFirst, sLast, sOrient from tblStudentInfo where sid = 1881; CLOSE studentInfo; END test_dlc_sp_getStudentInfo; END dlc; At 09:45 AM 3/9/2004 -0800, you wrote: Janet, Thanks for the suggestion.I tried it, but continue to receive the unsupported data conversion error. This is getting mighty frustrating. Janet Schmitt wrote: I would try something like this for the Oracle portion: CREATE OR REPLACE PACKAGE schemaname.studentpackage IS TYPE student_type_ref_cursor IS REF CURSOR; PROCEDURE test_dlc_sp_getStudentInfo(studentID IN number, student_cursor IN OUT student_type_ref_cursor); END; Create or replace package body schemaname.studentpackage IS PROCEDURE test_dlc_sp_getStudentInfo ( studentID IN number, student_cursor IN OUT student_type_ref_cursor) is begin open student_cursor for select sFirst, sLast, sOrient from tblStudentInfo where sid = studentID; end; END studentpackage; -- [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cold Fusion and Oracle
sampath nellutla wrote: CFSTOREDPROC procedure= mySchema.myPackage.spl_proc_summary datasource=#request.datasource# Based on my own understanding, this line: cfprocparam cfsqltype=CF_SQL_REFCURSOR type=OUT is unnecessary in CFMX+. CFPROCRESULT NAME=rs1 /CFSTOREDPROC Now if only I could find out what's necessary to make MY situation work out! -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cold Fusion and Oracle -- RESOLVED
Janet Schmitt wrote: 3.Remove the close cursor statement from the package body. Janet, Turns out that #3, above, was all that I needed to do.I feel kinda silly (why would I want to close the cursor if I wanted to read it later on?!!?), but now the thing works! Thank you very much! -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX with Oracle 9 or 10G?
bret wrote: Me again- The org I work for is currently running Oracle 8.1.7 and is looking to upgrade. The question now is how does the new 10G Oracle version run with CFMX, and does it require custom JDBC drivers. Anyone have experience with this? I'm assuming Oracle 9 runs jim dandy on CFMX. So given the choice, what would y'all recommend? Obviously, I am not a DBA and have a relatively small amount of experience with Oracle, so any advice would be much appreciated. Thanks! Having very little experience myself, I can only say that most of the major sites at UC Davis are run with Cold Fusion MX against Oracle databases.I'm currently in the process of migrating our database from SQL-Server 7 to Oracle 9i, and aside from a few id10t errors, it seems to be working pretty well. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Cold Fusion and Oracle
The endless issues go on.Sigh. Does anyone know of a very good resource detailing the issues involved with hooking Cold Fusion up to Oracle? -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cold Fusion and Oracle
Kristopher Pilles wrote: What kind of issues are ya having?I have use CF and oracle together extensively... perhaps i can help Kristopher, I've posted about my issues before, but I'll happily do so again.:) I have a stored procedure written in PL/SQL, which I'm attempting to call from Cold Fusion, but only errors are generated. Here is the stored procedure: [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cold Fusion and Oracle
Richard Crawford wrote: Kristopher Pilles wrote: What kind of issues are ya having?I have use CF and oracle together extensively... perhaps i can help Kristopher, I've posted about my issues before, but I'll happily do so again.:) I have a stored procedure written in PL/SQL, which I'm attempting to call from Cold Fusion, but only errors are generated. Here is the stored procedure: Hm... My earlier post seems to have gotten truncated. Let's try again. Kristopher Pilles wrote: What kind of issues are ya having?I have use CF and oracle together extensively... perhaps i can help Kristopher, I've posted about my issues before, but I'll happily do so again.:) I have a stored procedure written in PL/SQL, which I'm attempting to call from Cold Fusion, but only errors are generated. Here is the stored procedure: === CREATE OR REPLACE procedure test_dlc_sp_getStudentInfo ( studentID IN number, studentInfo OUT types.cursorType ) as sFirst varchar2(50); sLast varchar2(50); sOrient char(1); begin open studentInfo for select sFirst, sLast, sOrient from tblStudentInfo where sid = studentID; fetch studentInfo into sFirst, sLast, sOrient; close studentInfo; end; / === Here is how I call the SP from Cold Fusion: === cfstoredproc datasource=DLCampus procedure=test_dlc_sp_getStudentInfo cfprocparam type=in value=1881 cfsqltype=cf_sql_number cfprocresult name=getName /cfstoredproc === At this point, I've trimmed the CF page down to just this little tiny snippet.If it works, it should generate no output at all, but I should be able to reference, say, sFirst like this later on in the same page: cfoutput query=getName#sFirst#/cfoutput or cfoutput#getName.sFirst#/cfoutput In older versions of CF, a result set from an Oracle SP would have to be referenced with a variable in the cfstoredproc section; with MX (which is what I'm using; not MX6.1), it's sufficient to reference a result set from an Oracle SP which is returned by a ref cursor with the cfprocresult attribute.I think I'm right about this, but I will happily accept that I'm wrong if it means that I can get this all working.;-) At any rate, when I try to execute the script, I get this error: === Error Executing Database Query. [Macromedia][Oracle JDBC Driver]Unsupported data conversion. === I don't know if this means that I'm experiencing a problem with the way I've written my stored procedure, the way I'm referencing it in Cold Fusion, or if I've got a problem with JDBC (I've got the native CFMX drivers referenced in my datasource definition in Cold Fusion). Any help would be more than appreciated.I'll send you a six-pack if you can help me figure out this problem.:-D -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cold Fusion and Oracle
Dave Watts wrote: I have a stored procedure written in PL/SQL, which I'm attempting to call from Cold Fusion, but only errors are generated. Here is the stored procedure: Unfortunately, it didn't come through. But anyway, have you tried calling this stored procedure from SQL*Plus? How about from another Java client? You might try using ViennaSQL, which I've found helpful for diagnosing problems occasionally. Yep, I've called it from SQL*Plus, and it works as expected. I'll look into ViennaSQL.I currently use the free version of TOAD, which doesn't (as far as I can tell) allow me to test stored procedures. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cold Fusion and Oracle
Doug Keen wrote: I've had similar issues when migrating a CF/Oracle app from CF 4.5 to CF 6.1.During that adventure I found this resource: http://www.blinex.com/~sam/CF_SQL_TYPES.cfm This chart maps CF_SQL_TYPE's to types specific to different database platforms, including Oracle.In your case, you might have some luck if you change you CF_SQL_NUMBER parameters to CF_SQL_FLOAT (it worked for me, and as that chart shows, it's a better match for Oracle's NUMBER type). Thanks for the suggestion.Unfortunately, I got the same error.I also tried cf_sql_decimal with the same result. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cold Fusion and Oracle
Nick Han wrote: Richard, I think in order to call an Oracle stored procedure through Cold Fusion, you need to create a package spec. Don't think you can solely reference the procedure name directly. Create a package spec and put your procedure in the package body.After you have done that, modify your calling code to cfstoredproc datasource=DLCampus procedure=PACKAGE_SPEC_NAME.PROCEDURE_NAME Procedure name in this case is test_dlc_sp_getStudentInfo Thanks for the tip.I've done that (I've been planning on putting all of our SP's into one or two packages anyway).Unfortunately, I got the same error when I tried again. Nick Han [EMAIL PROTECTED] 03/08/04 11:28AM Richard Crawford wrote: Kristopher Pilles wrote: What kind of issues are ya having?I have use CF and oracle together extensively... perhaps i can help Kristopher, I've posted about my issues before, but I'll happily do so again.:) I have a stored procedure written in PL/SQL, which I'm attempting to call from Cold Fusion, but only errors are generated. Here is the stored procedure: Hm... My earlier post seems to have gotten truncated. Let's try again. Kristopher Pilles wrote: What kind of issues are ya having?I have use CF and oracle together extensively... perhaps i can help Kristopher, I've posted about my issues before, but I'll happily do so again.:) I have a stored procedure written in PL/SQL, which I'm attempting to call from Cold Fusion, but only errors are generated. Here is the stored procedure: === CREATE OR REPLACE procedure test_dlc_sp_getStudentInfo ( studentID IN number, studentInfo OUT types.cursorType ) as sFirst varchar2(50); sLast varchar2(50); sOrient char(1); begin open studentInfo for select sFirst, sLast, sOrient from tblStudentInfo where sid = studentID; fetch studentInfo into sFirst, sLast, sOrient; close studentInfo; end; / === Here is how I call the SP from Cold Fusion: === cfstoredproc datasource=DLCampus procedure=test_dlc_sp_getStudentInfo cfprocparam type=in value=1881 cfsqltype=cf_sql_number cfprocresult name=getName /cfstoredproc === At this point, I've trimmed the CF page down to just this little tiny snippet.If it works, it should generate no output at all, but I should be able to reference, say, sFirst like this later on in the same page: cfoutput query=getName#sFirst#/cfoutput or cfoutput#getName.sFirst#/cfoutput In older versions of CF, a result set from an Oracle SP would have to be referenced with a variable in the cfstoredproc section; with MX (which is what I'm using; not MX6.1), it's sufficient to reference a result set from an Oracle SP which is returned by a ref cursor with the cfprocresult attribute.I think I'm right about this, but I will happily accept that I'm wrong if it means that I can get this all working.;-) At any rate, when I try to execute the script, I get this error: === Error Executing Database Query. [Macromedia][Oracle JDBC Driver]Unsupported data conversion. === I don't know if this means that I'm experiencing a problem with the way I've written my stored procedure, the way I'm referencing it in Cold Fusion, or if I've got a problem with JDBC (I've got the native CFMX drivers referenced in my datasource definition in Cold Fusion). Any help would be more than appreciated.I'll send you a six-pack if you can help me figure out this problem.:-D -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cold Fusion and Oracle
Doug Keen wrote: Is types.cursorType a REF CURSOR (not your plain-vanilla CURSOR)?If not, I think that may be another potential cause of your error... try changing types.cursorType to be a REF CURSOR and delete your FETCH ... INTO statement from the proc. Hm.It actually IS a REF CURSOR.I deleted the FETCH INTO line (actually, I just commented it out) per your suggestion, but that didn't help.Thanks for the tip. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cold Fusion and Oracle
Dave Watts wrote: I'll look into ViennaSQL.I currently use the free version of TOAD, which doesn't (as far as I can tell) allow me to test stored procedures. Well, the thing we want to test specifically is what happens when you call it through JDBC. I don't think TOAD uses JDBC. I downloaded and ran ViennaSQL and hooked it up to Oracle just fine from my computer over JDBC.I don't seem to be able to run stored procedures from the client, though. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cold Fusion and Oracle
Adrocknaphobia wrote: Use SQL*Plus to test your procedures. Thanks.I've done so, and they both compile and run fine.It's where I'm trying to return the ref cursor to Cold Fusion that it stops working. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cold Fusion and Oracle
Adrocknaphobia wrote: Sorry, missed the begining of the thread, why do you guys think its an issue with JDBC? Hi, Adam. This is the error message I've been receiving: Error Executing Database Query. [Macromedia][Oracle JDBC Driver]Unsupported data conversion. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cold Fusion and Oracle
Well, I altered the stored procedure as follows: = PROCEDURE test_dlc_sp_getStudentInfo ( studentID IN number ) as studentInfo types.cursorType; sFirst varchar2(50); sLast varchar2(50); sOrient char(1); begin open studentInfo for select sFirst, sLast, sOrient from tblStudentInfo where sid = studentID; CLOSE studentInfo; END test_dlc_sp_getStudentInfo; = Essentially, I removed the studentInfo ref cursor from the parameter list. Now, I run the Cold Fusion page, and the Unsupported Data Conversion error message is gone.Woo hoo! However, if I call the Stored Procedure from Cold Fusion like this: = cfstoredproc datasource=DLCampus procedure=dlc.test_dlc_sp_getStudentInfo cfprocparam type=in value=1881 cfsqltype=cf_sql_decimal cfprocresult name=getName /cfstoredproc = I would hope that I could get at the value of sOrient like this: cfoutput#getName.sOrient#/cfoutput Unfortunately, now I get a new error: = Element SORIENT is undefined in GETNAME = I don't know if I'm making progress or not. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cold Fusion and Oracle
It yields this error: Variable GETNAME is undefined Rob wrote: what does cfdump var=#getName# yield? On Mon, 2004-03-08 at 15:25, Richard Crawford wrote: Well, I altered the stored procedure as follows: = PROCEDURE test_dlc_sp_getStudentInfo ( studentID IN number ) as studentInfo types.cursorType; sFirst varchar2(50); sLast varchar2(50); sOrient char(1); begin open studentInfo for select sFirst, sLast, sOrient from tblStudentInfo where sid = studentID; CLOSE studentInfo; END test_dlc_sp_getStudentInfo; = Essentially, I removed the studentInfo ref cursor from the parameter list. Now, I run the Cold Fusion page, and the Unsupported Data Conversion error message is gone.Woo hoo! However, if I call the Stored Procedure from Cold Fusion like this: = cfstoredproc datasource=DLCampus procedure=dlc.test_dlc_sp_getStudentInfo cfprocparam type=in value=1881 cfsqltype=cf_sql_decimal cfprocresult name=getName /cfstoredproc = I would hope that I could get at the value of sOrient like this: cfoutput#getName.sOrient#/cfoutput Unfortunately, now I get a new error: = Element SORIENT is undefined in GETNAME = I don't know if I'm making progress or not. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Can someone recommend a good web development browser?
Kevin Graeme wrote: I usually develop with IE on a PC, but I would really like a browser that shows me the *time* taken to request each object in a web request. Also, if it could show me the http headers of the request and response, that would be sweet. I've currently got a page thats slow and I think its network latency, but I'm not sure what the best tool is for timing the response. There's got to be some good software out there for this task. While I prefer the Mozilla browsers and Opera technically, I find I always end up coming back to IE just because I have to make sure the site works for my 90%+ userbase. If I were to just spot test in IE I would miss something that I don't explicitly test for. I've been using Firefox for close to a year (and Mozilla before that); IE stopped being my default browser back in '01 when I realized it didn't have the features I wanted (e.g., reliability, standards compliance, tabbed browsing, built-in popup blocking, strict privacy controls, etc). There are a couple of features in FF that are absolutely essential.The JS console is a life safer -- much better at degugging than MS's tools. Also, there is an extension which will add View this page in IE to the context menu, so that on the rare occasions that you do need to view a page in IE, you can launch it straight from FF.It's been very helpful. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Oracle and Cold Fusion
Deanna Schneider wrote: Have you tried using GenericCursorType for your cursor type? That works for me. (I can give you a sample stored proc that's working for me, if that would be helpful.) I'd appreciate that.I tried using GenericCursorType, and the SP would not compile, throwing this error: === PLS-00201: identifier 'GENERICCURSORTYPE' must be declared === Here is how I tried to implement it: === CREATE OR REPLACE procedure dlc_sp_getStudentInfo ( studentID IN number, studentInfo OUT GenericCursorType ) === -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Oracle and Cold Fusion
Rob wrote: Did you figure out what datatype it is having problems with? i.e. only selecting one field at a time. Can it get just an int ok? All of the datatypes seem to match up just fine.I've gone out of my way to make them all match.If I remove the refcursor from the procedure call, then it gives an error telling me that the procresult is not defined. I mean you are selecting varchar2 and char in your refcursor have you just tried one or the other to see if it has a problem with just one of those datatypes - it's probably a conversion between what the drive says is a query and what cf thinks is a query, but I was hoping the Unsupported data conversion was refering to one of the column types. Hm.I tried with varchar2(50) at each point, and with char(50) at each point.Both gave me the same error. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Number of files in a directory
If I'm right, then this code snippet.. = cfdirectory directory=#pDir1# action="" name=daList sort=name filter=les* cfset p = #daList.RecordCount# = would return to p the number of files in the directory pDir1 where the filenames start with the characters les. Obviously, though, I'm not right, because p never gets a value other than 0. What am I doing wrong? -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Number of files in a directory - RESOLVED
Ben Doom wrote: Okay, yeah.That's way smarter than my suggestions.:-) --Ben Doom Nando wrote: Richard, I do this kind of stuff with a Q of Q, and it works well. cfdirectory returns a query. Maybe try that. Something like: cfdirectory directory=#pDir1# action="" name=daList cfquery name=daSortedList dbtype=query SELECT * FROM daList WHERE Type = 'File' AND Name Like 'les%' /cfquery cfset p = #daSortedList.RecordCount# check my syntax tho' ... Thanks to all who responded.Nando, your solution looks most like what we wound up doing.Heh. Actually, the problem I was experiencing was due to another issue entirely.I'll post about that in a moment. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Trimming a string after last instance of / character
Given a string that contains a directory name (e.g., /var/www/html/files/classes/admin), what is the best way to trim all of the characters off the last instance of the / character? -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Trimming a string after last instance of / character
Stevenson, Christopher wrote: Given a string that contains a directory name (e.g., /var/www/html/files/classes/admin), what is the best way to trim all of the characters off the last instance of the / character? listdeleteat(string, listlen(string, '/'), '/'); Or getDirectoryFromPath(string) That's very close to what I need.I need to ascend one directory level and then descend into a different directory. From: /directory/subdirectory/path1 to: /directory/subdirectory/path2 -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Trimming a string after last instance of / character - RESOLVED
This is what I used: cfset pathDir=#GetDirectoryFromPath(CGI.PATH_TRANSLATED)# cfset trimpathDir=listdeleteat(#pathDir#, listlen(#pathDir#,'/'), '/') / Adding the final / at the end turned out to be key. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Oracle and Cold Fusion
Still having issues. Here is the Stored Procedure in question: == CREATE OR REPLACE procedure dlc_sp_getStudentInfo ( studentID IN number, studentInfo OUT types.cursorType ) as sFirst varchar2(50); sLast varchar2(50); sOrient char(1); begin open studentInfo for select sFirst, sLast, sOrient from tblStudentInfo where sid = studentID; fetch studentInfo into sFirst, sLast, sOrient; close studentInfo; end; / == And here is where it is called in my Cold Fusion page: == cfstoredproc datasource=DLCampus procedure=dlc_sp_getStudentInfo cfprocparam type=in value=#cookieID# cfsqltype=cf_sql_number cfprocresult name=getName /cfstoredproc == In the database, the table tblStudentInfo is set up as this: == sID number sFirst varchar2(50) sLast varchar2(50) sOrient char(1) == When I execute the stored procedure by going to the CF page in a browser, I get the following error: == Error Executing Database Query. [Macromedia][Oracle JDBC Driver]Unsupported data conversion. == I'm still at a loss, and I can't see what else I can do.Anyone got any suggestions? -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Oracle and Cold Fusion
Rob wrote: Did you figure out what datatype it is having problems with? i.e. only selecting one field at a time. Can it get just an int ok? All of the datatypes seem to match up just fine.I've gone out of my way to make them all match.If I remove the refcursor from the procedure call, then it gives an error telling me that the procresult is not defined. On Mon, 2004-03-01 at 16:38, Richard Crawford wrote: Still having issues. Here is the Stored Procedure in question: == CREATE OR REPLACE procedure dlc_sp_getStudentInfo ( studentID IN number, studentInfo OUT types.cursorType ) as sFirst varchar2(50); sLast varchar2(50); sOrient char(1); begin open studentInfo for select sFirst, sLast, sOrient from tblStudentInfo where sid = studentID; fetch studentInfo into sFirst, sLast, sOrient; close studentInfo; end; / == And here is where it is called in my Cold Fusion page: == cfstoredproc datasource=DLCampus procedure=dlc_sp_getStudentInfo cfprocparam type=in value=#cookieID# cfsqltype=cf_sql_number cfprocresult name=getName /cfstoredproc == In the database, the table tblStudentInfo is set up as this: == sID number sFirst varchar2(50) sLast varchar2(50) sOrient char(1) == When I execute the stored procedure by going to the CF page in a browser, I get the following error: == Error Executing Database Query. [Macromedia][Oracle JDBC Driver]Unsupported data conversion. == I'm still at a loss, and I can't see what else I can do.Anyone got any suggestions? -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cold Fusion and Oracle Stored Procedures
Scott Brady wrote: Try swapping the last two cfprocparams.Assuming you're using CFMX, CFMX no longer uses the dbvarname attribute (at least for Oracle, not sure about other databases), so the order in which you provide the parameters needs to match the order they're defined in the procedure. In the procedure, you have success last, but in the CF you're listing studentID last. Scott, That fixed one issue.Thanks! -- Richard S. Crawford Programmer/Analyst III, UC Davis Extension Distance Learning Group (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cold Fusion and Oracle Stored Procedures
Thomas Chiverton wrote: On Monday 23 Feb 2004 23:37 pm, Richard Crawford wrote: more disturbing indications that Oracle Stored Procedures do not return result sets. I am investigating this today / yesterday. Using cfprocresult works, with Oracle 9i and CFMX6.1 under weblogic, using CFMX 'oracle' datasources. Some combination of WebLogic JNDI datasources and some beta MM drivers causes this to break, however. Our setup:Oracle 9i, CFMX, JRun, Apache.Weblogic doesn't seem to be involved in our servers. -- Richard S. Crawford Programmer/Analyst III, UC Davis Extension Distance Learning Group (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cold Fusion and Oracle Stored Procedures
Thomas Chiverton wrote: Solution: Use native CFMX drivers. Which is a shame :-( I dunno if it's worth putting in on the wish list... I figured out to return a ref cursor, and this appears to return a result set fine.However, now I'm getting an error reading, [Oracle JDBC Driver]Unsupported data conversion.The offending line that the CF processor shows has nothing to do with SP's, of course (in fact, it's a comment line).I'm using CFMX's native drivers to talk to Oracle -- or, at least, I believe I am. Oh, the humanity! -- Richard S. Crawford Programmer/Analyst III, UC Davis Extension Distance Learning Group (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
