RE: Looping....again
You need the quotes. CFHTTP should take care of them! Pascal -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: 22 September 2004 04:04 To: CF-Talk Subject: RE: Loopingagain i think 1st thing to do is run a script to get rid of all the quotes probably use the replace function [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Looping....again
I'm coming in late, so maybe you already have a solution. This should help you create your prescriptions. I would create an array of prescriptions (not in the code). Each prescription should be a structure of patient info, doc info and an array of drug info. cfhttp url="" name=q1 textqualifier= delimiter=,/ cfquery dbtype=query name=q2 SELECT * FROM q1 ORDER BY PMEDICARE, SDOCPRESNO /cfquery cfoutput query=q2 group=PMEDICARE cfoutput group=SDOCPRESNO cfset count = 1 cfoutput cfif count MOD 3 IS 1 !--- Do what you need to do to start a new prescription --- cfelse !--- Add to current prescription --- /cfif cfset count = count + 1 /cfoutput /cfoutput /cfoutput Prescription (struct): - doctor (struct) - name (string) - ... - patient (struct) - name (string) - ... - drugs (array) 1. (struct) - name (string) - ... 2. (struct) - name (string) - ... Pascal -Original Message- From: Brant Winter [mailto:[EMAIL PROTECTED] Sent: 21 September 2004 07:25 To: CF-Talk Subject: Loopingagain The hard part is: Each structure / array of drugs making up a script can only have 3 drugs on it, so I my patient has 5 drugs prescribed on that day I need 2 structures, one with 3 drugs on it, the other with 2. Can someone help me with the looping constructs ??? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Looping....again
dave wrote: i think 1st thing to do is run a script to get rid of all the quotes probably use the replace function Not neccessary Thats what the textdelimiter attribute of CFHTTP is for. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Prepared Statements in CFMX
Well, it does do the same thing. The only difference is that you use cfquery instead of using the JDBC API directly.In fact, if you use cfqueryparam, the database turns your query is turned into a prepared statement the first time it is called and sends back a handle to the JDBC driver.For all subsequent calls to that query, only the handle and the bound parameters are sent to the database--not the entire query. On Tue, 21 Sep 2004 22:59:41 -0400, Joe Eugene [EMAIL PROTECTED] wrote: Yes, i have looked at cfQueryParam. I dont think it works the same as below. http://java.sun.com/j2se/1.4.2/docs/api/java/sql/PreparedStatement.html Joe Eugene -Original Message- From: Matthew Fusfield [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 21, 2004 9:28 PM To: CF-Talk Subject: Re: Prepared Statements in CFMX Have you looked into CFQUERYPARAM ? It allows you to do parameterized queries and does type checking. Matt On Tue, 21 Sep 2004 21:03:42 -0400, Joe Eugene [EMAIL PROTECTED] wrote: Is there an easy way to execute a Prepared Statements directly in CFMX? i.e Using the API via cfscript, just like java prepared statements? Thanks, Joe Eugene [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Looping....again
Brant, My CFX_PDF tag don't work inside the loops though :-( so I think I am gonna have to go back to trying to build this data into another set of DB tables, but each drug given a script number so that I can then query the data based on the doctors name, and then build the scripts again, but with a less complex looping structure, so as to be able to include the cfx_pdf tags. OK - Here's a suggestionYou'll have to have a play to work out the best way to do this... Use CFSAVECONTENT to save the output from the cfloop through the data and then pass the contents of the cfsavecontent variable to your CFX_PDF tag after the end of the loop. As I have stated, I think I need to get this data back into a DB table, and mark each drug to belong to a unique script number? The doctors can then logon, and I can again run a query of querys to get the data out. If thats the case, then youneed only do a simple loop through the query generated from the CSV file and insert each record in turn into the database.When you insert each record you are going to want to split the data into multiple tables, one for the patient, one for the medication and one to link the paitent to the medication along with the other information specific to that item on this patients script. ie. pdocpresno, sqty,srpts etc.NOTE. It may not be feasible to spilt the medications out into a seperate table, so one table for patient and one for script rows will suffice. When a doctor logs in, give him a means to search for and select a patient, then you need only query the database for that one patient and their script records.When you output the data for cfx_pdf you will still need a loop much like the one I or Pascal created for you, to make sure you only get 3 lots of medication on a script. Which ever way you do this, don't bother inserting everything into a struct/array and then inserting it into a database or outputing it to cfx_pgp.Its just another brain drain and loop that isn't really required. As a total aside:Remember that you are storing personal information in a database.You will need to make sure that the practice's Data Protection subscription allows you to do this.If you are, then security of this data is of absolute paramount. Hope this all helps Regards Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Seeking Italian CF brain
Hi all, I'm in semi-urgent need of a CF developer, who's: - Italian - speaks (or at least writes) English well - experienced with integrating Gestpay and Mobilmat payment processing into a CF site I don't speak any Italian, but I'm building a CF site for an Italian client in Italy, and have a really hard time figuring out the payment processing side of things. It's virtually impossible to understand all the various documentation and Web sites. Machine translation has a long way to go in that respect. So, I need help, someone to be my Italian brain and to hold my hand through this, help me to successfully integrate Gestpay and Mobilmat into my CF site, whatever it involves, configuring the Sellanet/Gestpay stuff, writing/supplying working CF code, debugging and troubleshooting etc. It's nothing major, for someone who has worked with Gestpay before, it's probably a piece of cake, but with my Italian skills, it's one seriously major challenge. I'll naturally pay for your help. If you're interested, please drop me an email at jack (at) dalaa (dot) com Thanks! Jack [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Tiem Format problems
hi I'm trying to pull a date/time from a database then add 17 hours to it and display in dd mmm h n format I thought I could add 17 hours to the date using DateAdd but this seems to have problems with the format and I can't work out how to get the time to be plus 17 hours Or is there a way to add 17 hours to the date in the database? Help please Seamus Seamus CampbellBoldacious WebDesign http://www.boldacious.com[EMAIL PROTECTED] ph 02 6297 4883mob 0410 609 267 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Tiem Format problems
Hi. This works. cfset plus17h = DateAdd(h, 17, now()) cfoutput #DateFormat(plus17h, dd/mm/)# #TimeFormat(plus17h, HH:MM)# /cfoutput Andrew - Original Message - From: Seamus Campbell [EMAIL PROTECTED] Date: Wed, 22 Sep 2004 19:36:48 +1000 Subject: Tiem Format problems To: CF-Talk [EMAIL PROTECTED] hi I'm trying to pull a date/time from a database then add 17 hours to it and display in dd mmm h n format I thought I could add 17 hours to the date using DateAdd but this seems to have problems with the format and I can't work out how to get the time to be plus 17 hours Or is there a way to add 17 hours to the date in the database? Help please Seamus Seamus CampbellBoldacious WebDesign http://www.boldacious.com[EMAIL PROTECTED] ph 02 6297 4883mob 0410 609 267 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Tiem Format problems
Or is there a way to add 17 hours to the date in the database? What database are you using? -- Jay [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
[Reply To] Re: Tiem Format problems
thanks (wow very quick reply!) however I get this message when I try and use my date in the database ( rather than Now() ). Entity has incorrect type for being called as a function. The symbol you have provided date_last_modified is not the name of a function. Any clues? You wrote Hi. This works. cfset plus17h = DateAdd(h, 17, now()) cfoutput #DateFormat(plus17h, dd/mm/)# #TimeFormat(plus17h, HH:MM)# /cfoutput Andrew - Original Message - From: Seamus Campbell [EMAIL PROTECTED] Date: Wed, 22 Sep 2004 19:36:48 +1000 Subject: Tiem Format problems To: CF-Talk [EMAIL PROTECTED] hi I'm trying to pull a date/time from a database then add 17 hours to it and display in dd mmm h n format I thought I could add 17 hours to the date using DateAdd but this seems to have problems with the format and I can't work out how to get the time to be plus 17 hours Or is there a way to add 17 hours to the date in the database? Help please Seamus Seamus CampbellBoldacious WebDesign http://www.boldacious.com[EMAIL PROTECTED] ph 02 6297 4883mob 0410 609 267 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
[Reply To] RE: Tiem Format problems
Access You wrote Or is there a way to add 17 hours to the date in the database? What database are you using? -- Jay [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: [Reply To] RE: Tiem Format problems
Is your data and a date or a datetime? Andrew. - Original Message - From: Seamus Campbell [EMAIL PROTECTED] Date: Wed, 22 Sep 2004 20:05:10 +1000 Subject: [Reply To] RE: Tiem Format problems To: CF-Talk [EMAIL PROTECTED] Access You wrote Or is there a way to add 17 hours to the date in the database? What database are you using? -- Jay [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: [Reply To] RE: Tiem Format problems
Actually what do get if you do cfoutput of the date field without any formatting? Andrew. On Wed, 22 Sep 2004 11:46:35 +0100, Andrew Dixon [EMAIL PROTECTED] wrote: Is your data and a date or a datetime? Andrew. - Original Message - From: Seamus Campbell [EMAIL PROTECTED] Date: Wed, 22 Sep 2004 20:05:10 +1000 Subject: [Reply To] RE: Tiem Format problems To: CF-Talk [EMAIL PROTECTED] Access You wrote Or is there a way to add 17 hours to the date in the database? What database are you using? -- Jay [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
[Reply To] Re: [Reply To] RE: Tiem Format problems
It's Date/Time in Access Ta seamus You wrote Is your data and a date or a datetime? Andrew. - Original Message - From: Seamus Campbell [EMAIL PROTECTED] Date: Wed, 22 Sep 2004 20:05:10 +1000 Subject: [Reply To] RE: Tiem Format problems To: CF-Talk [EMAIL PROTECTED] Access You wrote Or is there a way to add 17 hours to the date in the database? What database are you using? -- Jay [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
[Reply To] Re: [Reply To] RE: Tiem Format problems
2004-09-21 22:06:13.0 Ta Seamus You wrote Actually what do get if you do cfoutput of the date field without any formatting? Andrew. On Wed, 22 Sep 2004 11:46:35 +0100, Andrew Dixon [EMAIL PROTECTED] wrote: Is your data and a date or a datetime? Andrew. - Original Message - From: Seamus Campbell [EMAIL PROTECTED] Date: Wed, 22 Sep 2004 20:05:10 +1000 Subject: [Reply To] RE: Tiem Format problems To: CF-Talk [EMAIL PROTECTED] Access You wrote Or is there a way to add 17 hours to the date in the database? What database are you using? -- Jay [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Tiem Format problems
This works in cfmx 6.1 cfset date = 2004-09-21 22:06:13.0 cfset plus17h = DateAdd(h, 17, date) cfoutput #DateFormat(plus17h, dd mmm )# #TimeFormat(plus17h, HH:MM)# /cfoutput It doesn't work on CF5 though (it fails on the .0) On cf5 you could do a workaround cfset date = 2004-09-21 22:06:13.0 cfset date = REReplace(date,\.0$,) cfset plus17h = DateAdd(h, 17, date) Pascal -Original Message- From: Seamus Campbell [mailto:[EMAIL PROTECTED] Sent: 22 September 2004 13:27 To: CF-Talk Subject: [Reply To] Re: [Reply To] RE: Tiem Format problems 2004-09-21 22:06:13.0 Ta Seamus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: relational display
Well, I didn't actually write any queries using your naming conventions before. ;) I wasn't trying to be rough, just offering an opinion. Naming conventions are something of a religion for some people, and I'm not of that camp. But, I do find that being clear and consistent helps tremendously. If you want just one poll, you can easily add another line to the where clause. Just add: AND p.p_id = yourdesiredpollidhere - Original Message - From: daniel kessler dang Deanna, after all this time and help that you've given me, you tell me NOW that you loathe my naming conventions?Loathe is pretty rough. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: relational display
Dan, Let's walk through what the query is doing SELECT p.p_question, a.pa_answer, COUNT(r.pv_poll_answer) AS total !--- Get each question, each answer, and the total number of responses for each answer --- FROM fsnep_polls p, fsnep_pollAnswers a, fsnep_pollresults r !--- we're gathering info from these three tables --- WHERE p.p_id = a.pa_pollID !--- The pollid in your poll table should be the same poll id in your answer table, so that answers are linked with the poll --- ANDa.pa_id = r.pv_poll_answer !--- The answerid in your answer table should be the same answerid as in your results table, so that we can count how many results go with each answer --- ANDp.p_id = 21 !--- You add an extra where clause if you want a specific poll - this will filter out the answers and results from the other polls, because of the joins above --- GROUP BY p.p_question, a.pa_answer !--- For the totals, we want to make sure that we're counting the total for each question for each poll, not totalling all the answers together --- ORDER BY p.p_question, a.pa_answer !--- We need to order this way so that the CF output will group correctly --- (I looked at the output and it looks like you already figured this out. But, so you have the answer I've been away for a couple of days. Sorry.) - Original Message - From: daniel kessler well, I'm still a bit confused. Using your query, which I mostly understand, both of the two test polls that I have come up http://eatsmart.umd.edu/home/poll_results.cfm?poll=21 though with the correct counts.Unfortunately I only want the one that matches the poll ID.I tried changing out: WHERE p.p_id = a.pa_pollID for WHERE p.p_id = 21 !--- a known poll id --- and in that case it brings up only one poll, but when I add up the answer counts they're the total number for the two polls. Still, I don't know why more than one poll comes up initially, nor have I figured out how to make the poll counts accurate when I make sure there's only one poll queried by inserting the poll ID. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Verity
Hey all, We've decided to finally try verity as the search on our client sites.I can create and index site files and queries, but am lost on how to organize it all.Should I create a separate collection for each database table I want to index or simply use a custom field to put the type of record that it is i.e. News,FAQ, etc to help me when outputting a link to it.What's the best way to exclude files such as my admin pages etc.Any help would be great. Thanks, Trevor Holm-Laursen eBusiness Developer, FCS Direct:(902)463-5953 FCS (Fundy Computer Services Ltd.) Tel 877-993-8636 Fax 902-484-5887 Email:[EMAIL PROTECTED] Website:http://www.fcs.ca [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
[Reply To] RE: Tiem Format problems
Fantastic - thanks very much Seamus You wrote This works in cfmx 6.1 cfset date = 2004-09-21 22:06:13.0 cfset plus17h = DateAdd(h, 17, date) cfoutput #DateFormat(plus17h, dd mmm )# #TimeFormat(plus17h, HH:MM)# /cfoutput It doesn't work on CF5 though (it fails on the .0) On cf5 you could do a workaround cfset date = 2004-09-21 22:06:13.0 cfset date = REReplace(date,\.0$,) cfset plus17h = DateAdd(h, 17, date) Pascal -Original Message- From: Seamus Campbell [mailto:[EMAIL PROTECTED] Sent: 22 September 2004 13:27 To: CF-Talk Subject: [Reply To] Re: [Reply To] RE: Tiem Format problems 2004-09-21 22:06:13.0 Ta Seamus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
windows, services, and the JMC
We are using the J2EE way on JRunI noticed an issue that maybe some of you can comment on.If I start the CF server via the JRun JMC it does not seem to start the registered service as seen in the windows services MMC.Actually, I can have two jrun.exe processes for the same CF server!I just found this on MACR Note: When using a Windows service for JRun, users should start servers from the Windows Control Panel, not the JMC.When starting and stopping remote servers through the JMC, do not use Windows services unless all the servers are installed in the Control Panel with the [-norestart] switch.The Windows service startup type is set toautomatic by default, which means a reboot restarts server without using the JMC. Anyone care to comment have some best practise advice? -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: dynamic maps (GIS and other acronyms)
On Wednesday 22 Sep 2004 03:21 am, Matt Liotta wrote: What library do I use to create the vector graphics? We use one from http://www.walterzorn.com/jsgraphics/jsgraphics_e.htm (typicaly, this site is down atm :-)). We're doing basicaly the same thing - retrive a map from a map server and then draw lines over it, to represent a 'zone'. Where do I get the maps I am layering the graphics on? There are a few companies out there that will provide this as a web service, or you can investigate things based on OpenGIS - such as http://geoserver.sourceforge.net/ -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Session variable works one line and not another?
Can anyone please help me work out why the second line would ever fail with the message Element REPLICANT is undefined in SESSION.? cfif StructKeyExists(Session, Replicant)cfif IsStruct(Session.Replicant) cfif StructKeyExists(Session.Replicant, Name)h4#Session.Replicant.Name#/h4/cfif /cfif I thought the above was rock-solid code, but apparently not.This fails once-in-a-while but is not reproducable as best as I can tell. Any help would be appreciated. -- *Damien McKenna* - Web Developer - [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 Nothing endures but change. - Heraclitus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: HTTPS Upload of a file.
So does anyone know of a command line application for https upload? -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: 21 September 2004 16:10 To: CF-Talk Subject: RE: HTTPS Upload of a file. That is something I want to avoid as there is no way of referencing the parts. This would mean that is one of the files failed once it reached Amazon it would be a huge task to figure out which part to re-upload. -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: 21 September 2004 15:33 To: CF-Talk Subject: Re: HTTPS Upload of a file. On Tuesday 21 Sep 2004 14:12 pm, James Smith wrote: Sorry, I was a bit vague. Can you break the file up into chunks of 300 products ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
ot: sql question
is it true that we cannot use go in sql statements using cfquery? -- tony Tony Weeg macromedia certified cold fusion developer email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ cool tool: http://www.antiwrap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: sql question
correct (if you mean for sql server) is it true that we cannot use go in sql statements using cfquery? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: HTTPS Upload of a file.
On Wednesday 22 Sep 2004 14:55 pm, James Smith wrote: So does anyone know of a command line application for https upload? Well, curl :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: sql question
I don't think so no, but GO is not required in SQL, it can be ommited. _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 22 September 2004 14:59 To: CF-Talk Subject: ot: sql question is it true that we cannot use go in sql statements using cfquery? -- tony Tony Weeg macromedia certified cold fusion developer email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ cool tool: http://www.antiwrap.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Zip files
I know there is a library in Cold Fusion Mx - ZipfileNew to zip files from a folder. I am trying to do the same inCold fusion 5.0. Does anyone know if this can be done?? Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: sql question
it cant be ommitted when creating a view and you do that from a single dsn in cfmx and you have to reference the database. CREATE VIEW must be first in the sql statement, unless its preceded by a GO heres what im doing... we are using a distributed partitioned view, and when we make table column changes we have to drop the view and create it again we want to make a cfmx routine that will destruct the views on all databases, add the new column to all the tables, then recreate the view all from 1 dsn. here is what works in sql: use dpvEven_2 if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[view_dpvReports]') and OBJECTPROPERTY(id, N'IsView') = 1) drop view [dbo].[view_dpvReports] go USE dpvEven_2 go CREATE VIEW view_dpvReports AS SELECT * FROM dpv1.dpvOdd_1.dbo.reports1 UNION ALL SELECT * FROM dpv1.dpvOdd_3.dbo.reports3 UNION ALL SELECT * FROM dpv1.dpvOdd_5.dbo.reports5 UNION ALL SELECT * FROM dpv1.dpvOdd_7.dbo.reports7 UNION ALL SELECT * FROM dpv1.dpvOdd_9.dbo.reports9 UNION ALL SELECT * FROM dpv1.dpvOdd_11.dbo.reports11 UNION ALL SELECT * FROM dpv2.dpvEven_2.dbo.reports2 UNION ALL SELECT * FROM dpv2.dpvEven_4.dbo.reports4 UNION ALL SELECT * FROM dpv2.dpvEven_6.dbo.reports6 UNION ALL SELECT * FROM dpv2.dpvEven_8.dbo.reports8 UNION ALL SELECT * FROM dpv2.dpvEven_10.dbo.reports10 UNION ALL SELECT * FROM dpv2.dpvEven_12.dbo.reports12 go but that doesnt work from cfmx in a cfquery tag. im thinking i just might use some stored procedures for this... unless anyone can think of another way. thanks! Tony Weeg macromedia certified cold fusion developer email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ cool tool: http://www.antiwrap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: HTTPS Upload of a file.
I am assuming you have read the first few messages in this thread and are being sarcastic, if so then Ho ho ho ho ho ho ho ho ho ho ho ho ho ho ho ho ho ho ho ;-) -- Jay -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: 22 September 2004 15:09 To: CF-Talk Subject: Re: HTTPS Upload of a file. On Wednesday 22 Sep 2004 14:55 pm, James Smith wrote: So does anyone know of a command line application for https upload? Well, curl :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: sql question
Well, really it should be an SP. _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 22 September 2004 15:34 To: CF-Talk Subject: Re: sql question it cant be ommitted when creating a view and you do that from a single dsn in cfmx and you have to reference the database. CREATE VIEW must be first in the sql statement, unless its preceded by a GO heres what im doing... we are using a distributed partitioned view, and when we make table column changes we have to drop the view and create it again we want to make a cfmx routine that will destruct the views on all databases, add the new column to all the tables, then recreate the view all from 1 dsn. here is what works in sql: use dpvEven_2 if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[view_dpvReports]') and OBJECTPROPERTY(id, N'IsView') = 1) drop view [dbo].[view_dpvReports] go USE dpvEven_2 go CREATE VIEW view_dpvReports AS SELECT * FROM dpv1.dpvOdd_1.dbo.reports1 UNION ALL SELECT * FROM dpv1.dpvOdd_3.dbo.reports3 UNION ALL SELECT * FROM dpv1.dpvOdd_5.dbo.reports5 UNION ALL SELECT * FROM dpv1.dpvOdd_7.dbo.reports7 UNION ALL SELECT * FROM dpv1.dpvOdd_9.dbo.reports9 UNION ALL SELECT * FROM dpv1.dpvOdd_11.dbo.reports11 UNION ALL SELECT * FROM dpv2.dpvEven_2.dbo.reports2 UNION ALL SELECT * FROM dpv2.dpvEven_4.dbo.reports4 UNION ALL SELECT * FROM dpv2.dpvEven_6.dbo.reports6 UNION ALL SELECT * FROM dpv2.dpvEven_8.dbo.reports8 UNION ALL SELECT * FROM dpv2.dpvEven_10.dbo.reports10 UNION ALL SELECT * FROM dpv2.dpvEven_12.dbo.reports12 go but that doesnt work from cfmx in a cfquery tag. im thinking i just might use some stored procedures for this... unless anyone can think of another way. thanks! Tony Weeg macromedia certified cold fusion developer email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ cool tool: http://www.antiwrap.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Zip files
cfexecute I think is your option for this one and get the zip.exe for dos? MD On Wed, 22 Sep 2004 10:30:18 -0400, Sudha Prasannappa [EMAIL PROTECTED] wrote: I know there is a library in Cold Fusion Mx - ZipfileNew to zip files from a folder. I am trying to do the same inCold fusion 5.0. Does anyone know if this can be done?? Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Zip files
Cfx_zip www.forta.com _ From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: 22 September 2004 15:39 To: CF-Talk Subject: Re: Zip files cfexecute I think is your option for this one and get the zip.exe for dos? MD On Wed, 22 Sep 2004 10:30:18 -0400, Sudha Prasannappa [EMAIL PROTECTED] wrote: I know there is a library in Cold Fusion Mx - ZipfileNew to zip files from a folder. I am trying to do the same inCold fusion 5.0. Does anyone know if this can be done?? Thanks. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Zip files
I seem to remember Ben having written a custom tag for CF4 for zipping files and directories but I don't seem to be able to find it, anyone else remember or am I imagining it? -- Jay -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: 22 September 2004 15:39 To: CF-Talk Subject: Re: Zip files cfexecute I think is your option for this one and get the zip.exe for dos? MD On Wed, 22 Sep 2004 10:30:18 -0400, Sudha Prasannappa [EMAIL PROTECTED] wrote: I know there is a library in Cold Fusion Mx - ZipfileNew to zip files from a folder. I am trying to do the same inCold fusion 5.0. Does anyone know if this can be done?? Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: dynamic maps (GIS and other acronyms)
Alternatives to Thomas' suggestion which is a _javascript_ library that draws vectors by using many divs or layers to represent pixels and groups of pixels options for drawing vectors client side include: VML - (IE 5.0+ with the VML option installed) SVG - (requires plugin from Adobe) Flash -(requires Macromedia Flash plugin) If you want your maps to be more accessible then draw the vectors server side. There are graphic libraries and applications to assist you with this. A couple of suggestions would be to look at: ImageMagick - http://www.imagemagick.org/ http://www.cit.gu.edu.au/~anthony/graphics/imagick6/draw/ There is also a coldfusion custom tag MagickTag which wraps ImageMagick at http://www.alagad.com/index.cfm/name-products Java 2D API - http://java.sun.com/products/java-media/2D/ Google directory - Computers Programming Graphics Libraries http://directory.google.com/Top/Computers/Programming/Graphics/Libraries/ As far as the GIS side of things it may make things easier to avoid using one entirely. If the only dynamic part of your maps will be the vectors you draw over them then you can just use static maps to start with. For maps try: GeoConnections(canada) http://geodiscover.cgdi.ca/gdp/index.jsp?language=en USGS http://edc.usgs.gov/geodata/ Geography Network http://www.geographynetwork.com/ -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: September 22, 2004 9:49 AM To: CF-Talk Subject: Re: dynamic maps (GIS and other acronyms) On Wednesday 22 Sep 2004 03:21 am, Matt Liotta wrote: What library do I use to create the vector graphics? We use one from http://www.walterzorn.com/jsgraphics/jsgraphics_e.htm (typicaly, this site is down atm :-)). We're doing basicaly the same thing - retrive a map from a map server and then draw lines over it, to represent a 'zone'. Where do I get the maps I am layering the graphics on? There are a few companies out there that will provide this as a web service, or you can investigate things based on OpenGIS - such as http://geoserver.sourceforge.net/ -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: dynamic maps (GIS and other acronyms)
The problem isn't drawing the vectors; it is drawing them in context of the map. For example, drawing a circle with a radius of 1 mile with a center of x/y (lat/long). -Matt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Beal, Jason Sent: Wednesday, September 22, 2004 10:55 AM To: CF-Talk Subject: RE: dynamic maps (GIS and other acronyms) Alternatives to Thomas' suggestion which is a _javascript_ library that draws vectors by using many divs or layers to represent pixels and groups of pixels options for drawing vectors client side include: VML - (IE 5.0+ with the VML option installed) SVG - (requires plugin from Adobe) Flash -(requires Macromedia Flash plugin) If you want your maps to be more accessible then draw the vectors server side. There are graphic libraries and applications to assist you with this. A couple of suggestions would be to look at: ImageMagick - http://www.imagemagick.org/ http://www.cit.gu.edu.au/~anthony/graphics/imagick6/draw/ There is also a coldfusion custom tag MagickTag which wraps ImageMagick at http://www.alagad.com/index.cfm/name-products Java 2D API - http://java.sun.com/products/java-media/2D/ Google directory - Computers Programming Graphics Libraries http://directory.google.com/Top/Computers/Programming/Graphics/Libraries/ As far as the GIS side of things it may make things easier to avoid using one entirely. If the only dynamic part of your maps will be the vectors you draw over them then you can just use static maps to start with. For maps try: GeoConnections(canada) http://geodiscover.cgdi.ca/gdp/index.jsp?language=en USGS http://edc.usgs.gov/geodata/ Geography Network http://www.geographynetwork.com/ -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: September 22, 2004 9:49 AM To: CF-Talk Subject: Re: dynamic maps (GIS and other acronyms) On Wednesday 22 Sep 2004 03:21 am, Matt Liotta wrote: What library do I use to create the vector graphics? We use one from http://www.walterzorn.com/jsgraphics/jsgraphics_e.htm (typicaly, this site is down atm :-)). We're doing basicaly the same thing - retrive a map from a map server and then draw lines over it, to represent a 'zone'. Where do I get the maps I am layering the graphics on? There are a few companies out there that will provide this as a web service, or you can investigate things based on OpenGIS - such as http://geoserver.sourceforge.net/ -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT: JS Gateway Question
Hi Mike,
Did you check with Dan Switzer? Does he have a yahoo group for the
gateway as he does for qForms?
Dan
- Original Message -
From: Tangorre, Michael [EMAIL PROTECTED]
Date: Tue, 21 Sep 2004 17:31:37 -0400
Subject: OT: JS Gateway Question
To: CF-Talk [EMAIL PROTECTED]
I am still in search of a solution to a problem I had a few weeks back.
This is OT for the CF list, but I am hoping someone here has used the JS
Gateway from www.pengoworks.com.
I have a form with a bunch of select boxes on it that I use qForms to
populate, etc (from a DB.. use ColdFusion to loop etc...). I also use
the JS Gateway for two of the select boxes; lets call them A and B.
When the page initially loads everything works fine.. A populates fine
and when a user selects something in A, B populates fine (using
Gateway). The issue I have is that when the user comes back into the
form after saving the form, how can I get A and B populated since
they rely on the Gateway for initial population as well as obtaining the
values for B from A?
I have tried everything from setting the value for the A select after
the loadOptions() method loads the options etc, but I keep finding
myself in this infinite loop or getting out of memory errors etc. Do you
know how I could accomplish getting A populated and set with the value
from the DB then get B set based on A, finally setting the value of
B set with the value from that comes from the DB (if there is one of
course). I have come back to this problem many times, always failing to
find a solution.
Anyone using the Gateway and have some suggestions? In case it helps,
the following are the Gateway functions that are used:
Thanks!
-Mike
// Gateway Init() function
function init(){
objGateway.>
document.basicDataForm.strAgency.length = 1;
document.basicDataForm.strBureau.length = 1;
loadOptions(strAgency);
}
// Gateway populate() function
function populate(f, a){
var oField = document.basicDataForm[f];
oField.options.length = 0;
for( var i=0; i a.length; i++ ) oField.options[oField.options.length]
= new Option(a[i][0], a[i][1]);
}
// Gateway loadOptions() function
function loadOptions(f){
var d = {}, oForm = document.basicDataForm;
if( f == strAgency ){
document.basicDataForm.strAgency.length = 1;
}
var sAgency =
oForm.strAgency.options[oForm.strAgency.options.selectedIndex].value;
displayLoadMsg(f);
objGateway.sendPacket({field: f, strAgency: sAgency});
}
// Gateway updateOptins() function
function updateOptions(){
if( this.received == null ) return false;
populate(this.received[0], this.received[1]);
return true;
}
// Gatewaye displayLoadMsg() function
function displayLoadMsg(f){
var oField = document.basicDataForm[f];
oField.options.length = 0;
oField.options[oField.options.length] = new Option(Loading data...,
);
}
// Create the gateway object
objGateway.create();
// Initialize the gateway object
init();
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: sql question
I wonder if SQLBATCHER on CFLIB may help - just looked at this this morning! http://www.cflib.org/udf.cfm?id=1127 On Wed, 22 Sep 2004 10:33:55 -0400, Tony Weeg [EMAIL PROTECTED] wrote: it cant be ommitted when creating a view and you do that from a single dsn in cfmx and you have to reference the database. CREATE VIEW must be first in the sql statement, unless its preceded by a GO heres what im doing... we are using a distributed partitioned view, and when we make table column changes we have to drop the view and create it again we want to make a cfmx routine that will destruct the views on all databases, add the new column to all the tables, then recreate the view all from 1 dsn. here is what works in sql: use dpvEven_2 if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[view_dpvReports]') and OBJECTPROPERTY(id, N'IsView') = 1) drop view [dbo].[view_dpvReports] go USE dpvEven_2 go CREATE VIEW view_dpvReports AS SELECT * FROM dpv1.dpvOdd_1.dbo.reports1 UNION ALL SELECT * FROM dpv1.dpvOdd_3.dbo.reports3 UNION ALL SELECT * FROM dpv1.dpvOdd_5.dbo.reports5 UNION ALL SELECT * FROM dpv1.dpvOdd_7.dbo.reports7 UNION ALL SELECT * FROM dpv1.dpvOdd_9.dbo.reports9 UNION ALL SELECT * FROM dpv1.dpvOdd_11.dbo.reports11 UNION ALL SELECT * FROM dpv2.dpvEven_2.dbo.reports2 UNION ALL SELECT * FROM dpv2.dpvEven_4.dbo.reports4 UNION ALL SELECT * FROM dpv2.dpvEven_6.dbo.reports6 UNION ALL SELECT * FROM dpv2.dpvEven_8.dbo.reports8 UNION ALL SELECT * FROM dpv2.dpvEven_10.dbo.reports10 UNION ALL SELECT * FROM dpv2.dpvEven_12.dbo.reports12 go but that doesnt work from cfmx in a cfquery tag. im thinking i just might use some stored procedures for this... unless anyone can think of another way. thanks! Tony Weeg macromedia certified cold fusion developer email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ cool tool: http://www.antiwrap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Query/DB design problem
I recently asked how to structure a query to request poll results from my db. I've listed the db structure and the query below. The problem that I now have is that it only lists poll answers that have been answered once.I know that this is because it's querying the Results table (fsnep_pollresults) and that if there are answers that have not been selected, then they won't show up in the results table. I don't know of a good, clean way of making this query includethem. The only way I know to do it is to get a list of the answers and set up a query that looks for the count of each of the answers.So if there are 5 answers, I'll have 5 queries.It sounds like a resource hog to me. Any thoughts? Query: cfquery name=poll_results datasource=eatsmart SELECT p.p_id,p.p_question, a.pA_answer, COUNT(r.pV_poll_answer) AS total FROM fsnep_polls p, fsnep_pollAnswers a, fsnep_pollresults r WHERE p.p_id = a.pA_pollID AND a.pA_id = r.pV_poll_answer AND p.p_id = #url.poll# GROUP BY p.p_question, a.pA_answer, p.p_id ORDER BY p.p_question, a.pA_answer, p.p_id /cfquery Tables: !--- a list of polls.Write to db once for each answer and then group on display.--- create table fsnep_polls ( p_id NUMBER Primary Key, p_date_added date, p_date_last_used date, p_question VARCHAR2(400), p_category VARCHAR2(400), p_status NUMBER ) !--- all possible answers for any poll available --- create table fsnep_pollAnswers ( pA_id NUMBER Primary Key, pA_pollID NUMBER REFERENCES fsnep_polls(p_id) ON DELETE CASCADE, pA_answer VARCHAR2(400) ) !--- all votes with their poll and answer ID --- create table fsnep_pollResults ( pV_id NUMBER Primary Key, pV_date_added date, pV_poll_id NUMBER REFERENCES fsnep_polls(p_id), pV_poll_Answer NUMBER REFERENCES fsnep_pollAnswers(pA_id) ON DELETE CASCADE, pV_ip VARCHAR2(20) ) !--- all comments with their poll ID --- create table fsnep_pollComments ( pc_id NUMBER Primary Key, pc_date_added date, pc_poll_id NUMBER REFERENCES fsnep_polls(p_id) ON DELETE CASCADE, pc_name VARCHAR2(100), pc_comment VARCHAR2(3000), pc_ip VARCHAR2(20) ) -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD20742-2611 301-405-2545 Phone www.phi.umd.edu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Prepared Statements in CFMX
Yes, i have looked at cfQueryParam. I dont think it works the same as below. http://java.sun.com/j2se/1.4.2/docs/api/java/sql/PreparedState ment.html Yes, that's exactly what it does. The CFQUERYPARAM tag creates a prepared statement. If you look at your debug output when using CFQUERYPARAM, you'll see the placeholders within your SQL statement. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: OT: JS Gateway Question
From: Dan O'Keefe [mailto:[EMAIL PROTECTED] Hi Mike, Did you check with Dan Switzer? Does he have a yahoo group for the gateway as he does for qForms? Hi Dan, I inquired about the gateway email list and Dan S. said to use the qForms emal list for JS Gateway questions... which I have done with no success. I have not found many users of the gateway on the list let alone anyone who has used it in great depth. I emailed Dan directly (off-list) yesterday to see if he has any idea... I know of one other person trying to solve the same issue so hopefully we can find a solution. I haven't seen Dan active in any of the lists recently; I hope all is ok with him. I do know that there are a ton of people using qForms these days though for client side validation, google qForms and see all the sites using it... :-) Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Prepared Statements in CFMX
Would that have something to do with the error I get if I run a query using cfqueryparam , make a slight change to database structure and then run the query again? If I remove the cfqueryparam it works fine and if I wait awhile before running the query again it does fine. Almost acts like it's caching info that is no longer correct following a slight change to the table. Ken On Wed, 22 Sep 2004 01:48:50 -0700, Paul Kenney [EMAIL PROTECTED] wrote: Well, it does do the same thing. The only difference is that you use cfquery instead of using the JDBC API directly.In fact, if you use cfqueryparam, the database turns your query is turned into a prepared statement the first time it is called and sends back a handle to the JDBC driver.For all subsequent calls to that query, only the handle and the bound parameters are sent to the database--not the entire query. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: sql question
Turn it into a Stored Procedure and just call the stored procedure. Either using cfquery or cfstoredproc. _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 10:34 AM To: CF-Talk Subject: Re: sql question it cant be ommitted when creating a view and you do that from a single dsn in cfmx and you have to reference the database. CREATE VIEW must be first in the sql statement, unless its preceded by a GO heres what im doing... we are using a distributed partitioned view, and when we make table column changes we have to drop the view and create it again we want to make a cfmx routine that will destruct the views on all databases, add the new column to all the tables, then recreate the view all from 1 dsn. here is what works in sql: use dpvEven_2 if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[view_dpvReports]') and OBJECTPROPERTY(id, N'IsView') = 1) drop view [dbo].[view_dpvReports] go USE dpvEven_2 go CREATE VIEW view_dpvReports AS SELECT * FROM dpv1.dpvOdd_1.dbo.reports1 UNION ALL SELECT * FROM dpv1.dpvOdd_3.dbo.reports3 UNION ALL SELECT * FROM dpv1.dpvOdd_5.dbo.reports5 UNION ALL SELECT * FROM dpv1.dpvOdd_7.dbo.reports7 UNION ALL SELECT * FROM dpv1.dpvOdd_9.dbo.reports9 UNION ALL SELECT * FROM dpv1.dpvOdd_11.dbo.reports11 UNION ALL SELECT * FROM dpv2.dpvEven_2.dbo.reports2 UNION ALL SELECT * FROM dpv2.dpvEven_4.dbo.reports4 UNION ALL SELECT * FROM dpv2.dpvEven_6.dbo.reports6 UNION ALL SELECT * FROM dpv2.dpvEven_8.dbo.reports8 UNION ALL SELECT * FROM dpv2.dpvEven_10.dbo.reports10 UNION ALL SELECT * FROM dpv2.dpvEven_12.dbo.reports12 go but that doesnt work from cfmx in a cfquery tag. im thinking i just might use some stored procedures for this... unless anyone can think of another way. thanks! Tony Weeg macromedia certified cold fusion developer email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ cool tool: http://www.antiwrap.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Prepared Statements in CFMX
Would that have something to do with the error I get if I run a query using cfqueryparam , make a slight change to database structure and then run the query again? If I remove the cfqueryparam it works fine and if I wait awhile before running the query again it does fine. Almost acts like it's caching info that is no longer correct following a slight change to the table. If you're using SELECT * within your query, I can see that happening. When you build a prepared statement, the database typically caches the execution plan for that statement. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: relational display
The only thing that I didn't get was the first line of the WHERE p.p_id = a.pa_pollID.It seems that if I have the last AND p.p_id = 21, then I shouldn't need that first line, but I do.I am told by several that it's because it connects the pollID to the answerId and I know that they're correct cause it only works with that line.It'slike this is the only line that does associating and the others do filtering, clearing out of data.Do I need this line only because of the COUNT at the top?I doubt it, but I dunno. WHERE p.p_id = a.pa_pollID !--- The pollid in your poll table should be the same poll id in your answer table, so that answers are linked with the poll --- The other problem that I found is that the answers that weren't answered, so they're not in the Results table, aren't listed.I don't know what to do about that, but the poll should list all answers and just put a 0 next to the one without any answers. I've posted this question as it's own post, but so far have not seen an answer.Any thoughts are welcome - very welcome really. And I was just kiddin about the Loathe comment.I prefer descriptive names myself, just had done this because of a suggestion. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Prepared Statements in CFMX
As much as I hate SELECT * , I am using it in this case on some admin pages rather than code individual queries for each table...pure laziness.Never noticed that behavior under CF5 using ODBC. Thanks, Ken On Wed, 22 Sep 2004 12:13:29 -0400, Dave Watts [EMAIL PROTECTED] wrote: Would that have something to do with the error I get if I run a query using cfqueryparam , make a slight change to database structure and then run the query again? If I remove the cfqueryparam it works fine and if I wait awhile before running the query again it does fine. Almost acts like it's caching info that is no longer correct following a slight change to the table. If you're using SELECT * within your query, I can see that happening. When you build a prepared statement, the database typically caches the execution plan for that statement. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
What Pages are being Parsed
Is there a way in CFMX to see/get what Pages are being parsed in real-time? We are trying to debug a problem due to load and Jrun connection errors and want to see where and when the problem is occurring.. N This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540.It contains information which is confidential and may also be privileged.It is for the exclusive use of the intended recipient(s).If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful.If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910.The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Session variable works one line and not another?
Could it be a locking issue? do you structDelete(session,Replicant), or structClear(session)? I have often experienced this where a user double-clicks a button or link. -nathan strutz http://www.dopefly.com/ Damien McKenna wrote: Can anyone please help me work out why the second line would ever fail with the message Element REPLICANT is undefined in SESSION.? cfif StructKeyExists(Session, Replicant)cfif IsStruct(Session.Replicant) cfif StructKeyExists(Session.Replicant, Name)h4#Session.Replicant.Name#/h4/cfif /cfif I thought the above was rock-solid code, but apparently not.This fails once-in-a-while but is not reproducable as best as I can tell. Any help would be appreciated. -- *Damien McKenna* - Web Developer - [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 Nothing endures but change. - Heraclitus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
QueryString
Hi, Is there anyway to get the text of the query that is being executed.I have a page that the query is being pieced together thru the use of dropdowns and so on and the problem that I am having is that certain query will return a large amount of records (@50,000) and I want to capture every query that is run and have it emailed to me so that I can see what the queries are and speak to my DBA department to see exactly what has happened to those tables. I checked the logs and the page is logged as running longer that the set time in tha admin but the page will finally finish.I know that there is #error.querystring#, but is there anyway to get the query string if there is no error. Thanks Mario [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: windows, services, and the JMC
Yes, this is normal behavior. I suggest using the services panel to start and stop your server, unless you just happen to be in the JMC and just want to restart your server. This way, the services panel doesn't get confused as to what is and is not running. Also, when you say you have 2 jrun.exe processes, the JMC (administrator service) runs one of these, and your CF server takes up another one, so there's the two. -nathan strutz http://www.dopefly.com/ Douglas Knudsen wrote: We are using the J2EE way on JRunI noticed an issue that maybe some of you can comment on.If I start the CF server via the JRun JMC it does not seem to start the registered service as seen in the windows services MMC.Actually, I can have two jrun.exe processes for the same CF server!I just found this on MACR Note: When using a Windows service for JRun, users should start servers from the Windows Control Panel, not the JMC.When starting and stopping remote servers through the JMC, do not use Windows services unless all the servers are installed in the Control Panel with the [-norestart] switch.The Windows service startup type is set toautomatic by default, which means a reboot restarts server without using the JMC. Anyone care to comment have some best practise advice? -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: QueryString
From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] I know that there is #error.querystring#, but is there anyway to get the query string if there is no error. #CGI['QUERY_STRING']# Michael T. Tangorre [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: windows, services, and the JMC
ah, ok.I actually have 4 servers running, Default, Admin, CF, and another CF named Portal.So 4 servers running.If I use a combo of the JMC and the services MMC I can end up with 5 or more jrun.exe processes. I have custom jvmconfigs for each, if I use the JMC to start/stop each does it use the custom ones defined via jrunsvc cmd? OT: Damn gmail is low as kaywrap today!I have a couple invites if someone reads this.emil me DIRECTLY only though. Doug - Original Message - From: Nathan Strutz [EMAIL PROTECTED] Date: Wed, 22 Sep 2004 09:54:15 -0700 Subject: Re: windows, services, and the JMC To: CF-Talk [EMAIL PROTECTED] Yes, this is normal behavior. I suggest using the services panel to start and stop your server, unless you just happen to be in the JMC and just want to restart your server. This way, the services panel doesn't get confused as to what is and is not running. Also, when you say you have 2 jrun.exe processes, the JMC (administrator service) runs one of these, and your CF server takes up another one, so there's the two. -nathan strutz http://www.dopefly.com/ Douglas Knudsen wrote: We are using the J2EE way on JRunI noticed an issue that maybe some of you can comment on.If I start the CF server via the JRun JMC it does not seem to start the registered service as seen in the windows services MMC.Actually, I can have two jrun.exe processes for the same CF server!I just found this on MACR Note: When using a Windows service for JRun, users should start servers from the Windows Control Panel, not the JMC.When starting and stopping remote servers through the JMC, do not use Windows services unless all the servers are installed in the Control Panel with the [-norestart] switch.The Windows service startup type is set toautomatic by default, which means a reboot restarts server without using the JMC. Anyone care to comment have some best practise advice? -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
passing from java to cf
I have written a java class that crawls our site compiles a list of links. I then populate a cf array from a java method that returns a java vector. The crawling portion appears to take a couple of minutes, no surprise, but I am stopping the population of the array after 15 minutes. Any suggestions? ideas? Thanks! Doug code snippet: cfscript pages = ArrayNew(1); crawler = createObject(java,Crawler); crawler.crawl(http://site, http://site, false, 9); // this line seems to take a long time pages = crawler.getVisitedPages(); /cfscript [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: QueryString
If you are piecing it together into a variable, can't you just use cfmail to send it to you right before you submit the variable to the cfquery? Doug Ciliotta, Mario wrote: Hi, Is there anyway to get the text of the query that is being executed.I have a page that the query is being pieced together thru the use of dropdowns and so on and the problem that I am having is that certain query will return a large amount of records (@50,000) and I want to capture every query that is run and have it emailed to me so that I can see what the queries are and speak to my DBA department to see exactly what has happened to those tables. I checked the logs and the page is logged as running longer that the set time in tha admin but the page will finally finish.I know that there is #error.querystring#, but is there anyway to get the query string if there is no error. Thanks Mario [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: QueryString
There's a few things you can do... 1) enable debugging, then check your [..]\WEB-INF\debug\ folder for insight into the cfdebug structure. I think you can probably just cfdump var=#cfdebug_queries# to get a visualization, then use that to get at all the variables you want. 2) rewrite your sql statements using cfsavecontent: cfquery ... cfsavecontent var=q select * from foo /cfsavecontent #preserveSingleQuotes(q)# /cfquery then save Q to an array or something 3) rewrite your queries using a cffunction, basically like: cffunction name=cfquery cfargument name=sql cfset var q = cfquery name=q ...#preserveSingleQuotes(arguments.sql)#/cfquery cfreturn q !--- save q to an array right here, then mail yourself the array later --- /cffunction cfset myQueryResults = cfquery(select * from foo) hth -nathan strutz http://www.dopefly.com/ Ciliotta, Mario wrote: Hi, Is there anyway to get the text of the query that is being executed.I have a page that the query is being pieced together thru the use of dropdowns and so on and the problem that I am having is that certain query will return a large amount of records (@50,000) and I want to capture every query that is run and have it emailed to me so that I can see what the queries are and speak to my DBA department to see exactly what has happened to those tables. I checked the logs and the page is logged as running longer that the set time in tha admin but the page will finally finish.I know that there is #error.querystring#, but is there anyway to get the query string if there is no error. Thanks Mario [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: QueryString
On Wed, 22 Sep 2004 13:09:13 -0400, Tangorre, Michael [EMAIL PROTECTED] wrote: From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] I know that there is #error.querystring#, but is there anyway to get the query string if there is no error. #CGI['QUERY_STRING']# That won't work. CGI.query_string is for returning anything passed via the URL. I don't know of any way of getting the query string outside of turning on debugging, which is a no no in production. You could also just copy and paste the query string into a cfmail and replace any cfqueryparams with the values (because cfqueryparam will fail outside of a cfquery tag), but that's duplicating your work. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Using Sun's JVM
Greetings, Just a curiosity question really. Is anyone here running CFMX on top of Sun's 1.5.0 RC or the 1.4.2_5 JRE? How's it working for you? Thanks! -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: QueryString
From: Dave Carabetta [mailto:[EMAIL PROTECTED] That won't work. CGI.query_string is for returning anything passed via the URL. I know... I misread what he was asking for. Michael T. Tangorre [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Using Sun's JVM
On Wed, 22 Sep 2004 10:24:51 -0700, Jordan Michaels [EMAIL PROTECTED] wrote: Greetings, Just a curiosity question really. Is anyone here running CFMX on top of Sun's 1.5.0 RC or the 1.4.2_5 JRE? How's it working for you? We're using 1.4.2_05 and it's been fine. No issues whatsoever. I'm not sure CFMX will even work on the 1.5.0 RC. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: What Pages are being Parsed
How about using CFLOG in the application.cfm file?You can write the date/time and the template path as well as any other relevant information. Or, use application.cfm to save the same information to a database. From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 11:38 AM To: CF-Talk Subject: What Pages are being Parsed Is there a way in CFMX to see/get what Pages are being parsed in real-time? We are trying to debug a problem due to load and Jrun connection errors and want to see where and when the problem is occurring.. N This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540.It contains information which is confidential and may also be privileged.It is for the exclusive use of the intended recipient(s).If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910.The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Using Sun's JVM
Just a curiosity question really. Is anyone here running CFMX on top of Sun's 1.5.0 RC or the 1.4.2_5 JRE? How's it working for you? had it on both. currently on 1.5. seems fine. we're mostly interested in i18n stuff so we haven't tested it for speed, etc. but nothing bad has happened (yet). [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Boxed Cart Solution?
I have a new client that wants their site up yesterday (as usual). What ready to go solution would you all recommend - something reasonably priced for small business? Would like to stay with CF but would consider ASP.NET. TIA, Donna -- Donna French [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: REPOST: First time Web Service
This has actually been resolved.It turned out to be white space from an Application.cfm file in the same directory as the web service CFC file.I would never have guessed it from the error message, but I just started throwing the web service up on every server I had access to, and got a different error on one that pointed to the Application.cfm file.I then moved the CFC to a new directory that did not have an Application.cfm file and all worked well. Interestingly, apparently a web service/cfc file does not work up a directory tree looking for Application.cfm files like a normal cfm template does. I've only done a brief search, but I have not found any of this clearly documented. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning P.S. This was posted last week, but for some reason a bunch of cf-talk list messages seemed to have been reincarnated and sent out again.Anyway thanks for the suggestion, I'll keep it in mind if I ever have difficulties again. Confidentiality Notice:This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
SQL: Passing vars to a LIKE statement
I need to pass some varibles into a LIKE clause in a SELECT statement. I am having trouble with the format. AND valuedesc LIKE '[EMAIL PROTECTED]@year%' is what I was doing and know this is wrong cause it see that garb as a literal string. How do I pass this so the vars show? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Prepared Statements in CFMX
As much as I hate SELECT * , I am using it in this case on some admin pages rather than code individual queries for each table...pure laziness.Never noticed that behavior under CF5 using ODBC. It will only occur if you change the database structure and you're using an existing query plan or a view, I think. Perhaps you weren't using CFQUERYPARAM with CF 5, or perhaps for some reason SQL Server wasn't caching the query plans. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Boxed Cart Solution?
Donna, Check out CartWeaver - http://www.cartweaver.com/ or Able Commerce http://www.ablecommerce.com/AbleCommerce-ColdFusion-MX-Shopping-Cart-P41C20.aspx Good luck, t On Wed, 22 Sep 2004 12:46:17 -0500, Donna French [EMAIL PROTECTED] wrote: I have a new client that wants their site up yesterday (as usual). What ready to go solution would you all recommend - something reasonably priced for small business? Would like to stay with CF but would consider ASP.NET. TIA, Donna -- Donna French [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
refresh inserts my form content
I posted this on cf-newbies, but didn't understand the answer, nor could I get another solution to work. I have a form that goes to a page which updates a database.I check to see if the form exists and that an answer exists so that the database will be updated.Unfortunately, when I refresh the page, it re-submits the form content.I tried setting up a no-cache pragma META HTTP-EQUIV=Pragma CONTENT=no-cache META HTTP-EQUIV=Expires CONTENT=-1 as well as: document.forms[0].reset();which only applies to the form elements, it seems.I can set form elements through CF, but they're set back to their original values on refresh. I tried this, which I saw on a CF site: CFSET gmt = gettimezoneinfo() CFSET gmt = gmt.utcHourOffset CFIF gmt EQ 0 CFSET gmt = CFELSEIF gmt GT 0 CFSET gmt = + gmt /CFIF CFHEADER NAME=Pragma VALUE=no-cache CFHEADER NAME=Cache-Control VALUE=no-cache, must-revalidate CFHEADER NAME=Last-Modified VALUE=#DateFormat(now(), 'ddd, dd mmm ')# #TimeFormat(now(), 'HH:mm:ss')#GMT#gmt# CFHEADER NAME=Expires VALUE=Mon, 26 Jul 1997 05:00:00GMT cfflush didn't work, though it seems to apply from the manual. I've tried alot of things, for hours.Still, when I refresh the page, it resubmits the content.Anyone know a cure for this, either through CF or not? -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD20742-2611 301-405-2545 Phone www.phi.umd.edu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Zip files
Yes he did. CFX_Zip _ From: James Smith [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 10:49 AM To: CF-Talk Subject: RE: Zip files I seem to remember Ben having written a custom tag for CF4 for zipping files and directories but I don't seem to be able to find it, anyone else remember or am I imagining it? -- Jay -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: 22 September 2004 15:39 To: CF-Talk Subject: Re: Zip files cfexecute I think is your option for this one and get the zip.exe for dos? MD On Wed, 22 Sep 2004 10:30:18 -0400, Sudha Prasannappa [EMAIL PROTECTED] wrote: I know there is a library in Cold Fusion Mx - ZipfileNew to zip files from a folder. I am trying to do the same inCold fusion 5.0. Does anyone know if this can be done?? Thanks. _ [HYPERLINK http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads] [HYPERLINK http://www.houseoffusion.com/lists.cfm/link=i:4:179319This Message] [HYPERLINK http://www.houseoffusion.com/lists.cfm/link=s:4Subscription] [HYPERLINK http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=678.598.4Fast Unsubscribe] [HYPERLINK http://www.houseoffusion.com/signin/User Settings] [HYPERLINK https://www.paypal.com/cgi-bin/webscr?amount=item_name=House+of+Fusionbus iness=donations%40houseoffusion.comundefined_quantity=cmd=_xclickDonation s and Support] _ HYPERLINK http://www.houseoffusion.com/banners/view.cfm?bannerid=38 \n --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.767 / Virus Database: 514 - Release Date: 9/21/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.767 / Virus Database: 514 - Release Date: 9/21/2004 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Using Sun's JVM
Thanks Paul and Dave for your feedback. I have a customer who has continually had problems with JRun. The latest of which has to do with a JRun Garbage Collecting memory leak - thus making his otherwise ample server run out of memory, lock-up and crash like a fireball from heaven. =P More info on the JRun GC problem can be found here: http://groups.google.com.sg/groups?hl=enlr=ie=UTF-8th=725ff76bd0a2f738rnum=1 However, even though the above thread has a solution to this problem, I'm wondering if it just might be better to go with a different JRE to help avoid further problems in the future. If you don't mind me asking a couple more questions, are these production servers that you're running the updated JRE's on? What kind of load have you put them under? Has the JRE held out? Why did you switch in the first place? Thanks again for sharing your experiences. =) Warm regards, Jordan Michaels Vivio Technologies Paul Hastings wrote: Just a curiosity question really. Is anyone here running CFMX on top of Sun's 1.5.0 RC or the 1.4.2_5 JRE? How's it working for you? had it on both. currently on 1.5. seems fine. we're mostly interested in i18n stuff so we haven't tested it for speed, etc. but nothing bad has happened (yet). -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: refresh inserts my form content
one solution is to use a 3-page approach. form page - update page - thank you page the form page is self-explanatory.contains your form. the update page has your updat query in it.once the query succeeds, do a cflocation to... the thank you page.this is the page that lets your user know the update completed successfully.and since it contains no UPDATE query itself, it can be refreshed over and over and over with no adverse effects on your data :) On Wed, 22 Sep 2004 14:04:36 -0400, Daniel Kessler [EMAIL PROTECTED] wrote: I posted this on cf-newbies, but didn't understand the answer, nor could I get another solution to work. I have a form that goes to a page which updates a database.I check to see if the form exists and that an answer exists so that the database will be updated.Unfortunately, when I refresh the page, it re-submits the form content.I tried setting up a no-cache pragma META HTTP-EQUIV=Pragma CONTENT=no-cache META HTTP-EQUIV=Expires CONTENT=-1 as well as: document.forms[0].reset();which only applies to the form elements, it seems.I can set form elements through CF, but they're set back to their original values on refresh. I tried this, which I saw on a CF site: CFSET gmt = gettimezoneinfo() CFSET gmt = gmt.utcHourOffset CFIF gmt EQ 0 CFSET gmt = CFELSEIF gmt GT 0 CFSET gmt = + gmt /CFIF CFHEADER NAME=Pragma VALUE=no-cache CFHEADER NAME=Cache-Control VALUE=no-cache, must-revalidate CFHEADER NAME=Last-Modified VALUE=#DateFormat(now(), 'ddd, dd mmm ')# #TimeFormat(now(), 'HH:mm:ss')#GMT#gmt# CFHEADER NAME=Expires VALUE=Mon, 26 Jul 1997 05:00:00GMT cfflush didn't work, though it seems to apply from the manual. I've tried alot of things, for hours.Still, when I refresh the page, it resubmits the content.Anyone know a cure for this, either through CF or not? -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD20742-2611 301-405-2545 Phone www.phi.umd.edu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: refresh inserts my form content
of course it does that, but not a cfm prob a html prob what r utrying to do? see the info after it has been updated? if thats the case dont send it back to the form processing page, do u have the form and the processing code on the same page? -- Original Message -- From: Charlie Griefer [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Wed, 22 Sep 2004 11:12:41 -0700 one solution is to use a 3-page approach. form page - update page - thank you page the form page is self-explanatory.contains your form. the update page has your updat query in it.once the query succeeds, do a cflocation to... the thank you page.this is the page that lets your user know the update completed successfully.and since it contains no UPDATE query itself, it can be refreshed over and over and over with no adverse effects on your data :) On Wed, 22 Sep 2004 14:04:36 -0400, Daniel Kessler [EMAIL PROTECTED] wrote: I posted this on cf-newbies, but didn't understand the answer, nor could I get another solution to work. I have a form that goes to a page which updates a database.I check to see if the form exists and that an answer exists so that the database will be updated.Unfortunately, when I refresh the page, it re-submits the form content.I tried setting up a no-cache pragma META HTTP-EQUIV=Pragma CONTENT=no-cache META HTTP-EQUIV=Expires CONTENT=-1 as well as: document.forms[0].reset();which only applies to the form elements, it seems.I can set form elements through CF, but they're set back to their original values on refresh. I tried this, which I saw on a CF site: CFSET gmt = gettimezoneinfo() CFSET gmt = gmt.utcHourOffset CFIF gmt EQ 0 CFSET gmt = CFELSEIF gmt GT 0 CFSET gmt = + gmt /CFIF CFHEADER NAME=Pragma VALUE=no-cache CFHEADER NAME=Cache-Control VALUE=no-cache, must-revalidate CFHEADER NAME=Last-Modified VALUE=#DateFormat(now(), 'ddd, dd mmm ')# #TimeFormat(now(), 'HH:mm:ss')#GMT#gmt# CFHEADER NAME=Expires VALUE=Mon, 26 Jul 1997 05:00:00GMT cfflush didn't work, though it seems to apply from the manual. I've tried alot of things, for hours.Still, when I refresh the page, it resubmits the content.Anyone know a cure for this, either through CF or not? -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD20742-2611 301-405-2545 Phone www.phi.umd.edu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SQL: Passing vars to a LIKE statement
I need to pass some varibles into a LIKE clause in a SELECT statement. I am having trouble with the format. AND valuedesc LIKE '[EMAIL PROTECTED]@year%' is what I was doing and know this is wrong cause it see that garb as a literal string. How do I pass this so the vars show? Eric, I recently ran into this same problem recently.The correct way to do this is: AND valuedesc LIKE '%'[EMAIL PROTECTED]'%'[EMAIL PROTECTED]'%' You need to put the + signs in and remember to put the single quotes properly.Whenever you use variables, you have to build the statement as a string. Hope this helps, Ali [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SQL: Passing vars to a LIKE statement
I need to pass some varibles into a LIKE clause in a SELECT statement.
I am having trouble with the format.
AND valuedesc LIKE '[EMAIL PROTECTED]@year%' is what I was doing and know this
is wrong cause it see that garb as a literal string. How do I pass
this so the vars
show?
Here is what I am doing now... may be a better way...
lower(ki.Question) like lower('%#form.KeywordSearch#%')
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: Using Sun's JVM
On Wed, 22 Sep 2004 11:10:49 -0700, Jordan Michaels [EMAIL PROTECTED] wrote: Thanks Paul and Dave for your feedback. I have a customer who has continually had problems with JRun. The latest of which has to do with a JRun Garbage Collecting memory leak - thus making his otherwise ample server run out of memory, lock-up and crash like a fireball from heaven. =P More info on the JRun GC problem can be found here: http://groups.google.com.sg/groups?hl=enlr=ie=UTF-8th=725ff76bd0a2f738rnum=1 However, even though the above thread has a solution to this problem, I'm wondering if it just might be better to go with a different JRE to help avoid further problems in the future. Have you tried JRun Updater 4 yet? I haven't, but I know it does have a lot of fixes in there, particularly with regards to leaks. If you don't mind me asking a couple more questions, are these production servers that you're running the updated JRE's on? What kind of load have you put them under? Has the JRE held out? Why did you switch in the first place? Both development and production. Our production site gets about 500,000 users per day under peak load, and the JRE hasn't hiccupped once. In fact, we haven't even restarted the instances (we're in a clustered environment) since the upgrade a few months back. We initially upgraded because we thought that the source of our instability a few months back was JRE related (i.e., bad performance tuning, etc.). It turns out, though, that it was really our database drivers that were garbage, so we've rolled back to the CFMX Updater 3 Plus driver set from last fall, and we've been rock solid since. Even the latest rollup Updater's drivers didn't solve our issues (Oracle 8i, 9i), though we are working with Macromedia engineers to try and sort this out. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Zip files
Iuse CFX_Zip. I've experienced problems trying to open its archives using PKZip. WinZip works fine. -Original Message- From: Ewok [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 2:08 PM To: CF-Talk Subject: RE: Zip files Yes he did. CFX_Zip _ From: James Smith [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 10:49 AM To: CF-Talk Subject: RE: Zip files I seem to remember Ben having written a custom tag for CF4 for zipping files and directories but I don't seem to be able to find it, anyone else remember or am I imagining it? -- Jay -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: 22 September 2004 15:39 To: CF-Talk Subject: Re: Zip files cfexecute I think is your option for this one and get the zip.exe for dos? MD On Wed, 22 Sep 2004 10:30:18 -0400, Sudha Prasannappa [EMAIL PROTECTED] wrote: I know there is a library in Cold Fusion Mx - ZipfileNew to zip files from a folder. I am trying to do the same inCold fusion 5.0. Does anyone know if this can be done?? Thanks. _ [HYPERLINK http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads] [HYPERLINK http://www.houseoffusion.com/lists.cfm/link=i:4:179319This Message] [HYPERLINK http://www.houseoffusion.com/lists.cfm/link=s:4Subscription] [HYPERLINK http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=678.598.4Fast Unsubscribe] [HYPERLINK http://www.houseoffusion.com/signin/User Settings] [HYPERLINK https://www.paypal.com/cgi-bin/webscr?amount=item_name=House+of+Fusionbus iness=donations%40houseoffusion.comundefined_quantity=cmd=_xclickDonation s and Support] _ HYPERLINK http://www.houseoffusion.com/banners/view.cfm?bannerid=38 \n --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.767 / Virus Database: 514 - Release Date: 9/21/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.767 / Virus Database: 514 - Release Date: 9/21/2004 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: dynamic maps (GIS and other acronyms)
To do this you have to define the real world extent of your map/image then calculate the origin and radius of your circle. mapMaxX, mapMinX //these are the minimum and maximum values for the real world X coordinates imageWidth //the width of your image in pixels mapPointX //the real world X coordinate for the origin of your circle mapWidth = mapMaxX - mapMinX imagePointX = imageWidth * (mapPointX - mapMinX) / mapWidth mapRadius //the radius of your circle ie. 1 mile imageRadius = mapRadius*imageWidth/mapWidth ---Jason--- -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED] Sent: September 22, 2004 11:03 AM To: CF-Talk Subject: RE: dynamic maps (GIS and other acronyms) The problem isn't drawing the vectors; it is drawing them in context of the map. For example, drawing a circle with a radius of 1 mile with a center of x/y (lat/long). -Matt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Beal, Jason Sent: Wednesday, September 22, 2004 10:55 AM To: CF-Talk Subject: RE: dynamic maps (GIS and other acronyms) Alternatives to Thomas' suggestion which is a _javascript_ library that draws vectors by using many divs or layers to represent pixels and groups of pixels options for drawing vectors client side include: VML - (IE 5.0+ with the VML option installed) SVG - (requires plugin from Adobe) Flash -(requires Macromedia Flash plugin) If you want your maps to be more accessible then draw the vectors server side. There are graphic libraries and applications to assist you with this. A couple of suggestions would be to look at: ImageMagick - http://www.imagemagick.org/ http://www.cit.gu.edu.au/~anthony/graphics/imagick6/draw/ There is also a coldfusion custom tag MagickTag which wraps ImageMagick at http://www.alagad.com/index.cfm/name-products Java 2D API - http://java.sun.com/products/java-media/2D/ Google directory - Computers Programming Graphics Libraries http://directory.google.com/Top/Computers/Programming/Graphics/Libraries/ As far as the GIS side of things it may make things easier to avoid using one entirely. If the only dynamic part of your maps will be the vectors you draw over them then you can just use static maps to start with. For maps try: GeoConnections(canada) http://geodiscover.cgdi.ca/gdp/index.jsp?language=en USGS http://edc.usgs.gov/geodata/ Geography Network http://www.geographynetwork.com/ -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: September 22, 2004 9:49 AM To: CF-Talk Subject: Re: dynamic maps (GIS and other acronyms) On Wednesday 22 Sep 2004 03:21 am, Matt Liotta wrote: What library do I use to create the vector graphics? We use one from http://www.walterzorn.com/jsgraphics/jsgraphics_e.htm (typicaly, this site is down atm :-)). We're doing basicaly the same thing - retrive a map from a map server and then draw lines over it, to represent a 'zone'. Where do I get the maps I am layering the graphics on? There are a few companies out there that will provide this as a web service, or you can investigate things based on OpenGIS - such as http://geoserver.sourceforge.net/ -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Boxed Cart Solution?
If you search the HoF archeives you'll find some fairly reacent posts about Shopping Cart solutions. The newest version of Ablecom is not available for CF but it is for ASP. The latest version for CF is not much CF honestly it is mostly coded in Java classes, so if no one is comfortable with Java the latest version of AbleCom may not be the best solution. Thats my 2 cents Adam H On Wed, 22 Sep 2004 10:56:54 -0700, Tyler Fitch [EMAIL PROTECTED] wrote: Donna, Check out CartWeaver - http://www.cartweaver.com/ or Able Commerce http://www.ablecommerce.com/AbleCommerce-ColdFusion-MX-Shopping-Cart-P41C20.aspx Good luck, t On Wed, 22 Sep 2004 12:46:17 -0500, Donna French [EMAIL PROTECTED] wrote: I have a new client that wants their site up yesterday (as usual). What ready to go solution would you all recommend - something reasonably priced for small business? Would like to stay with CF but would consider ASP.NET. TIA, Donna -- Donna French [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Using Sun's JVM
Dave Carabetta wrote: Have you tried JRun Updater 4 yet? I haven't, but I know it does have a lot of fixes in there, particularly with regards to leaks. No, but it's just a stand-alone Cold Fusion MX installation. We have applied the CFMX 6.1 updater (released August 25) so I'm assuming that it updated JRun in it's relation to CFMX. Plus the MM's site doesn't say anything about using it on CFMX installations. So... I think I'll leave it for now and just apply the patch described in the previous link regarding the GC problem. Thanks again for your input. =) -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFC - Web service error handling
I return XML with all my webservices so if an error occures I just return that in xml... xmldoc error errorcode/errorcode errormessage/errormessage /error xmldoc Adam H On Tue, 21 Sep 2004 21:57:56 -0400, Rick Root [EMAIL PROTECTED] wrote: Ian, ALL of my web services return a CFC object, which at the very least contains two items - ERRORCODE and ERRORMESSAGE .. plus whatever else is expected to be returned.I usually populate ERRORCODE with 0 or 1, and ERRORMESSAGE with some appropriate error message.. which is sometimes cfcatch.message or something like that, and other times it's things like The username you provided was not valid.. ie, not an actual exception. - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Using Sun's JVM
On Wed, 22 Sep 2004 11:48:50 -0700, Jordan Michaels [EMAIL PROTECTED] wrote: Dave Carabetta wrote: Have you tried JRun Updater 4 yet? I haven't, but I know it does have a lot of fixes in there, particularly with regards to leaks. No, but it's just a stand-alone Cold Fusion MX installation. We have applied the CFMX 6.1 updater (released August 25) so I'm assuming that it updated JRun in it's relation to CFMX. Plus the MM's site doesn't say anything about using it on CFMX installations. So... I think I'll leave it for now and just apply the patch described in the previous link regarding the GC problem. Ah, right, forgot to ask which version you were on! Seems like your approach is best for now. Thanks again for your input. =) You welcome! Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
SOT: Windows to Unix Link capitalization problem
Does anyone know of a tool that will look for capitalization of file names in URL links and convert them to lower case?We need to transfer a site to a UNIX server and we're having a problem with the case of some of the links.The site has about 40 pages. __ Do You Yahoo!? Tired of spam?Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SOT: Windows to Unix Link capitalization problem
E C list wrote: Does anyone know of a tool that will look for capitalization of file names in URL links and convert them to lower case? Look up how to do URL rewriting (mod_rewrite in apache). -- *Damien McKenna* - Web Developer - [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 Nothing endures but change. - Heraclitus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: refresh inserts my form content
before you insert your values into the database, check for the existence of the primary key.. On the form page you have your primary key.. it's passed as a hidden variable to the proccessing page. before you do your cfquery name=insert INSERT INTO TABLE_NAME VALUES() /cfquery check for the existence of the value.. cfquery name=chk select * from table_name where pkey = #value# /cfquery cfif chk.RecordCount gt 0 ERROR THIS PKEY ALREADY EXISTS IN THE TABLE!!! cfelse preform your insert statement /cfif On Wed, 22 Sep 2004 14:15:15 -0400, dave [EMAIL PROTECTED] wrote: of course it does that, but not a cfm prob a html prob what r utrying to do? see the info after it has been updated? if thats the case dont send it back to the form processing page, do u have the form and the processing code on the same page? -- Original Message -- From: Charlie Griefer [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Wed, 22 Sep 2004 11:12:41 -0700 one solution is to use a 3-page approach. form page - update page - thank you page the form page is self-explanatory.contains your form. the update page has your updat query in it.once the query succeeds, do a cflocation to... the thank you page.this is the page that lets your user know the update completed successfully.and since it contains no UPDATE query itself, it can be refreshed over and over and over with no adverse effects on your data :) On Wed, 22 Sep 2004 14:04:36 -0400, Daniel Kessler [EMAIL PROTECTED] wrote: I posted this on cf-newbies, but didn't understand the answer, nor could I get another solution to work. I have a form that goes to a page which updates a database.I check to see if the form exists and that an answer exists so that the database will be updated.Unfortunately, when I refresh the page, it re-submits the form content.I tried setting up a no-cache pragma META HTTP-EQUIV=Pragma CONTENT=no-cache META HTTP-EQUIV=Expires CONTENT=-1 as well as: document.forms[0].reset();which only applies to the form elements, it seems.I can set form elements through CF, but they're set back to their original values on refresh. I tried this, which I saw on a CF site: CFSET gmt = gettimezoneinfo() CFSET gmt = gmt.utcHourOffset CFIF gmt EQ 0 CFSET gmt = CFELSEIF gmt GT 0 CFSET gmt = + gmt /CFIF CFHEADER NAME=Pragma VALUE=no-cache CFHEADER NAME=Cache-Control VALUE=no-cache, must-revalidate CFHEADER NAME=Last-Modified VALUE=#DateFormat(now(), 'ddd, dd mmm ')# #TimeFormat(now(), 'HH:mm:ss')#GMT#gmt# CFHEADER NAME=Expires VALUE=Mon, 26 Jul 1997 05:00:00GMT cfflush didn't work, though it seems to apply from the manual. I've tried alot of things, for hours.Still, when I refresh the page, it resubmits the content.Anyone know a cure for this, either through CF or not? -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD20742-2611 301-405-2545 Phone www.phi.umd.edu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ot: sql question
As far as I know you cannot. - Original Message - From: Tony Weeg [EMAIL PROTECTED] Date: Wed, 22 Sep 2004 09:59:03 -0400 Subject: ot: sql question To: CF-Talk [EMAIL PROTECTED] is it true that we cannot use go in sql statements using cfquery? -- tony Tony Weeg macromedia certified cold fusion developer email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ cool tool: http://www.antiwrap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Query/DB design problem
The query has to select the aggregrate and then outer join the related table. This is just a stab in the dark as to how the query would look, but if you can see what I'm trying to do, you can follow the concept to completion.I'm not a DBA so take this as a guideline and not the solution (unless, of course, it *is* the solution in which case feel free to praise me) cfquery name=poll_results datasource=eatsmart SELECT p.p_id,p.p_question, a.pA_answer, COUNT(r.pV_poll_answer) AS total FROM fsnep_polls p INNER JOIN rfsnep_pollAnswers aON a.pA_pollID = p.p_id OUTER JOIN fsnep_pollresults r ON r.pV_poll_answer = a.pA_id WHERE p.p_id = #url.poll# GROUP BY p.p_question, a.pA_answer, p.p_id ORDER BY p.p_question, a.pA_answer /cfquery From: Daniel Kessler [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 11:26 AM To: CF-Talk Subject: Query/DB design problem I recently asked how to structure a query to request poll results from my db. I've listed the db structure and the query below. The problem that I now have is that it only lists poll answers that have been answered once.I know that this is because it's querying the Results table (fsnep_pollresults) and that if there are answers that have not been selected, then they won't show up in the results table. I don't know of a good, clean way of making this query includethem. The only way I know to do it is to get a list of the answers and set up a query that looks for the count of each of the answers.So if there are 5 answers, I'll have 5 queries.It sounds like a resource hog to me. Any thoughts? Query: cfquery name=poll_results datasource=eatsmart SELECT p.p_id,p.p_question, a.pA_answer, COUNT(r.pV_poll_answer) AS total FROM fsnep_polls p, fsnep_pollAnswers a, fsnep_pollresults r WHERE p.p_id = a.pA_pollID AND a.pA_id = r.pV_poll_answer AND p.p_id = #url.poll# GROUP BY p.p_question, a.pA_answer, p.p_id ORDER BY p.p_question, a.pA_answer, p.p_id /cfquery [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: print output
How about this http://gilgamesh-solutions.com/products.cfm#p1 - Original Message - From: Brant Winter [EMAIL PROTECTED] Date: Wed, 22 Sep 2004 15:00:32 +1000 Subject: RE: print output To: CF-Talk [EMAIL PROTECTED] Timeframe : 6 months ago - like everything else round here. _ From: dave [mailto:[EMAIL PROTECTED] Sent: Wednesday, 22 September 2004 2:41 PM To: CF-Talk Subject: Re: print output whats the time frame? i hear that the new blackstone has some great new printing tags The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. Please carry out such virus and other checks, as you consider appropriate. To the fullest extent allowed by law, no responsibility is accepted by Haematology Oncology Clinics of Australasia for any virus damage caused by this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: windows, services, and the JMC
Douglas Knudsen wrote: ah, ok.I actually have 4 servers running, Default, Admin, CF, and another CF named Portal.So 4 servers running.If I use a combo of the JMC and the services MMC I can end up with 5 or more jrun.exe processes. I would ditch the default server, unless you use it. Also, the admin should only run when you need it to, for security and to free up server cpu and memory. If you're saying you still have JRun.exe's unaccounted for, you can always end-process one at a time and see which servers go down (the crapshoot is always a great idea!). I have custom jvmconfigs for each, if I use the JMC to start/stop each does it use the custom ones defined via jrunsvc cmd? Running as a service starts with the same commands as hitting the start button in the JMC. I'm not sure exactly what you're getting at. It should pick up custom jvmconfigs, no problem. -nathan strutz http://www.dopefly.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFC - Web service error handling
This solution works well since most complex ColdFusion data types aren't handled well when passed via a webservice.I convert almost everything in a CFC to an XML string before returning it and also have the error code and description in XML.That way I know that no matter what, I'm looking for a string return type from my services. - Steve From: Adam Haskell [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 2:54 PM To: CF-Talk Subject: Re: CFC - Web service error handling I return XML with all my webservices so if an error occures I just return that in xml... xmldoc error errorcode/errorcode errormessage/errormessage /error xmldoc Adam H [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ot: jrun ?
i turned it down from 512 mb to 128 mb and now it wont even start lol -- Original Message -- From: Dave Carabetta [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Tue, 21 Sep 2004 12:43:17 -0400 On Tue, 21 Sep 2004 11:35:05 -0500, Ben Frame [EMAIL PROTECTED] wrote: Neil, Why set the initial and max heap size the same?Is that recommendation documented from Macromedia anywhere or is that from your own experiences? Setting the two values to be the same increases performance in so far as it eliminates the need for the JVM to resize itself based on the resources being used. This can be an expensive process, which might cause a degradation with regard to your application performance. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: SQL: Passing vars to a LIKE statement
thanks, but I am doing this in sql stored proc not a cf page. forgot to mention this
-Original Message-
From: Brett Barnhart [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 22, 2004 1:22 PM
To: CF-Talk
Subject: Re: SQL: Passing vars to a LIKE statement
I need to pass some varibles into a LIKE clause in a SELECT statement.
I am having trouble with the format.
AND valuedesc LIKE '[EMAIL PROTECTED]@year%' is what I was doing and know this
is wrong cause it see that garb as a literal string. How do I pass
this so the vars
show?
Here is what I am doing now... may be a better way...
lower(ki.Question) like lower('%#form.KeywordSearch#%')
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
debug question
Is there a function out there that mimics CF's Debug? I'm looking for something along these lines to provide in an email. The function would have to act almost exactly as CF's dbug? TIA Jay Reichenbach [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: dynamic maps (GIS and other acronyms)
To convert a radius from real world coordinates to a coordinate on the image you can use the following to first find the origin point on the map then find the length in pixels of the radius. mapMaxX, mapMinX //these are the minimum and maximum values for the real world X coordinates imageWidth //the width of your image in pixels mapPointX //the real world X coordinate for the origin of your circle mapWidth = mapMaxX - mapMinX imagePointX = imageWidth * (mapPointX - mapMinX) / mapWidth mapRadius //the radius of your circle ie. 1 mile imageRadius = mapRadius*imageWidth/mapWidth ---Jason--- -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED] Sent: September 22, 2004 11:03 AM To: CF-Talk Subject: RE: dynamic maps (GIS and other acronyms) The problem isn't drawing the vectors; it is drawing them in context of the map. For example, drawing a circle with a radius of 1 mile with a center of x/y (lat/long). -Matt [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
JAVASCRIPT and textarea
I have form with TextAreaand _javascript_, which doesn't allow user to hit enter key and |.
The below code is working fine, but if user cut/paster from word or notepad then textbox accept the enter key and pipe.
Can someone advise anyway to prevent that??
script language=_javascript_
function kH(e) {
var pK = document.all? window.event.keyCode:e.which;
return (pK != 13) (pK != 124);
}
document.>
if (document.layers) document.captureEvents(Event.KEYPRESS);
/script
body
form name=myForm action="" method=post checkForm();
textarea cols=70 class=content name=story rows=5/textarea
/form
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: SQL: Passing vars to a LIKE statement
thanks but it is not helping, here is my stored proc and the error msg I receive
CREATE PROCEDURE GetMonthlyJoins AS
DECLARE
@MONTH varchar(3),
@MONTHNBRint,
@YEARint,
@did datetime,
@countint,
@likevar varchar(25)
IF object_id('#MonthlyJoins') is not null
BEGIN
TRUNCATE TABLE #MonthyJoins;
END
ELSE
BEGIN
CREATE TABLE #MonthyJoins
(
rptmonth varchar(3),
rptmonthnbr int,
rptyear int,
total int
);
END
DECLARE didCursor cursor local static
FOR
SELECT DISTINCT rptdate
FROM ALL_DAILY_TOTALS
WHERE convert(varchar(10),rptdate,101) like '%/01/%'
ORDER BY rptdate
open didCursor
fetch didCursor into @did
WHILE @@fetch_status=0
BEGIN
SET @year = (SELECT DATEPART(year, @did))
SET @month =(SELECT UPPER(LEFT(DATENAME(month, @did),3)))
SET @monthnbr =(SELECTMONTH(@did))
SELECT @count=COUNT(*)
FROM avectraprod.dbo.persondemographic(nolock)
WHERE demographicgroupid =4
AND demographicitemid =7
AND demographicvaluedesc LIKE @month+'%'[EMAIL PROTECTED]'%'
INSERT INTO #MonthyJoins
( rptmonth,rptmonthnbr,rptyear, total )
VALUES
(@month,@monthnbr,@year,@count)
fetch next FROM didCursor into @did
END
close didCursor
deallocate didCursor
SELECT * FROM #MonthyJoins
GO
Error Message:
Server: Msg 245, Level 16, State 1, Procedure GetMonthlyJoins, Line 51
Syntax error converting the varchar value 'FEB%' to a column of data type int.
-Original Message-
From: Ali Awan [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 22, 2004 1:21 PM
To: CF-Talk
Subject: Re: SQL: Passing vars to a LIKE statement
I need to pass some varibles into a LIKE clause in a SELECT statement.
I am having trouble with the format.
AND valuedesc LIKE '[EMAIL PROTECTED]@year%' is what I was doing and know this
is wrong cause it see that garb as a literal string. How do I pass
this so the vars
show?
Eric,
I recently ran into this same problem recently.The correct way to do this is:
AND valuedesc LIKE '%'[EMAIL PROTECTED]'%'[EMAIL PROTECTED]'%'
You need to put the + signs in and remember to put the single quotes properly.Whenever you use variables, you have to build the statement as a string.
Hope this helps,
Ali
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: SQL: Passing vars to a LIKE statement
Pass the percent signs as part of your var... Don't know why it works
but it does. There is a way to do it in a stored proc but I don't
remember off the top of my head.
_
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 22, 2004 4:15 PM
To: CF-Talk
Subject: RE: SQL: Passing vars to a LIKE statement
thanks but it is not helping, here is my stored proc and the error msg I
receive
CREATE PROCEDURE GetMonthlyJoins AS
DECLARE
@MONTH varchar(3),
@MONTHNBRint,
@YEARint,
@did datetime,
@countint,
@likevar varchar(25)
IF object_id('#MonthlyJoins') is not null
BEGIN
TRUNCATE TABLE #MonthyJoins;
END
ELSE
BEGIN
CREATE TABLE #MonthyJoins
(
rptmonth varchar(3),
rptmonthnbr int,
rptyear int,
total int
);
END
DECLARE didCursor cursor local static
FOR
SELECT DISTINCT rptdate
FROM ALL_DAILY_TOTALS
WHERE convert(varchar(10),rptdate,101) like '%/01/%'
ORDER BY rptdate
open didCursor
fetch didCursor into @did
WHILE @@fetch_status=0
BEGIN
SET @year = (SELECT DATEPART(year, @did))
SET @month =(SELECT UPPER(LEFT(DATENAME(month, @did),3)))
SET @monthnbr =(SELECTMONTH(@did))
SELECT @count=COUNT(*)
FROM avectraprod.dbo.persondemographic(nolock)
WHERE demographicgroupid =4
AND demographicitemid =7
AND demographicvaluedesc LIKE @month+'%'[EMAIL PROTECTED]'%'
INSERT INTO #MonthyJoins
( rptmonth,rptmonthnbr,rptyear, total )
VALUES
(@month,@monthnbr,@year,@count)
fetch next FROM didCursor into @did
END
close didCursor
deallocate didCursor
SELECT * FROM #MonthyJoins
GO
Error Message:
Server: Msg 245, Level 16, State 1, Procedure GetMonthlyJoins, Line 51
Syntax error converting the varchar value 'FEB%' to a column of data
type int.
-Original Message-
From: Ali Awan [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 22, 2004 1:21 PM
To: CF-Talk
Subject: Re: SQL: Passing vars to a LIKE statement
I need to pass some varibles into a LIKE clause in a SELECT statement.
I am having trouble with the format.
AND valuedesc LIKE '[EMAIL PROTECTED]@year%' is what I was doing and know this
is wrong cause it see that garb as a literal string. How do I pass
this so the vars
show?
Eric,
I recently ran into this same problem recently.The correct way to do
this is:
AND valuedesc LIKE '%'[EMAIL PROTECTED]'%'[EMAIL PROTECTED]'%'
You need to put the + signs in and remember to put the single quotes
properly.Whenever you use variables, you have to build the statement
as a string.
Hope this helps,
Ali
_
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
ODBC more unstable with CFMX 6.1 Updater?
I've noticed that the ODBC gateway in the 6.1 Updater seem to be more unstable than the 6.1 ones, at least when using the AcuODBC driver at the ODBC side.Has anyone else noticed anything similar? -- *Damien McKenna* - Web Developer - [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 Nothing endures but change. - Heraclitus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: JAVASCRIPT and textarea
Instead of checking for these characters while they are typing or
pasting, why not just replace them with nothing when they submit the
form?
From: Asim Manzur [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 22, 2004 3:16 PM
To: CF-Talk
Subject: _javascript_ and textarea
I have form with TextAreaand _javascript_, which doesn't allow
user to hit enter key and |.
The below code is working fine, but if user cut/paster from word
or notepad then textbox accept the enter key and pipe.
Can someone advise anyway to prevent that??
script language=_javascript_
function kH(e) {
var pK = document.all? window.event.keyCode:e.which;
return (pK != 13) (pK != 124);
}
document.>
if (document.layers) document.captureEvents(Event.KEYPRESS);
/script
body
form name=myForm action="" method=post
checkForm();
textarea cols=70 class=content name=story
rows=5/textarea
/form
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: JAVASCRIPT and textarea
From: Asim Manzur [mailto:[EMAIL PROTECTED] I have form with TextAreaand _javascript_, which doesn't allow user to hit enter key and |. The below code is working fine, but if user cut/paster from word or notepad then textbox accept the enter key and pipe. Can someone advise anyway to prevent that?? You handle the keyCode event but not the change (onChange) event which you need to check also to ensure that a copy past fires off the routine needed to validate the entry into the box. Michael T. Tangorre [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: dynamic maps (GIS and other acronyms)
ordinarilly when it comes to generating dynamic and/or rich interfaces I recommend Flash, but for something like this, I'd recommend using SVG - there are even plenty of open source SVG java packages that might help you get started. ~Simon Simon Horwith Member of Team Macromedia Macromedia Certified Master Instructor Editor-in-Chief, ColdFusion Developers Journal Blog - http://www.horwith.com Matt Liotta wrote: I need the ability to present maps dynamically as images. These maps would be of US cities that have vector graphics layered on top of them. I need to programmatically create these vector graphics on the fly using only GPS coordinates and/or street address. I am perfectly capable of writing the code for this in Java, but I am not really sure where to start. What library do I use to create the vector graphics? Where do I get the maps I am layering the graphics on? I have found many Java-based open source projects that seem to do what I want, but without knowing much about this space it is hard to get started. If a few pointers are all I need then I would appreciate them. Otherwise, I could use a consultant to get me started. -Matt [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
