RE: weather feed
It's probably my fault for not using weather in the title (I was never any good at marketing!)The tag is FreeData_NW (for National Weather service, dontcha know).Here's a direct link: http://www.depressedpress.com/DepressedPress/Content/ColdFusion/CustomTags/F reeData_NWS/Index.cfm Don't expect much!This is very old code (from 1999) - it still works but I'm not sure if I'm proud of it any more.;^) I think you've already gone far beyond me - I don't store the states or anything like that.It was really designed for a website that wanted the weather for one, predetermined place (in my case, Boston).It does the job for that - but not as a general get the weather for anyplace type thing like your stuff. Good to hear about the potential XML feed.I still won't hold me breath - but it sounds like it's definitely getting off the ground. Jim Davis _ From: Todd Finney [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 1:32 AM To: CF-Talk Subject: RE: weather feed At 01:18 AM 12/9/2003 -0500, you wrote: I built my tag. jeeze, four years ago and the pages have never changed. I don't see any mention of it on the depressedpress.com site.Can I take a look at your work? I wouldn't hold my breath for XML.;^) Actually, according to my contacts at the NOAA, there are a number of people pushing rather hard for XML.I've actually seen their preliminary work on it, and it looks very promising. I don't know how soon it's going to happen, but my impression is that it's going to happen eventually. -- Todd _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Flash Instant Messenger Software?
Novak It's really nothing more than a Flash movie using ColdFusion as middleware to do SQL selects and inserts from a database table.Some might argue that using session/client variables would be better... but for corporate reasons we wish to keep a 14 day (configurable of course) log of all conversations. We have an IM tool exactly like this that uses Flash JSP. We also have a whiteboard component that goes with it. These are bundled in with the collaboration tools in our CMS but would not be hard to unbundle. If you're happy using JSPs in your CF app, contact me off list. Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL col type
Mickael Hi I don't really have that skill set, is that the only way to do this? In Access, I think so. Most other DBMS have tables that you can query for this info but Access only has a table of tables, not a table of columns. The ADO way is not too hard using CFOBJECT iirc. Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
[OT] - RegExp Help
Hi all, I'm trying to write a regular _expression_ and am having a little trouble... What I want to do is replace all instances of '/document.cfm' in a string with '/public/document.cfm', unless the original substring is '/public/document.cfm' - ie I don't want to end up with '/public/public/document.cfm'. This is what I;ve been trying: #ReReplace('.open.ac.uk/document.cfmtest','(^public)/document.cfm','/pu blic/document.cfm')# But in this instance it's not finding a match, so not replacing the required substring - can anyone give me any pointers as to where I;ve gone wrong? I found plenty of examples about Reg Exp generally, but none which seem to fit what I'm trying to achieve. Thanks, Alex [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: weather feed
At 02:11 AM 12/9/2003 -0500, you wrote: Don't expect much!This is very old code (from 1999) - It's CF.I'm a perl guy. I wouldn't know good or bad CF if it smacked me firmly in the face. :) I'm actually only here to talk about the weather feeds.Once this thread dies, I'll quit pestering you guys. it still works It probably won't work for much longer, though.You're using the IWIN data, which is (in the words of the NOAA) not long for this world.I used the IWIN data until August, when they changed the format of the national summary file that I was using from raw weather metrics to English write ups. I'm currently parsing these http://weather.noaa.gov/pub/data/raw/as/, on the recommendation of the guys at the NOAA. but I'm not sure if I'm proud of it any more.;^) Well, he said, it's nicely indented. -- Todd [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: [OT] - RegExp Help
I'm trying to write a regular _expression_ and am having a little trouble... What I want to do is replace all instances of '/document.cfm' in a string with '/public/document.cfm', unless the original substring is '/public/document.cfm' - ie I don't want to end up with '/public/public/document.cfm'. As far as I remember, CF MX RegExp don't support lookbehind, so I would try this, accessing directely Java's string methods: cfset str1 = open.ac.uk/document.cfmtest cfset str2 = directory/public/document.cfm cfset pattern = (?!public)/document.cfm cfoutput#str1.replaceFirst(pattern,'/public/document.cfm')#/cfoutput br cfoutput#str2.replaceFirst(pattern,'/public/document.cfm')#/cfoutput Be adviced it requires CF 6.1 (or JRE 1.4+). I am sure there are other alternatives, so you may want to investigate them as well. Hope it will help Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Creating VCF Files in CF.
Hello All, I'm putting together a little programmette to allow users to select from a DB of leads generated through a website click on the link and generate a vcard (VCF) file with the contacts details then CFContent it back to the userso they can use it in Outlook or Eudora or whatever. SImple , I thought I can create the Vcard file, and get it to open,however the file is blank, no matter what I do I cant seem to get any info into it. Has anyone else tried this and can help ? This is the main bit of the code: cfsavecontent variable=createdVCF BEGIN:VCARD VERSION:2.1 FN:On N:On;A;N.;MR END:VCARD /cfsavecontent [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: [OT] - RegExp Help
BTW Since sometimes I fund useful to access Jav's string APIs, I put together a collection of UDF inside a CFC: http://www.cfmentor.com/code/index.cfm?action=""> I am also almost finished a similar CFC that act as a wrapper for the java.util.regex package. I just need to polish it a little bit; it will available very soon. Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:network monitor
Can you show me how to do this please, I would really appreciate it. Many Thanks On Monday 08 Dec 2003 15:27 pm, cf coder wrote: The page should have the columns Name and Status. I don't know how to go about doing this. I can call I assume this is in a HTML table ? Can you get the relavent td elements tagged (then you can just search in the return page for the right td and display anything betwen the tags) ? Otherwise you'll have to figure out a way of finding the right bit youself (find the 3rd img, count in three tr tags, then print every 4th td tag). -- 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]
msproject xml generator?
Anyone know of a tag that will generate XML to create an MS Project? Or a way to add tasks to an existing MS project perhaps? Michael Traher Systems Manager [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
cfmail
Hello, i am using cfmail tag and everything is going just fine. However, if a mail does not arrive to its destination i need to send it to the administrator... How do i do that? Thanks... Micheal - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: network monitor
On Tuesday 09 Dec 2003 08:58 am, cf coder wrote: Can you show me how to do this please, I would really appreciate it. Do what ? Split a string up into a list based on an arbitery set of chars ? There must be a tag/udf to do that... Or you can just walk the string, with a simple counter to keep track of where you are - there are plenty of ways to say 'get me the next td starting from position 345 in this string. -- 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]
RE: cfmail
You might find that the mail server you are using has this facility - to reroute any bounced back emails. Alternatively you could investigate the CFPOP tag to open a mailbox of returned mails and forward these to another address. The first option seems preferable. Michael Traher [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfmail
On Tuesday 09 Dec 2003 10:23 am, Michel Geadah wrote: However, if a mail does not arrive to its destination i need to send it to the administrator... How do i do that? Set the from adress to be the administrators. I don't think you can do very much else. -- 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]
Re:OT: GeoTrust Certs @ 25$ ?
I'm sorry you've had that experience, but for me that simply wasn't the case. I've *renewed* at least four certificates within the last 3 months for $25 each through that purchase form on the ev1 site. Can't tell you what went wrong with your renewals, but I'm 100% confident that there is no catch or sneaky motives behind this. And no, I'm in no way affiliated with either ev1 or Geotrust. Jack Jack Dalaa wrote: It's $25, no catch. I've purchased numerous certificates through these guys over the past year and a half, there's nothing fishy about it, just a great deal. I've got the same story, but my experience was a little different. There is, indeed, a catch.As was pointed out earlier renewals are at the full rate of US$119.Try and renew via Rachshack's $29 form (now renamed to ev1.net) and you will find out that GeoTrust auto-senses a renewal and won't let you in for the cheap rate unless you switch domains (i.e. switch to secure.blah.com instead of www.blah.com).So kiss your certificate profits goodbye in Year 2 or kick up your maintenance costs playing games on the renewal. Next, Rackshack/EV1 sends out renewal notices... Both to the tech and the admin contact, so if that's your client they get the notices and then bother you wondering what the deal is.Worse (and I know this is deliberate as I have so many of these installed, and have seen dozens) they send a false expiration email a few days before the cert expiration.This note says the cert expired five days ago.The reality is its got about a week left... It's a ploy to get you to renew. So I moved over to instantssl.com. I'm a reseller there and I pay about US$42 for each cert.Naturally, you can retail them for whatever you want.It's a very, very easy and truly instant process (note that you can only self-verify and get instant issuance if you are an instantssl reseller). Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:network monitor
well, I just don't know know to do this, someone asked for the code, I've posted it, I was hoping someone could post the code and share the logic. Best Regards CF Coder On Tuesday 09 Dec 2003 08:58 am, cf coder wrote: Can you show me how to do this please, I would really appreciate it. Do what ? Split a string up into a list based on an arbitery set of chars ? There must be a tag/udf to do that... Or you can just walk the string, with a simple counter to keep track of where you are - there are plenty of ways to say 'get me the next td starting from position 345 in this string. -- 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]
Re: CF pda types of devices
On Monday 08 Dec 2003 16:40 pm, Dan Farmer wrote: so how would one detect what kind of device ( other than pc ) was accessing my site? would it just be a matter of creating a link ( flash site here | xhtml site here | PDA xhtml site here | WML site here ) You can use Apache's auto-negoatied multiviews. You can have your Application.cfm/page header swap on user_agent and/or the accept headers. I'm sure there are more :-) -- 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]
Project Management
Does anyone have experiences with Project Management Tracking System with ColdFusion or PHP or know the example sources? I will need to handle multiple projects. What I want to accomplish with the system is that, as an example, 1) The project owner assigns action items to project members with deadlines 2) Before the deadlines, the system reminds the members for the items to be competed 3) If the deadlines have passed, the system warns the members to follow-up as soon as possible 4) If all items are completed, the system closes the particular project. Thanx -- ___ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: alternative to CFFTP
Try this http://www.jscape.com/ftpapplet/index.html --Original Message Text--- From: Dan Farmer Date: Mon, 08 Dec 2003 18:52:21 + I need to pull files from an FTP site...unfortunatley this ISP is not allowing the CFFTP tag... great then I asked what tags they disabled... and they wouldn't tell me... [ insert curses here ] anyway, what other options do I have to accomplish the actions of FTP? Basically I need to open and get a file... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Bank Of America payment integartion
hi, has anybody done or have or know any custom tag for Bank Of America payment system integration in estore. Please let me know. thanks ketan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFC and ColdfusionQueries
Here's the code for a java CFX to do that exact thing. It will be a whole lot faster than a cfc. snip import com.allaire.cfx.*; import java.io.*; import java.text.SimpleDateFormat; import java.util.*; public class recursiveDir implements CustomTag{ public void processRequest( Request request, Response response ) throws Exception{ if (!request.attributeExists(dir) || !request.attributeExists(queryname)) { throw new Exception(Attributes 'dir' and 'queryname' are required.); } String dir = request.getAttribute(dir); String queryname = request.getAttribute(queryname); String[] columns = { Type , Name, Size, LastModified} ; Query query = response.addQuery( queryname, columns ) ; recurseInDirFrom(dir,query); } public void recurseInDirFrom(String dirItem, Query query) { File file; String list[]; String type; String size; file = new File(dirItem); size = + file.length(); Date lm = new Date(file.lastModified()); SimpleDateFormat sdf = new SimpleDateFormat(/MM/dd HH:mm:ss); String modified = sdf.format(lm); if (file.isDirectory()) { list = file.list(); for (int i = 0; i list.length; i++) recurseInDirFrom(dirItem + File.separatorChar + list[i], query); type = Directory; } else { type = File; } int iRow = query.addRow() ; query.setData( iRow, 1, type ) ; query.setData( iRow, 2, dirItem ) ; query.setData( iRow, 3, size ) ; query.setData( iRow, 4, modified ) ; } } snip -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: 09 December 2003 06:51 To: CF-Talk Subject: RE: CFC and ColdfusionQueries Here it is raymond, If you comment the case statement Dir out, it works fine, but it refuse to work with it in there. cfcomponent displayname=DirectoryTools cfset variables.filelist=QueryNew('FileName,FileDate,Size') / cffunction name=getDirectory access=public returntype=any output=true cfargument name=Directory required=yes / cfdirectory action="" directory=#arguments.Directory# name=list cfloop query=list cfscript switch (type) { case 'File': QueryAddRow(variables.filelist); QuerySetCell(variables.filelist,'FileName',arguments.Directory name); QuerySetCell(variables.filelist,'FileDate',DateLastModified); QuerySetCell(variables.filelist,'Size',Size); break; case 'Dir': getDirectory(arguments.Directory name ); break; } /cfscript /cfloop cfset variables.filelist='' / /cffunction /cfcomponent Regards Andrew Scott Technical Consultant NuSphere Pty Ltd Level 2/33 Bank Street South Melbourne, Victoria, 3205 Phone: 03 9686 0485-Fax: 03 9699 7976 _ From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Tuesday, 9 December 2003 5:25 PM To: CF-Talk Subject: RE: CFC and ColdfusionQueries Can you show us all of the code? _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Bank Of America payment integartion
We've done it.Didn't create a custom tag or anything.It's a little odd but just takes a little string manipulation.Would have been much better if they used something standard like XML. Sam --- Blog: http://www.rewindlife.com Charts: http://www.blinex.com/products/charting --- -Original Message- From: Ketan Patel [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 7:48 AM To: CF-Talk Subject: Bank Of America payment integartion hi, has anybody done or have or know any custom tag for Bank Of America payment system integration in estore. Please let me know. thanks ketan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF pda types of devices
Speaking of this, I am going to be testing the Treo 600 combination PDA, Phone device. What would be the best direction for developing a CFMX based application for this device? CFMX, Flash ? WAP? I would be interested in having our remote sales team fill some forms from the road. Currently, they do this through the web browser on their laptops. I am trying to possible replace or supplement the laptops for the form filling. Any thoughts? Thanks, Dave Fafard - Original Message - From: Thomas Chiverton To: CF-Talk Sent: Tuesday, December 09, 2003 6:19 AM Subject: Re: CF pda types of devices On Monday 08 Dec 2003 16:40 pm, Dan Farmer wrote: so how would one detect what kind of device ( other than pc ) was accessing my site? would it just be a matter of creating a link ( flash site here | xhtml site here | PDA xhtml site here | WML site here ) You can use Apache's auto-negoatied multiviews. You can have your Application.cfm/page header swap on user_agent and/or the accept headers. I'm sure there are more :-) -- 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]
RE: Bank Of America payment integartion
ketan, is this for personal use so that you don't have to use their website? or for a client? just wondering, since I just got an acct there :) and if I could build my own web pay portal that might be easier than what they have setup to use, some of it's a bit clunky, and im fairly certain they arent going to make changes based on my ideas...altho' they should ;) ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Ketan Patel [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 7:48 AM To: CF-Talk Subject: Bank Of America payment integartion hi, has anybody done or have or know any custom tag for Bank Of America payment system integration in estore. Please let me know. thanks ketan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: I Hate QoQ
Adam Wayne Lehman wrote: So any idea why this very simple QoQ won't work? ! filter query cfquery dbtype=query name=involved SELECT isPublic FROM involved WHERE isPublic = 1 /cfquery isPublic is a valid column name, and the values are either 0 or 1. This is the error I get: Query Of Queries runtime error. Unsupported Date type conversion in Query of Queries. Probably the ugly under-the-hood typeacsting again. How about trying for a boolean: cfquery dbtype=query name=involved SELECT isPublic FROM involved WHERE isPublic = TRUE /cfquery Jochem -- When you don't want to be surprised by the revolution organize one yourself - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Referencing a .CFC in a sub directory.
So...is it that I am asking a really stupid question, or does no one know a) whether it's even possible to reference .cfcs using either CFINVOKE or CFOBJECT with a directory structure like this b) If so how to do it? Oreilly programming CFMX says this: This is known as package notation. In the Java world, it's typical to create packages for storing your class files. For example, for the example.com company we've been using throughout the book, you might create a package off the web root called com.example (webroot\com\example). In the \example subdirectory, you would categorize your CFCs according to functionality. For example, you might have a subdirectory called \utils for utility CFCs, \news for news-related CFCs, etc. To refer to CFCs in a package, you use dot notation in the component attribute, such as com.example.utils.employee to refer to the employee CFC. So I have a simple /components directory off the webroot. So components.helpdesk_users should do the trick. But it doesn't work. cfinvoke COMPONENT=components.helpdesk_users METHOD=GetUser RETURNVARIABLE=GetUserRet cfinvokeargument NAME=userid VALUE=#userid#/ /cfinvoke Produces the error: Could not find the ColdFusion Component components.helpdesk_users. Please check that the given name is correct and that the component exists. Can anyone tell me where I'm going wrong or if this is even possible? -Gel -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED] Just some additional info, I have gotten the CFCs to work perfectly via the FORM Action attribute using the html pathname of the CFC. Action="" Method=POST Works fine. Can't get the CFINVOKE to work. -Gel --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.544 / Virus Database: 338 - Release Date: 11/25/2003 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Bank Of America payment integration
This is for client.I have it working on one part of the site after struggling for couple days using form post. But now on the other sections I have to get it working using cfhttp and that's where the complication is there. Ketan Patel -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 8:22 AM To: CF-Talk Subject: RE: Bank Of America payment integartion ketan, is this for personal use so that you don't have to use their website? or for a client? just wondering, since I just got an acct there :) and if I could build my own web pay portal that might be easier than what they have setup to use, some of it's a bit clunky, and im fairly certain they arent going to make changes based on my ideas...altho' they should ;) ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Ketan Patel [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 7:48 AM To: CF-Talk Subject: Bank Of America payment integartion hi, has anybody done or have or know any custom tag for Bank Of America payment system integration in estore. Please let me know. thanks ketan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Fusebox - whats the big deal anyway?
The funny part about waiting for a big project is that small projects can commonly turn into big projects over time, I'm working on a project right now, the start of it was to come up with one report based on a criteria screen.Now the customers are so pleased with it, they want to add worksheets, more reports and the entire project has totally expanded. When the call came to expand this, the other members of my team were worried about having to rework the entire framework, but because I started it in Fusebox 4, the transition has been very simple. I was able to add a lot of functionality without introducing bugs into the original areas (even though the database schema changed). Try it out on a small project, figure out how it works, when it comes time to do your big project (or transform your small project into a large one), you'll be glad you did. Sandy Clark _ From: Chunshen (Don) Li [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:33 PM To: CF-Talk Subject: Re:Fusebox - whats the big deal anyway? Mike, I appreciate your thoughts and I agree I or one would invest time in Fusebox once a big project which heavily involves FB in one way or another is imminent. Best regards, Don I really think it depends on what sort of entity the web site is for and what they want.If you are dealing with organizations that want to use a recognized framework for web applications then I am not aware of anything that is as well distributed as Fusebox.Once we began using Fusebox (early on) we did not find any good reason not to carry on using it.Of course Don you are right many of the things Fusebox focuses on where already being used by the better CF developers but followed closely, Fusebox brings that sort of good practice to those who were not. One other point highlighted by Matt Liotta earlier in this thread, at Webapper we have seen the benefits of bringing in Fusebox developers to a Fusebox project mid-stream and were able to get them up to speed very quickly. I also think your point re an 'OO' type thinking is a thought although Fusebox is far from a true 'OO' entity.Mach-II gets much nearer but there are still limitations in CFC's that prevent CF from being a strict 'OO' language.Macromedia are using Mach-II for internal and I believe now one external part of their site.Sean Corfield of Macromedia has done a lot to improve Mach-II and has recently contributed to modifying the core after what he says was some fairly heavy load-testing of Mach-II.If you're interested you can find Sean's information on Mach-II here. http://www.corfield.org/index.php?fuseaction=machii.main Kind Regards - Mike Brunt Webapper Services LLC Web Site http://www.webapper.com Blog http://www.webapper.net Webapper Web Application Specialists -Original Message- From: Chunshen (Don) Li [mailto:[EMAIL PROTECTED] Sent: Sunday, December 07, 2003 3:03 PM To: CF-Talk Subject: Re:Fusebox - whats the big deal anyway? If the key benefit of FuseBox is about code-reuse, then, I would say, code-reuse is not unique to FuseBox.In the days before FuseBox, many of us were already practising code-reuse methodology. Probably the creator(s) of FuseBox were big into object-oriented programming, and wanted to steer the CFers towards that direction with FuseBox, but I could be totally wrong on this assumption. Don Li My very favorite feature with fusebox is only having to modify code in one place and it will apply to the entire site. Fusebox is a methodology, not a religion, therefore it is your option to develop web sites with reusable code or any other methodology that is acceptable between you and your client. == Stop spam on your domain, use our gateway! http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and PHP == If you are not satisfied with my service, my job isn't done! - Original Message - From: Gabriel Robichaud [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, December 06, 2003 12:54 PM Subject: RE: Fusebox - whats the big deal anyway? | I for one would love to see the arguments FOR using fusebox.I have been to the FB web site and I am not sure its worth the effort of learning a completely new mehtodology and reengineering my processes to fit someone elses model. I think that Dan's points are valid especially when it comes to creativity, but I am sure there are opinions, very good ones, pro FB.I just don`t see them. What I do see, is a lot of people posting questions about it on the forums that seem overly complicated, and honestly, the last thing i need is more complication in my Dev process. | | | | -Original Message- | From: Kwang Suh [mailto:[EMAIL PROTECTED] | Sent: Saturday, December 06, 2003 1:37 PM | To: CF-Talk | Subject: RE: Fusebox - whats the big deal anyway? | | | If you don't like it, don't use
RE: I Hate QoQ
How can you QofQ a query of the same name as the one you are executing? cfquery dbtype=query name=involved --- Name of Query SELECT isPublic FROM involved --- Name of query you are taking from. Change one, I'll bet your problem goes away. _ From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:55 PM To: CF-Talk Subject: I Hate QoQ So any idea why this very simple QoQ won't work? ! filter query cfquery dbtype=query name=involved SELECT isPublic FROM involved WHERE isPublic = 1 /cfquery isPublic is a valid column name, and the values are either 0 or 1. This is the error I get: Query Of Queries runtime error. Unsupported Date type conversion in Query of Queries. I've tried the follow too in case some reason it converted to string, but alas same error: ! filter query cfquery dbtype=query name=involved SELECT isPublic FROM involved WHERE isPublic = '1' /cfquery Any ideas? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Referencing a .CFC in a sub directory.
For that to work (i.e. using dot notation for CFOBJECT) you must setup a CF mapping. Action="" Method=POST will work as its IIS/Apache/Whatever handling the path to the CFC. CFINVOKE/CFOBJECT/CreateObject use CF to get the path to the CFC so either the CFC must be in the same directory as the code invoking the CFC or a CF Mapping must be setup HTH -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 9, 2003 13:28 To: CF-Talk Subject: RE: Referencing a .CFC in a sub directory. So...is it that I am asking a really stupid question, or does no one know a) whether it's even possible to reference .cfcs using either CFINVOKE or CFOBJECT with a directory structure like this b) If so how to do it? Oreilly programming CFMX says this: This is known as package notation. In the Java world, it's typical to create packages for storing your class files. For example, for the example.com company we've been using throughout the book, you might create a package off the web root called com.example (webroot\com\example). In the \example subdirectory, you would categorize your CFCs according to functionality. For example, you might have a subdirectory called \utils for utility CFCs, \news for news-related CFCs, etc. To refer to CFCs in a package, you use dot notation in the component attribute, such as com.example.utils.employee to refer to the employee CFC. So I have a simple /components directory off the webroot. So components.helpdesk_users should do the trick. But it doesn't work. cfinvoke COMPONENT=components.helpdesk_users METHOD=GetUser RETURNVARIABLE=GetUserRet cfinvokeargument NAME=userid VALUE=#userid#/ /cfinvoke Produces the error: Could not find the ColdFusion Component components.helpdesk_users. Please check that the given name is correct and that the component exists. Can anyone tell me where I'm going wrong or if this is even possible? -Gel -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED] Just some additional info, I have gotten the CFCs to work perfectly via the FORM Action attribute using the html pathname of the CFC. Action="" Method=POST Works fine. Can't get the CFINVOKE to work. -Gel --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.544 / Virus Database: 338 - Release Date: 11/25/2003 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF pda types of devices
On Tuesday 09 Dec 2003 13:22 pm, David Fafard wrote: I would be interested in having our remote sales team fill some forms from the road. Currently, they do this through the web browser on their laptops. I am trying to possible replace or supplement the laptops for the form filling. Seeing as you already have a HTML (nee CF) based solution, I'd look into adapting that. -- 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]
RE: The Value of CFQUERYPARAM
I haven't heard anyone mention the security value of cfqueryparam... using this tag will prevent someone from injecting malicious code into your queries. Consider this example: cfparam name=url.userid cfquery select id, username from people where userid = #url.userid# /cfquery If someone calls this page with the url sample.cfm?userid=1+go+delete+*+from+people there is a chance that the people table will get nuked.cfqueryparam prevents this from happening. Mark -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 6:54 PM To: CF-Talk Subject: Re: The Value of CFQUERYPARAM [EMAIL PROTECTED] wrote: I asked this question and quite a discussion broke out between the DB heavyweights (Jochem and Adam I think) Thank you :-) I've tried my best to find it in the archives but I can't for some reason. http://www.houseoffusion.com/cf_lists/index.cfm?method=messages http://www.houseoffusion.com/cf_lists/index.cfm?method=messagesthreadid=24 110forumid=4#121513 threadid=24110forumid=4#121513 I hope I am doing Adam's position justice when I summarise the debate as follows: - with cfqueryparam, changes in the value of a parameter will not lead to a recompilation (overhead) of the query execution plan in the DBMS - this is genarally a good thing, because it means a query like select * from table where id = X gets only compiled once, regardless of the value of X - therefore, if you use cfqueryparam for constants as well, the query will still be only compiled once (Adam) - but if you don't use cfqueryparam, you can force a recompilation of the query execution plan if you want so (Jochem) I am still not sure we actually disagree :-) Jochem -- When you don't want to be surprised by the revolution organize one yourself - Loesje _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
xmlSearch question
if I know that the xml is valid, why would the xmlSearch() bug out telling me this: coldfusion.runtime.CfJspPage$ComplexObjectException: Complex object types cannot be converted to simple values. cfoutput cfif len(getData.assetUpdate) cfset tony = xmlParse(getData.AssetUpdate[i]) tr td valign=top colspan=8 bgcolor=##efefb8 #xmlSearch(tony,/AssetUpdate/Id/IpAddress)# /td /tr cfelse tr td valign=top colspan=8 bgcolor=##efefb8 No Data Available /td /tr /cfif /cfoutput ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: xmlSearch question
xmlSearch always returns an array.The problem is the code is trying to convert an array to a simple value and thus the error. Instead store the result in a variable and access the first element. Best regards, Sam --- Blog: http://www.rewindlife.com Charts: http://www.blinex.com/products/charting --- -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 9:20 AM To: CF-Talk Subject: xmlSearch question if I know that the xml is valid, why would the xmlSearch() bug out telling me this: coldfusion.runtime.CfJspPage$ComplexObjectException: Complex object types cannot be converted to simple values. cfoutput cfif len(getData.assetUpdate) cfset tony = xmlParse(getData.AssetUpdate[i]) tr td valign=top colspan=8 bgcolor=##efefb8 #xmlSearch(tony,/AssetUpdate/Id/IpAddress)# /td /tr cfelse tr td valign=top colspan=8 bgcolor=##efefb8 No Data Available /td /tr /cfif /cfoutput ...tony [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: xmlSearch question
On Tuesday 09 Dec 2003 14:19 pm, Tony Weeg wrote: if I know that the xml is valid, why would the xmlSearch() bug out telling me this: coldfusion.runtime.CfJspPage$ComplexObjectException: Complex object types cannot be converted to simple values. The live docs suggest that XMLsearch returns an array - have you tried cfdump, or something like: selectedElements = XmlSearch(myxmldoc, /employee/name/last); for (i = 1; i LTE ArrayLen(selectedElements); i = i + 1) writeoutput(selectedElements[i].XmlText br); -- 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]
RE: I Hate QoQ
I'm not sure it is the problem, wouldn't it just overwrite the query? Ade -Original Message- From: Sandy Clark [mailto:[EMAIL PROTECTED] Sent: 09 December 2003 13:41 To: CF-Talk Subject: RE: I Hate QoQ How can you QofQ a query of the same name as the one you are executing? cfquery dbtype=query name=involved --- Name of Query SELECT isPublic FROM involved --- Name of query you are taking from. Change one, I'll bet your problem goes away. _ From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:55 PM To: CF-Talk Subject: I Hate QoQ So any idea why this very simple QoQ won't work? ! filter query cfquery dbtype=query name=involved SELECT isPublic FROM involved WHERE isPublic = 1 /cfquery isPublic is a valid column name, and the values are either 0 or 1. This is the error I get: Query Of Queries runtime error. Unsupported Date type conversion in Query of Queries. I've tried the follow too in case some reason it converted to string, but alas same error: ! filter query cfquery dbtype=query name=involved SELECT isPublic FROM involved WHERE isPublic = '1' /cfquery Any ideas? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: [OT] - RegExp Help
Wow.That's pretty cool.I would love to see a copy when it gets finished. --Ben doom Massimo Foti wrote: BTW Since sometimes I fund useful to access Jav's string APIs, I put together a collection of UDF inside a CFC: http://www.cfmentor.com/code/index.cfm?action=""> http://www.cfmentor.com/code/index.cfm?action=""> I am also almost finished a similar CFC that act as a wrapper for the java.util.regex package. I just need to polish it a little bit; it will available very soon. Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: [OT] - RegExp Help
Besides using regex, there's a pretty stilly way of dealing with this. Replace() all the /public/document.cfm links with just /document.cfm, then replace all the /document.cfm links with /public/document.cfm It's a bit absurd, but it's an easy, quick fix that doesn't have to invoke a regex engine. --Ben Doom A.Little wrote: Hi all, I'm trying to write a regular _expression_ and am having a little trouble... What I want to do is replace all instances of '/document.cfm' in a string with '/public/document.cfm', unless the original substring is '/public/document.cfm' - ie I don't want to end up with '/public/public/document.cfm'. This is what I;ve been trying: #ReReplace('.open.ac.uk/document.cfmtest','(^public)/document.cfm','/pu blic/document.cfm')# But in this instance it's not finding a match, so not replacing the required substring - can anyone give me any pointers as to where I;ve gone wrong? I found plenty of examples about Reg Exp generally, but none which seem to fit what I'm trying to achieve. Thanks, Alex [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: I Hate QoQ
I had some trouble getting QofQ to work with bit data types way back when.I don't think we ever resolved it and just went to tinyint in the db.Has anyone ever gotten bit datatypes to work in QofQ?Is there some work around? Thanks, -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 7:29 AM To: CF-Talk Subject: Re: I Hate QoQ Adam Wayne Lehman wrote: So any idea why this very simple QoQ won't work? ! filter query cfquery dbtype=query name=involved SELECT isPublic FROM involved WHERE isPublic = 1 /cfquery isPublic is a valid column name, and the values are either 0 or 1. This is the error I get: Query Of Queries runtime error. Unsupported Date type conversion in Query of Queries. Probably the ugly under-the-hood typeacsting again. How about trying for a boolean: cfquery dbtype=query name=involved SELECT isPublic FROM involved WHERE isPublic = TRUE /cfquery Jochem -- When you don't want to be surprised by the revolution organize one yourself - Loesje _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:network monitor
Take this example. From the below code, how do I ask ColdFusion to get me the service name (eg: service1) if the status which is displayed in a separate td tag inside the same tr block is Timed Out. TRTD bgcolor=#77FF77service1/TDTDHub/TDTD bgcolor=#77FF77Active/TDTD/TD/TR TRTD bgcolor=#FFservice2/TDTDHub/TDTD bgcolor=#FFTimed Out/TDTD/TD/TR TRTD bgcolor=#FFservice3/TDTDHub/TDTD bgcolor=#FFTimed Out/TDTD/TD/TR [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX Web Service Client - Complex Objects Hash Tables?
I'm not the developer working on this but one of my coworkers is having trouble getting a handle on how to deal with complex objects from some web service he's trying to use. Apparently the web service returns a complex object of type hash table. Does anybody have any information on how to consume such a web service with CFMX that you can send to me? Thanks... Jon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: The Value of CFQUERYPARAM
Well, the main reason we weren't discussing the security value of cfqueryparam is that we were talking about constant values that were NOT collected from a user, but rather hard coded into the query.Now user interaction usually means no opportunity for user mischief. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA -Original Message- From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 6:13 AM To: CF-Talk Subject: RE: The Value of CFQUERYPARAM I haven't heard anyone mention the security value of cfqueryparam... using this tag will prevent someone from injecting malicious code into your queries. Consider this example: cfparam name=url.userid cfquery select id, username from people where userid = #url.userid# /cfquery If someone calls this page with the url sample.cfm?userid=1+go+delete+*+from+people there is a chance that the people table will get nuked.cfqueryparam prevents this from happening. Mark -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 6:54 PM To: CF-Talk Subject: Re: The Value of CFQUERYPARAM [EMAIL PROTECTED] wrote: I asked this question and quite a discussion broke out between the DB heavyweights (Jochem and Adam I think) Thank you :-) I've tried my best to find it in the archives but I can't for some reason. http://www.houseoffusion.com/cf_lists/index.cfm?method=messages http://www.houseoffusion.com/cf_lists/index.cfm?method=messages http://www.houseoffusion.com/cf_lists/index.cfm?method=messagesthreadid=24 110forumid=4#121513 threadid=24110forumid=4#121513 I hope I am doing Adam's position justice when I summarise the debate as follows: - with cfqueryparam, changes in the value of a parameter will not lead to a recompilation (overhead) of the query execution plan in the DBMS - this is genarally a good thing, because it means a query like select * from table where id = X gets only compiled once, regardless of the value of X - therefore, if you use cfqueryparam for constants as well, the query will still be only compiled once (Adam) - but if you don't use cfqueryparam, you can force a recompilation of the query execution plan if you want so (Jochem) I am still not sure we actually disagree :-) Jochem -- When you don't want to be surprised by the revolution organize one yourself - Loesje _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
dynamic array from query
I'm trying to dynamically populate a three dimensional array from a query, the following is the code in question and the error HALLLP!!! cfquery name=qry_getProjectInfo datasource=#application.dsn# SELECT * FROM tbl_project WHERE UserID = #LoginResults.UserID# /cfquery cfif #LoginResults.recordcount# is not 0 !--- this array works --- cfset application.UserSet=ArrayNew(1) cfoutput query=LoginResults cfset application.UserSet[1] = #ProjectURL# cfset application.UserSet[2] = #UserID# /cfoutput !-- end working array --- !--- this array doesn't work --- cfset application.ProjectSet=ArrayNew(3) cfoutput query=qry_getProjectInfo cfset application.ProjectSet[ArrayLen(application.ProjectSet)+1][1]=#qry_getProjectInfo.projectID# cfset application.ProjectSet[ArrayLen(application.ProjectSet)][2]=#qry_getProjectInfo.name# cfset application.ProjectSet[ArrayLen(application.ProjectSet)][3]=#qry_getProjectInfo.url# /cfoutput !--- end fubar array !--- The error code --- A scalar value of type java.lang.Integer cannot be assigned to a 2-dimensional ColdFusion array. A ColdFusion 2-dimensional array can only hold 1-dimensional ColdFusion arrays and Java List objects. The error occurred in C:\CFusionMX\wwwroot\core\actions\act_login.cfm: line 23 21 :cfset application.ProjectSet=ArrayNew(3) 22 :cfoutput query=qry_getProjectInfo 23 :cfset application.ProjectSet[ArrayLen(application.ProjectSet)+1][1]=#qry_getProjectInfo.projectID# 24 :cfset application.ProjectSet[ArrayLen(application.ProjectSet)][2]=#qry_getProjectInfo.name# 25 :cfset application.ProjectSet[ArrayLen(application.ProjectSet)][3]=#qry_getProjectInfo.url# Scott Stewart Web Application Developer, AMTI AIR-520 (202)-385-4545 Brainbench Certified Cold Fusion 4.5 Brainbench Certified HTML 3.2 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: dynamic array from query
I'm trying to dynamically populate a three dimensional array from a query, Have you first checked cflib? There are plenty of UDFs for converting query into other data structures: http://www.cflib.org/library.cfm?ID=5 Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Looking for smarter solution
Hello All, Firstly I would like to apologize on my clients behalf, they still use Netscape 4.79 across their corporation (can't upgrade them to IE or newer version of Netscape) I have some code which works fine in IE but it causing me some headaches in netscape partly because of security reasons I have disabled all caching of pages. Here is how it works I have a select box that lists HTML reports form a directory.Then by selecting their report I send the directory and file name to a page that displays it using the form variable. Here is the select box form name=report method=post action="" target=_blank input type=Hidden name=directory value=cfoutput#directory#/cfoutput select name=filename cfset var1 = _ cfset var2 = cfset var3 = .html cfoutput cfloop query=repdir startrow=1 endrow=20 cfset dispname = #RemoveChars(repdir.name, 1, 6)# cfset dispnamefinal = #replace(dispname, var3, var2)# option value=#name##Replace(dispnamefinal, var1, var2, all)#/option !--- input type=Hidden name=dispnamefinal value=#dispnamefinal# --- /cfloop /cfoutput /select input type=Submit value=Go /form Then on my display page I do this div align=center cfif session.language eq 1 cfinclude template=#directory#/#filename# cfelse cfinclude template=#directory#_fr/#filename# /cfif /div The problem is that netscape automatically reload the page twice so what is happening is that I will see the content then I will get data missing.I you refresh the browser the content will come back.I there a better way to do this?Maybe a different scope so that when netscape reloads the varibables are still present? Thanks in advance Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF pda types of devices
We already did this sort of thing David using Flash Player 6.0 but on PC2002.I think the Treo is Palm though, am I correct? Kind Regards - Mike Brunt Webapper Services LLC Web Site http://www.webapper.com Blog http://www.webapper.net Webapper Web Application Specialists -Original Message- From: David Fafard [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 5:22 AM To: CF-Talk Subject: Re: CF pda types of devices Speaking of this, I am going to be testing the Treo 600 combination PDA, Phone device. What would be the best direction for developing a CFMX based application for this device? CFMX, Flash ? WAP? I would be interested in having our remote sales team fill some forms from the road. Currently, they do this through the web browser on their laptops. I am trying to possible replace or supplement the laptops for the form filling. Any thoughts? Thanks, Dave Fafard - Original Message - From: Thomas Chiverton To: CF-Talk Sent: Tuesday, December 09, 2003 6:19 AM Subject: Re: CF pda types of devices On Monday 08 Dec 2003 16:40 pm, Dan Farmer wrote: so how would one detect what kind of device ( other than pc ) was accessing my site? would it just be a matter of creating a link ( flash site here | xhtml site here | PDA xhtml site here | WML site here ) You can use Apache's auto-negoatied multiviews. You can have your Application.cfm/page header swap on user_agent and/or the accept headers. I'm sure there are more :-) -- 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]
CFserver and Multiple IIS virtual websites.
I'm hoping some of the experts on this list can help us out.We have always had a lot of trouble with setting up multiple websites on one server.We are having trouble with different websites using the same files. Just to be clear, WE HAVE turned of cached real path, and RESTARTED our server many times.Both virtual websites are still using the same webroot/Application.cfm file.What other causes can there be? We have looked at the jrun-web.xml file in the C:\CFusionMX\wwwroot\WEB-INF directory.It has the following virtual-mappings virtual-mapping resource-path/WEB-INF/resource-path system-pathC:/CFusionMX/wwwroot/WEB-INF/system-path /virtual-mapping virtual-mapping resource-path/*/resource-path system-pathD:/Inetpub/websites/BloodSource//system-path /virtual-mapping The second mapping points to the production/default web root.I suspect this could be at least part of the problem, but I really don't understand what this file does, where it is used in the CF server?How does this file relate to the Mappings defined in the CFAdmin, if at all?Can anybody point me to documentation that details the purpose of this file. We tried removing the second virtual-mapping and our code broke.We then tried modifying the resource-path to read resource-path/www.bloodsource.org/*/resource-path to define the production server, again this broke our code. Thanks for any and all help. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA 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]
Re: dynamic array from query
You are creating a 3d array, but only specifying 2 dimensions of it. Try creating a 2d array instead. --Ben Doom [EMAIL PROTECTED] wrote: I'm trying to dynamically populate a three dimensional array from a query, the following is the code in question and the error HALLLP!!! cfquery name=qry_getProjectInfo datasource=#application.dsn# SELECT * FROM tbl_project WHERE UserID = #LoginResults.UserID# /cfquery cfif #LoginResults.recordcount# is not 0 !--- this array works --- cfset application.UserSet=ArrayNew(1) cfoutput query=LoginResults cfset application.UserSet[1] = #ProjectURL# cfset application.UserSet[2] = #UserID# /cfoutput !-- end working array --- !--- this array doesn't work --- cfset application.ProjectSet=ArrayNew(3) cfoutput query=qry_getProjectInfo cfset application.ProjectSet[ArrayLen(application.ProjectSet)+1][1]=#qry_getProjectInfo.projectID# cfset application.ProjectSet[ArrayLen(application.ProjectSet)][2]=#qry_getProjectInfo.name# cfset application.ProjectSet[ArrayLen(application.ProjectSet)][3]=#qry_getProjectInfo.url# /cfoutput !--- end fubar array !--- The error code --- A scalar value of type java.lang.Integer cannot be assigned to a 2-dimensional ColdFusion array. A ColdFusion 2-dimensional array can only hold 1-dimensional ColdFusion arrays and Java List objects. The error occurred in C:\CFusionMX\wwwroot\core\actions\act_login.cfm: line 23 21 :cfset application.ProjectSet=ArrayNew(3) 22 :cfoutput query=qry_getProjectInfo 23 :cfset application.ProjectSet[ArrayLen(application.ProjectSet)+1][1]=#qry_getProjectInfo.projectID# 24 :cfset application.ProjectSet[ArrayLen(application.ProjectSet)][2]=#qry_getProjectInfo.name# 25 :cfset application.ProjectSet[ArrayLen(application.ProjectSet)][3]=#qry_getProjectInfo.url# Scott Stewart Web Application Developer, AMTI AIR-520 (202)-385-4545 Brainbench Certified Cold Fusion 4.5 Brainbench Certified HTML 3.2 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Refresh left frame
Hi I have Login link on left frame which opens login screen on right frame. On successfull login I want to refresh the left frame. But as I am at right frame it just refreshes right one. Reason I want to do is that some links in left are enabled only when appropriate user is logged in. Without refreshing it doesn't show the links to authorised users. Thanks Shahzad.Butt Ph:+44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF pda types of devices
Mike. Yes, Treo is Palm. Is there a flash player for Palm? I know it uses the Blazer web browser. Thanks, Dave - Original Message - From: Mike Brunt To: CF-Talk Sent: Tuesday, December 09, 2003 10:05 AM Subject: RE: CF pda types of devices We already did this sort of thing David using Flash Player 6.0 but on PC2002.I think the Treo is Palm though, am I correct? Kind Regards - Mike Brunt Webapper Services LLC Web Site http://www.webapper.com Blog http://www.webapper.net Webapper Web Application Specialists -Original Message- From: David Fafard [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 5:22 AM To: CF-Talk Subject: Re: CF pda types of devices Speaking of this, I am going to be testing the Treo 600 combination PDA, Phone device. What would be the best direction for developing a CFMX based application for this device? CFMX, Flash ? WAP? I would be interested in having our remote sales team fill some forms from the road. Currently, they do this through the web browser on their laptops. I am trying to possible replace or supplement the laptops for the form filling. Any thoughts? Thanks, Dave Fafard - Original Message - From: Thomas Chiverton To: CF-Talk Sent: Tuesday, December 09, 2003 6:19 AM Subject: Re: CF pda types of devices On Monday 08 Dec 2003 16:40 pm, Dan Farmer wrote: so how would one detect what kind of device ( other than pc ) was accessing my site? would it just be a matter of creating a link ( flash site here | xhtml site here | PDA xhtml site here | WML site here ) You can use Apache's auto-negoatied multiviews. You can have your Application.cfm/page header swap on user_agent and/or the accept headers. I'm sure there are more :-) -- 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]
RE: CFserver and Multiple IIS virtual websites.
I'm hoping some of the experts on this list can help us out. We have always had a lot of trouble with setting up multiple websites on one server. We are having trouble with different websites using the same files. Just to be clear, WE HAVE turned of cached real path, and RESTARTED our server many times. Both virtual websites are still using the same webroot/Application.cfm file. What other causes can there be? We have looked at the jrun-web.xml file in the C:\CFusionMX\wwwroot\WEB-INF directory. It has the following virtual-mappings virtual-mapping resource-path/WEB-INF/resource-path system-pathC:/CFusionMX/wwwroot/WEB-INF/system-path /virtual-mapping virtual-mapping resource-path/*/resource-path system-pathD:/Inetpub/websites/BloodSource//system-path /virtual-mapping The second mapping points to the production/default web root. I suspect this could be at least part of the problem, but I really don't understand what this file does, where it is used in the CF server?How does this file relate to the Mappings defined in the CFAdmin, if at all?Can anybody point me to documentation that details the purpose of this file. We tried removing the second virtual-mapping and our code broke. We then tried modifying the resource-path to read resource-path/www.bloodsource.org/*/resource-path to define the production server, again this broke our code. I suspect that you have the JRun web server running, in addition to IIS. I had similar problems when I did that. You can disable the JRun web server using these instructions: http://www.macromedia.com/support/coldfusion/adv_development/config_builtin_ webserver/ As for what jrun-web.xml is and what it does, you'll find all kinds of explanatory sources by just Googling for jrun-web.xml. I don't think you'll have to change it manually once you disable the JRun web server. 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]
RE: I Hate QoQ
How can you overwrite a query that you are in the process of creating? Wouldn't the cfquery tag overwrite an existing query before it got to the actual sql?In which case, wouldn't if have problems reading data from a query that is in flux? Don't know why, but building a query like this just seems to look like an infinite loop to me because even if it did work, it would always be selecting data from it's self. Just my .02 Steve -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 9:34 AM To: CF-Talk Subject: RE: I Hate QoQ I'm not sure it is the problem, wouldn't it just overwrite the query? Ade -Original Message- From: Sandy Clark [mailto:[EMAIL PROTECTED] Sent: 09 December 2003 13:41 To: CF-Talk Subject: RE: I Hate QoQ How can you QofQ a query of the same name as the one you are executing? cfquery dbtype=query name=involved --- Name of Query SELECT isPublic FROM involved --- Name of query you are taking from. Change one, I'll bet your problem goes away. _ From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:55 PM To: CF-Talk Subject: I Hate QoQ So any idea why this very simple QoQ won't work? ! filter query cfquery dbtype=query name=involved SELECT isPublic FROM involved WHERE isPublic = 1 /cfquery isPublic is a valid column name, and the values are either 0 or 1. This is the error I get: Query Of Queries runtime error. Unsupported Date type conversion in Query of Queries. I've tried the follow too in case some reason it converted to string, but alas same error: ! filter query cfquery dbtype=query name=involved SELECT isPublic FROM involved WHERE isPublic = '1' /cfquery Any ideas? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Refresh left frame
top.frames['FRAMENAME'].location=PAGE' or top.frames['FRAMENAME'].reload() or refresh(); -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 10:25 AM To: CF-Talk Subject: Refresh left frame Hi I have Login link on left frame which opens login screen on right frame. On successfull login I want to refresh the left frame. But as I am at right frame it just refreshes right one. Reason I want to do is that some links in left are enabled only when appropriate user is logged in. Without refreshing it doesn't show the links to authorised users. Thanks Shahzad.Butt Ph:+44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Flash Instant Messenger Software?
Not Flash, but well designed. Has everything you are wanting: 1-on-1 conversation, logs, ability to manage multiple conversations, ability to push information including web pages and attachments to customer: http://www.groopz.com/ http://www.groopz.com/ -Original Message- From: cf-talk [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 6:52 PM To: CF-Talk Subject: RE: Flash Instant Messenger Software? Hi John, Actually the intranet in question deals with financing.Clients log into the portal and submit their deals.If they need help they click on the Live Help link and chat with a company representative.Due to the nature of communications a chat room wouldn't work.It needs to be a one-on-one conversation.The company representative might have 4-5 windows open for chatting but from the client's perspective it's a one-on-one chat. It's really nothing more than a Flash movie using ColdFusion as middleware to do SQL selects and inserts from a database table.Some might argue that using session/client variables would be better... but for corporate reasons we wish to keep a 14 day (configurable of course) log of all conversations. -Novak -Original Message- From: John Dowdell [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:38 PM To: CF-Talk Subject: Re: Flash Instant Messenger Software? At 12:43 PM 12/8/3, cf-talk wrote: Does anyone know of some cheap/free instant messenger software thatcan embed in a ColdFusion intranet application? If it's page-based, on an intranet, then I'm assuming a chat app would work as well as an IM app...? (A chat is a place you go where you can communicate with anyone also there... in IM you set up a whitelist of people you feel safe communicating with. The combo of intranet and being in a page seems an effective whitelist.) You'd need both a client component and a server component in either case. I'm not sure which of each might be best for your situation. The following two Google terms turn up hits: site:macromedia.com inurl:devnet chat site:macromedia.com inurl:devnet instant messenger The search engine at http://www.macromedia.com/go/weblogs http://www.macromedia.com/go/weblogscan turn up current discussions on such subjects too. Do any of these help define the project...? jd John Dowdell, Macromedia Developer Support, San Francisco (Best to reply on-list, to avoid my mighty spam filters!) Technotes: http://www.macromedia.com/support/search/ http://www.macromedia.com/support/search/ Column: http://www.macromedia.com/desdev/jd_forum/ http://www.macromedia.com/desdev/jd_forum/ Technical daily diary: http://www.macromedia.com/go/blog_jd http://www.macromedia.com/go/blog_jd _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Refresh left frame
You should be able to use a _javascript_ call referencing the alternate frame's name and replacing the source with a new call that will cause the frame to load the new page. Hatton _ From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 10:25 AM To: CF-Talk Subject: Refresh left frame Hi I have Login link on left frame which opens login screen on right frame. On successfull login I want to refresh the left frame. But as I am at right frame it just refreshes right one. Reason I want to do is that some links in left are enabled only when appropriate user is logged in. Without refreshing it doesn't show the links to authorised users. Thanks Shahzad.Butt Ph:+44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 _ [HYPERLINK http://www.houseoffusion.com/lists.cfm?link=t:4Todays Threads] [HYPERLINK http://www.houseoffusion.com/lists.cfm?link=i:4:146555This Message] [HYPERLINK http://www.houseoffusion.com/lists.cfm?link=s:4Subscription] [HYPERLINK http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=2581.2460.4Fast Unsubscribe] [HYPERLINK http://www.houseoffusion.com/signin/User Settings] _ HYPERLINK http://www.houseoffusion.com/banners/view.cfm?bannerid=33 \n --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.543 / Virus Database: 337 - Release Date: 11/21/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.543 / Virus Database: 337 - Release Date: 11/21/2003 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: I Hate QoQ
The dump shows everything as expected: query COURSEID ENDDATE FACULTY ISPUBLIC OFFERINGID STARTDATE TITLE URL USERLEVEL 1 103 2003-12-19 00:00:00.0 Segui-Gomez 1 111 2003-10-27 00:00:00.0 Confronting the Burden of Injuries http://distance.jhsph.edu/burden/ 60 2 83 2003-12-19 00:00:00.0 Reinke, Tayback 1 105 2003-09-02 00:00:00.0 Health Administration Statistics http://distance.jhsph.edu/has/ 60 I think the issue may be that this query is hand-rolled in CF with queryNew() and querySetCell() rather than coming directly from a datasource. Regardless of whether I treat isPublic as numeric or string I get the error. Are there any know issues with using query of query with a query created in CF? Being that I create the query myself there is now way for isPublic = NULL. The following query throws the same error, even without a WHERE clause! cfquery dbtype=query name=involved SELECT * FROM involved /cfquery As for naming the QoQ after the same query I am querying, I've used this method before to filter queries without problem. Just to be sure however I've chanced the query name to be separate from the new query.. still got the error. So I'm getting the feeling that you can't run a QoQ on a query that CF created. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:54 PM To: CF-Talk Subject: RE: I Hate QoQ whats a cfdump of the original query return? ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:55 PM To: CF-Talk Subject: I Hate QoQ So any idea why this very simple QoQ won't work? ! filter query cfquery dbtype=query name=involved SELECT isPublic FROM involved WHERE isPublic = 1 /cfquery isPublic is a valid column name, and the values are either 0 or 1. This is the error I get: Query Of Queries runtime error. Unsupported Date type conversion in Query of Queries. I've tried the follow too in case some reason it converted to string, but alas same error: ! filter query cfquery dbtype=query name=involved SELECT isPublic FROM involved WHERE isPublic = '1' /cfquery Any ideas? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: I Hate QoQ
No it's def doable. I actually do it all the time to save variable namespace. I'm not an expert but I assume that it creates an instance of query then overwrites the original query when it's completed. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 10:34 AM To: CF-Talk Subject: RE: I Hate QoQ How can you overwrite a query that you are in the process of creating? Wouldn't the cfquery tag overwrite an existing query before it got to the actual sql?In which case, wouldn't if have problems reading data from a query that is in flux? Don't know why, but building a query like this just seems to look like an infinite loop to me because even if it did work, it would always be selecting data from it's self. Just my .02 Steve -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 9:34 AM To: CF-Talk Subject: RE: I Hate QoQ I'm not sure it is the problem, wouldn't it just overwrite the query? Ade -Original Message- From: Sandy Clark [mailto:[EMAIL PROTECTED] Sent: 09 December 2003 13:41 To: CF-Talk Subject: RE: I Hate QoQ How can you QofQ a query of the same name as the one you are executing? cfquery dbtype=query name=involved --- Name of Query SELECT isPublic FROM involved --- Name of query you are taking from. Change one, I'll bet your problem goes away. _ From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:55 PM To: CF-Talk Subject: I Hate QoQ So any idea why this very simple QoQ won't work? ! filter query cfquery dbtype=query name=involved SELECT isPublic FROM involved WHERE isPublic = 1 /cfquery isPublic is a valid column name, and the values are either 0 or 1. This is the error I get: Query Of Queries runtime error. Unsupported Date type conversion in Query of Queries. I've tried the follow too in case some reason it converted to string, but alas same error: ! filter query cfquery dbtype=query name=involved SELECT isPublic FROM involved WHERE isPublic = '1' /cfquery Any ideas? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division _ _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF pda types of devices
Speaking of this, I am going to be testing the Treo 600 combination PDA, Phone device. What would be the best direction for developing a CFMX based application for this device? CFMX, Flash ? WAP? I would be interested in having our remote sales team fill some forms from the road. Currently, they do this through the web browser on their laptops. I am trying to possible replace or supplement the laptops for the form filling. If you can count on reliable network connectivity any time (which you should be able to do with a Treo, since it's a phone), I'd recommend that you look at an HTML-based solution. I'm pretty sure that the devices will have some sort of HTML client, but even if they don't you should be able to provide one. Flash probably won't work for you since the Flash player may not be available on the Treo, and even if it is, it'll probably be a version behind. Flash Player 6 is available for Pocket PC devices, but I think you have to have PalmOS 5 to get any Flash player for the Palm. I'm not 100% sure about which versions are available for which platforms, though. According to this, you're out of luck: http://www.macromedia.com/software/devices/supported/ If you can't count on reliable network connectivity, and you need a solution which will allow the user to capture data while offline, you'll probably need to write a native Palm application. If you know VB, you might take a look at AppForge: http://www.appforge.com/ You'd then have to handle synchronization with servers from your application, but you might be able to do this nicely through web services (I don't know how well this would work, but it does work nicely on Pocket PC using .NET Compact Framework). 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]
RE: I Hate QoQ
Try it for yourself, it does overwrite it. The assignment must happen as the final process. You're assuming an empty query is created and assigned to the query name, then the query is populated, I doubt this is the case. It's more likely to be that the query is returned in full then assigned to a reference. Ade -Original Message- From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: 09 December 2003 15:34 To: CF-Talk Subject: RE: I Hate QoQ How can you overwrite a query that you are in the process of creating? Wouldn't the cfquery tag overwrite an existing query before it got to the actual sql?In which case, wouldn't if have problems reading data from a query that is in flux? Don't know why, but building a query like this just seems to look like an infinite loop to me because even if it did work, it would always be selecting data from it's self. Just my .02 Steve -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 9:34 AM To: CF-Talk Subject: RE: I Hate QoQ I'm not sure it is the problem, wouldn't it just overwrite the query? Ade -Original Message- From: Sandy Clark [mailto:[EMAIL PROTECTED] Sent: 09 December 2003 13:41 To: CF-Talk Subject: RE: I Hate QoQ How can you QofQ a query of the same name as the one you are executing? cfquery dbtype=query name=involved --- Name of Query SELECT isPublic FROM involved --- Name of query you are taking from. Change one, I'll bet your problem goes away. _ From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:55 PM To: CF-Talk Subject: I Hate QoQ So any idea why this very simple QoQ won't work? ! filter query cfquery dbtype=query name=involved SELECT isPublic FROM involved WHERE isPublic = 1 /cfquery isPublic is a valid column name, and the values are either 0 or 1. This is the error I get: Query Of Queries runtime error. Unsupported Date type conversion in Query of Queries. I've tried the follow too in case some reason it converted to string, but alas same error: ! filter query cfquery dbtype=query name=involved SELECT isPublic FROM involved WHERE isPublic = '1' /cfquery Any ideas? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division _ _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: I Hate QoQ
Just for quell and speculation the following query throws the error: ! filter query cfquery dbtype=query name=myBrandNewQuery SELECT * FROM involved /cfquery Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 10:34 AM To: CF-Talk Subject: RE: I Hate QoQ How can you overwrite a query that you are in the process of creating? Wouldn't the cfquery tag overwrite an existing query before it got to the actual sql?In which case, wouldn't if have problems reading data from a query that is in flux? Don't know why, but building a query like this just seems to look like an infinite loop to me because even if it did work, it would always be selecting data from it's self. Just my .02 Steve -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 9:34 AM To: CF-Talk Subject: RE: I Hate QoQ I'm not sure it is the problem, wouldn't it just overwrite the query? Ade -Original Message- From: Sandy Clark [mailto:[EMAIL PROTECTED] Sent: 09 December 2003 13:41 To: CF-Talk Subject: RE: I Hate QoQ How can you QofQ a query of the same name as the one you are executing? cfquery dbtype=query name=involved --- Name of Query SELECT isPublic FROM involved --- Name of query you are taking from. Change one, I'll bet your problem goes away. _ From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:55 PM To: CF-Talk Subject: I Hate QoQ So any idea why this very simple QoQ won't work? ! filter query cfquery dbtype=query name=involved SELECT isPublic FROM involved WHERE isPublic = 1 /cfquery isPublic is a valid column name, and the values are either 0 or 1. This is the error I get: Query Of Queries runtime error. Unsupported Date type conversion in Query of Queries. I've tried the follow too in case some reason it converted to string, but alas same error: ! filter query cfquery dbtype=query name=involved SELECT isPublic FROM involved WHERE isPublic = '1' /cfquery Any ideas? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division _ _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: I Hate QoQ
SInce you're creating the query yourself with CF and CF doesn't care about dataatypes, have you tried using single quotes around the qualifier in your SQL? Perhaps the column you're selecting from isn't an int datatype in this case and needs the quotes. (Just a guess) cfquery dbtype=query name=involved SELECT isPublic FROM involved WHERE isPublic = '1' /cfquery Greg -Original Message- From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 10:44 AM To: CF-Talk Subject: RE: I Hate QoQ The dump shows everything as expected: query COURSEID ENDDATE FACULTY ISPUBLIC OFFERINGID STARTDATE TITLE URL USERLEVEL 1 103 2003-12-19 00:00:00.0 Segui-Gomez 1 111 2003-10-27 00:00:00.0 Confronting the Burden of Injuries http://distance.jhsph.edu/burden/ 60 2 83 2003-12-19 00:00:00.0 Reinke, Tayback 1 105 2003-09-02 00:00:00.0 Health Administration Statistics http://distance.jhsph.edu/has/ 60 I think the issue may be that this query is hand-rolled in CF with queryNew() and querySetCell() rather than coming directly from a datasource. Regardless of whether I treat isPublic as numeric or string I get the error. Are there any know issues with using query of query with a query created in CF? Being that I create the query myself there is now way for isPublic = NULL. The following query throws the same error, even without a WHERE clause! cfquery dbtype=query name=involved SELECT * FROM involved /cfquery As for naming the QoQ after the same query I am querying, I've used this method before to filter queries without problem. Just to be sure however I've chanced the query name to be separate from the new query.. still got the error. So I'm getting the feeling that you can't run a QoQ on a query that CF created. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:54 PM To: CF-Talk Subject: RE: I Hate QoQ whats a cfdump of the original query return? ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:55 PM To: CF-Talk Subject: I Hate QoQ So any idea why this very simple QoQ won't work? ! filter query isPublic is a valid column name, and the values are either 0 or 1. This is the error I get: Query Of Queries runtime error. Unsupported Date type conversion in Query of Queries. I've tried the follow too in case some reason it converted to string, but alas same error: ! filter query cfquery dbtype=query name=involved SELECT isPublic FROM involved WHERE isPublic = '1' /cfquery Any ideas? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: I Hate QoQ
Thanks, helps getting my head around how it works. Steve -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 10:47 AM To: CF-Talk Subject: RE: I Hate QoQ Try it for yourself, it does overwrite it. The assignment must happen as the final process. You're assuming an empty query is created and assigned to the query name, then the query is populated, I doubt this is the case. It's more likely to be that the query is returned in full then assigned to a reference. Ade -Original Message- From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: 09 December 2003 15:34 To: CF-Talk Subject: RE: I Hate QoQ How can you overwrite a query that you are in the process of creating? Wouldn't the cfquery tag overwrite an existing query before it got to the actual sql?In which case, wouldn't if have problems reading data from a query that is in flux? Don't know why, but building a query like this just seems to look like an infinite loop to me because even if it did work, it would always be selecting data from it's self. Just my .02 Steve -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 9:34 AM To: CF-Talk Subject: RE: I Hate QoQ I'm not sure it is the problem, wouldn't it just overwrite the query? Ade -Original Message- From: Sandy Clark [mailto:[EMAIL PROTECTED] Sent: 09 December 2003 13:41 To: CF-Talk Subject: RE: I Hate QoQ How can you QofQ a query of the same name as the one you are executing? cfquery dbtype=query name=involved --- Name of Query SELECT isPublic FROM involved --- Name of query you are taking from. Change one, I'll bet your problem goes away. _ From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:55 PM To: CF-Talk Subject: I Hate QoQ So any idea why this very simple QoQ won't work? ! filter query cfquery dbtype=query name=involved SELECT isPublic FROM involved WHERE isPublic = 1 /cfquery isPublic is a valid column name, and the values are either 0 or 1. This is the error I get: Query Of Queries runtime error. Unsupported Date type conversion in Query of Queries. I've tried the follow too in case some reason it converted to string, but alas same error: ! filter query cfquery dbtype=query name=involved SELECT isPublic FROM involved WHERE isPublic = '1' /cfquery Any ideas? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division _ _ _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFserver and Multiple IIS virtual websites.
Thanks for the suggestion.We were not aware of this potential problem, but when we go to the jrun.xml file to disable the built-in web server, we find it is already disabled.So doesn't look like this is the root problem. Any other suggestions. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA As for what jrun-web.xml is and what it does, you'll find all kinds of explanatory sources by just Googling for jrun-web.xml. I don't think you'll have to change it manually once you disable the JRun web server. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF pda types of devices
Thanks Dave that is good information. If all possible I would like to avoid synchronization and rely on real time access... like you said, it's a phone so where there is a signal there would be access. I already have a CMFX web based solution, so maybe reformatting that would be the easier task. Reading up more on the Treo 600, I have found that the browser ( Blazer ) will either reformat the page or offer full size with vertical and horizontal scrolling, The Blazer also offers _javascript_ support. Speaking of devices that combine web browsing with phone and a keyboard ( like the Treo 600 ) is there anything else out there comparable to this phone? Thanks, Dave Fafard - Original Message - From: Dave Watts To: CF-Talk Sent: Tuesday, December 09, 2003 10:50 AM Subject: RE: CF pda types of devices Speaking of this, I am going to be testing the Treo 600 combination PDA, Phone device. What would be the best direction for developing a CFMX based application for this device? CFMX, Flash ? WAP? I would be interested in having our remote sales team fill some forms from the road. Currently, they do this through the web browser on their laptops. I am trying to possible replace or supplement the laptops for the form filling. If you can count on reliable network connectivity any time (which you should be able to do with a Treo, since it's a phone), I'd recommend that you look at an HTML-based solution. I'm pretty sure that the devices will have some sort of HTML client, but even if they don't you should be able to provide one. Flash probably won't work for you since the Flash player may not be available on the Treo, and even if it is, it'll probably be a version behind. Flash Player 6 is available for Pocket PC devices, but I think you have to have PalmOS 5 to get any Flash player for the Palm. I'm not 100% sure about which versions are available for which platforms, though. According to this, you're out of luck: http://www.macromedia.com/software/devices/supported/ If you can't count on reliable network connectivity, and you need a solution which will allow the user to capture data while offline, you'll probably need to write a native Palm application. If you know VB, you might take a look at AppForge: http://www.appforge.com/ You'd then have to handle synchronization with servers from your application, but you might be able to do this nicely through web services (I don't know how well this would work, but it does work nicely on Pocket PC using .NET Compact Framework). 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]
Query of a text file
I am Stuck .. can someone help? I am getting this error: Attribute validation error for tag cfoutput. The value of the attribute query, which is currently thefile, is invalid. this is the text filetop of the text file: Code,page,title,unit,price 884,248,LIGHTED ROSE BASKET,1 EA,9.95 1402,194,3 PC BRASS BUTTERFLY WALL SET,1 SET,6.30 1506,91,BRASS/SHIPS CARGO LANTERN,1 EA,53.30 1875,175,10 PC PORC COBALT BLUE TEA SET,1 SET,3.65 1932,54,CHILDREN'S PLAQUE,1 EA,2.65 2018,303,100 BR/BELL WIND CHM,1 EA,2.95 This is the code: !--- Get the file --- cfhttp url=""> method=GET Name=thefile /cfhttp !--- Output the file --- cfoutput query=thefile codeb#code#/b /cfoutput Are you paying more than $9.99 for internet? Then you are paying too much! http://bizovation.speedydialup.net [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: I Hate QoQ
Yup. Still got there error. If you noticed in my message even a query without a WHERE clause throws the error! Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 10:47 AM To: CF-Talk Subject: RE: I Hate QoQ SInce you're creating the query yourself with CF and CF doesn't care about dataatypes, have you tried using single quotes around the qualifier in your SQL? Perhaps the column you're selecting from isn't an int datatype in this case and needs the quotes. (Just a guess) cfquery dbtype=query name=involved SELECT isPublic FROM involved WHERE isPublic = '1' /cfquery Greg -Original Message- From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 10:44 AM To: CF-Talk Subject: RE: I Hate QoQ The dump shows everything as expected: query COURSEID ENDDATE FACULTY ISPUBLIC OFFERINGID STARTDATE TITLE URL USERLEVEL 1 103 2003-12-19 00:00:00.0 Segui-Gomez 1 111 2003-10-27 00:00:00.0 Confronting the Burden of Injuries http://distance.jhsph.edu/burden/ 60 2 83 2003-12-19 00:00:00.0 Reinke, Tayback 1 105 2003-09-02 00:00:00.0 Health Administration Statistics http://distance.jhsph.edu/has/ 60 I think the issue may be that this query is hand-rolled in CF with queryNew() and querySetCell() rather than coming directly from a datasource. Regardless of whether I treat isPublic as numeric or string I get the error. Are there any know issues with using query of query with a query created in CF? Being that I create the query myself there is now way for isPublic = NULL. The following query throws the same error, even without a WHERE clause! cfquery dbtype=query name=involved SELECT * FROM involved /cfquery As for naming the QoQ after the same query I am querying, I've used this method before to filter queries without problem. Just to be sure however I've chanced the query name to be separate from the new query.. still got the error. So I'm getting the feeling that you can't run a QoQ on a query that CF created. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:54 PM To: CF-Talk Subject: RE: I Hate QoQ whats a cfdump of the original query return? ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:55 PM To: CF-Talk Subject: I Hate QoQ So any idea why this very simple QoQ won't work? ! filter query isPublic is a valid column name, and the values are either 0 or 1. This is the error I get: Query Of Queries runtime error. Unsupported Date type conversion in Query of Queries. I've tried the follow too in case some reason it converted to string, but alas same error: ! filter query cfquery dbtype=query name=involved SELECT isPublic FROM involved WHERE isPublic = '1' /cfquery Any ideas? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT:sql Row Error Msg?
Ok this is a new one for me!I have a table that users add plans to. Because each section of the plan can be extensive each field is 4000 characters long. I have one user who is having a problem.He said when he went to edit the last field e received the following error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot create a row of size 8063 which is greater than the allowable maximum of 8060. So this has to actually do with a SQL row character maximum?(Its' SQL2000) I retried entering the plan in the test environment and had the same issue. I then tried to do an edit from sql query analyzer and got the same message. Anyone know about this- how to work around it? Thanks, J [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF pda types of devices
On Tuesday 09 Dec 2003 15:54 pm, David Fafard wrote: Speaking of devices that combine web browsing with phone and a keyboard ( like the Treo 600 ) is there anything else out there comparable to this phone? Several - blackberry do a nice range, and I'm sure theregister.co.uk had a recent Vodafone with a 640x480 screen and keyboard. Me, I have a P900 - no keyboard but the handwriting recognition works well and fast :-) -- 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]
RE: Query of a text file
Well First of all use this #cfhttp.filecontent# to see what is in the file. If you need to loop through those contents you will have to do something like this: cfloop list=# cfhttp .fileContents# index=line delimiters=#chr(10)##chr(13)# This assumes this is a list separated and users vbcrlf for line ends. You can play around with it if need be. Inside the cfloop just output #line# to see the contents of the current row. You could also assign values or store in a DB at that point as well.. Steve -Original Message- From: Jim T [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 10:55 AM To: CF-Talk Subject: Query of a text file I am Stuck .. can someone help? I am getting this error: Attribute validation error for tag cfoutput. The value of the attribute query, which is currently thefile, is invalid. this is the text filetop of the text file: Code,page,title,unit,price 884,248,LIGHTED ROSE BASKET,1 EA,9.95 1402,194,3 PC BRASS BUTTERFLY WALL SET,1 SET,6.30 1506,91,BRASS/SHIPS CARGO LANTERN,1 EA,53.30 1875,175,10 PC PORC COBALT BLUE TEA SET,1 SET,3.65 1932,54,CHILDREN'S PLAQUE,1 EA,2.65 2018,303,100 BR/BELL WIND CHM,1 EA,2.95 This is the code: !--- Get the file --- cfhttp url=""> method=GET Name=thefile /cfhttp !--- Output the file --- cfoutput query=thefile codeb#code#/b /cfoutput Are you paying more than $9.99 for internet? Then you are paying too much! http://bizovation.speedydialup.net http://bizovation.speedydialup.net _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: I Hate QoQ
I'm not sure if you posted it already, but could we get a look at your code that creates the query, I put together one and I can QofQ it as normal. Ade -Original Message- From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: 09 December 2003 16:00 To: CF-Talk Subject: RE: I Hate QoQ Yup. Still got there error. If you noticed in my message even a query without a WHERE clause throws the error! Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 10:47 AM To: CF-Talk Subject: RE: I Hate QoQ SInce you're creating the query yourself with CF and CF doesn't care about dataatypes, have you tried using single quotes around the qualifier in your SQL? Perhaps the column you're selecting from isn't an int datatype in this case and needs the quotes. (Just a guess) cfquery dbtype=query name=involved SELECT isPublic FROM involved WHERE isPublic = '1' /cfquery Greg -Original Message- From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 10:44 AM To: CF-Talk Subject: RE: I Hate QoQ The dump shows everything as expected: query COURSEID ENDDATE FACULTY ISPUBLIC OFFERINGID STARTDATE TITLE URL USERLEVEL 1 103 2003-12-19 00:00:00.0 Segui-Gomez 1 111 2003-10-27 00:00:00.0 Confronting the Burden of Injuries http://distance.jhsph.edu/burden/ http://distance.jhsph.edu/burden/ 60 2 83 2003-12-19 00:00:00.0 Reinke, Tayback 1 105 2003-09-02 00:00:00.0 Health Administration Statistics http://distance.jhsph.edu/has/ http://distance.jhsph.edu/has/ 60 I think the issue may be that this query is hand-rolled in CF with queryNew() and querySetCell() rather than coming directly from a datasource. Regardless of whether I treat isPublic as numeric or string I get the error. Are there any know issues with using query of query with a query created in CF? Being that I create the query myself there is now way for isPublic = NULL. The following query throws the same error, even without a WHERE clause! cfquery dbtype=query name=involved SELECT * FROM involved /cfquery As for naming the QoQ after the same query I am querying, I've used this method before to filter queries without problem. Just to be sure however I've chanced the query name to be separate from the new query.. still got the error. So I'm getting the feeling that you can't run a QoQ on a query that CF created. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:54 PM To: CF-Talk Subject: RE: I Hate QoQ whats a cfdump of the original query return? ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:55 PM To: CF-Talk Subject: I Hate QoQ So any idea why this very simple QoQ won't work? ! filter query isPublic is a valid column name, and the values are either 0 or 1. This is the error I get: Query Of Queries runtime error. Unsupported Date type conversion in Query of Queries. I've tried the follow too in case some reason it converted to string, but alas same error: ! filter query cfquery dbtype=query name=involved SELECT isPublic FROM involved WHERE isPublic = '1' /cfquery Any ideas? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division _ _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: sql Row Error Msg?
I am pretty sure that SQL Server has a maximum size for each row.The only work aroudn would be changing the field do clob, because then that limit does not apply. -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 10:57 AM To: CF-Talk Subject: OT:sql Row Error Msg? Ok this is a new one for me!I have a table that users add plans to. Because each section of the plan can be extensive each field is 4000 characters long. I have one user who is having a problem.He said when he went to edit the last field e received the following error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot create a row of size 8063 which is greater than the allowable maximum of 8060. So this has to actually do with a SQL row character maximum?(Its' SQL2000) I retried entering the plan in the test environment and had the same issue. I then tried to do an edit from sql query analyzer and got the same message. Anyone know about this- how to work around it? Thanks, J _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Query of a text file
But I only want to output code and price -Original Message- From: Schuster, Steven [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 9:09 AM To: CF-Talk Subject: RE: Query of a text file Well First of all use this #cfhttp.filecontent# to see what is in the file. If you need to loop through those contents you will have to do something like this: cfloop list=# cfhttp .fileContents# index=line delimiters=#chr(10)##chr(13)# This assumes this is a list separated and users vbcrlf for line ends. You can play around with it if need be. Inside the cfloop just output #line# to see the contents of the current row. You could also assign values or store in a DB at that point as well.. Steve -Original Message- From: Jim T [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 10:55 AM To: CF-Talk Subject: Query of a text file I am Stuck .. can someone help? I am getting this error: Attribute validation error for tag cfoutput. The value of the attribute query, which is currently thefile, is invalid. this is the text filetop of the text file: Code,page,title,unit,price 884,248,LIGHTED ROSE BASKET,1 EA,9.95 1402,194,3 PC BRASS BUTTERFLY WALL SET,1 SET,6.30 1506,91,BRASS/SHIPS CARGO LANTERN,1 EA,53.30 1875,175,10 PC PORC COBALT BLUE TEA SET,1 SET,3.65 1932,54,CHILDREN'S PLAQUE,1 EA,2.65 2018,303,100 BR/BELL WIND CHM,1 EA,2.95 This is the code: !--- Get the file --- cfhttp url=""> method=GET Name=thefile /cfhttp !--- Output the file --- cfoutput query=thefile codeb#code#/b /cfoutput Are you paying more than $9.99 for internet? Then you are paying too much! http://bizovation.speedydialup.net http://bizovation.speedydialup.net _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
cfc questions
Hi, I would like to build a cffunction within a CFC that will work with either a Flash front end or a cfml front end. In other words, I do not want to have to worry about modifying the cffunction at all, and be able to call it from either Flash or a cfml template. (The functions themselves are mostly for db interaction.) Is this possible? I will be building my CFCs to initially work with the cfml front end, being mindful that the Flash front end is next. My main concerns are the returntype and access attributes in the cffunctions as well as the cfargument tags. If such front ends require different values for these attributes, can I make them dynamic and pass them in accordingly, or should I just create different cffunctions? I'm operating on the following assumptions, which may or may not be correct: From what I can tell, any function that works with Flash Remoting requires an access value of remote, whereas a cffunction interacting with a cfm template does not, and in fact will not work with an access=remote value. Also , the Flash remoting app requires you to use cfargument tags before inserting them into the db, where the cfm front end does not, nor does it have any returntype or access attributes. It basically requires less to work. For example, for a db insert, can I create one cffunction with a returntype of any, an access value dynamically inserted (or remote if it'll work), and cfargument tags for all data passed in, and use it from both? Thanks in advance for any assistance. Sincerely, Andrew [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: I Hate QoQ
Try casting the isPublic from the original query into an int. Select Cast(isPublic as int) as isPublic _ From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 11:00 AM To: CF-Talk Subject: RE: I Hate QoQ Yup. Still got there error. If you noticed in my message even a query without a WHERE clause throws the error! Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 10:47 AM To: CF-Talk Subject: RE: I Hate QoQ SInce you're creating the query yourself with CF and CF doesn't care about dataatypes, have you tried using single quotes around the qualifier in your SQL? Perhaps the column you're selecting from isn't an int datatype in this case and needs the quotes. (Just a guess) cfquery dbtype=query name=involved SELECT isPublic FROM involved WHERE isPublic = '1' /cfquery Greg -Original Message- From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 10:44 AM To: CF-Talk Subject: RE: I Hate QoQ The dump shows everything as expected: query COURSEID ENDDATE FACULTY ISPUBLIC OFFERINGID STARTDATE TITLE URL USERLEVEL 1 103 2003-12-19 00:00:00.0 Segui-Gomez 1 111 2003-10-27 00:00:00.0 Confronting the Burden of Injuries http://distance.jhsph.edu/burden/ 60 2 83 2003-12-19 00:00:00.0 Reinke, Tayback 1 105 2003-09-02 00:00:00.0 Health Administration Statistics http://distance.jhsph.edu/has/ 60 I think the issue may be that this query is hand-rolled in CF with queryNew() and querySetCell() rather than coming directly from a datasource. Regardless of whether I treat isPublic as numeric or string I get the error. Are there any know issues with using query of query with a query created in CF? Being that I create the query myself there is now way for isPublic = NULL. The following query throws the same error, even without a WHERE clause! cfquery dbtype=query name=involved SELECT * FROM involved /cfquery As for naming the QoQ after the same query I am querying, I've used this method before to filter queries without problem. Just to be sure however I've chanced the query name to be separate from the new query.. still got the error. So I'm getting the feeling that you can't run a QoQ on a query that CF created. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:54 PM To: CF-Talk Subject: RE: I Hate QoQ whats a cfdump of the original query return? ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:55 PM To: CF-Talk Subject: I Hate QoQ So any idea why this very simple QoQ won't work? ! filter query isPublic is a valid column name, and the values are either 0 or 1. This is the error I get: Query Of Queries runtime error. Unsupported Date type conversion in Query of Queries. I've tried the follow too in case some reason it converted to string, but alas same error: ! filter query cfquery dbtype=query name=involved SELECT isPublic FROM involved WHERE isPublic = '1' /cfquery Any ideas? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division _ _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
isXMLDOC
what kind of xml document does this function have to see to return a 1? tony human1/human /tony shouldn't something that simple work? ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF pda types of devices
Yes, Treo is Palm. There is a Flash Player on the Clie, but not on the Treo. The browser on the Treo supports WML, XHTML, HTML 4, CSS, and _javascript_. -Kevin - Original Message - From: Mike Brunt [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 9:05 AM Subject: RE: CF pda types of devices We already did this sort of thing David using Flash Player 6.0 but on PC2002.I think the Treo is Palm though, am I correct? Kind Regards - Mike Brunt Webapper Services LLC Web Site http://www.webapper.com Blog http://www.webapper.net Webapper Web Application Specialists -Original Message- From: David Fafard [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 5:22 AM To: CF-Talk Subject: Re: CF pda types of devices Speaking of this, I am going to be testing the Treo 600 combination PDA, Phone device. What would be the best direction for developing a CFMX based application for this device? CFMX, Flash ? WAP? I would be interested in having our remote sales team fill some forms from the road. Currently, they do this through the web browser on their laptops. I am trying to possible replace or supplement the laptops for the form filling. Any thoughts? Thanks, Dave Fafard - Original Message - From: Thomas Chiverton To: CF-Talk Sent: Tuesday, December 09, 2003 6:19 AM Subject: Re: CF pda types of devices On Monday 08 Dec 2003 16:40 pm, Dan Farmer wrote: so how would one detect what kind of device ( other than pc ) was accessing my site? would it just be a matter of creating a link ( flash site here | xhtml site here | PDA xhtml site here | WML site here ) You can use Apache's auto-negoatied multiviews. You can have your Application.cfm/page header swap on user_agent and/or the accept headers. I'm sure there are more :-) -- 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]
RE: cfc questions
I would like to build a cffunction within a CFC that will work with either a Flash front end or a cfml front end. In other words, I do not want to have to worry about modifying the cffunction at all, and be able to call it from either Flash or a cfml template. (The functions themselves are mostly for db interaction.) Is this possible? I will be Yes, if the method is marked remote, than Flash can access it. building my CFCs to initially work with the cfml front end, being mindful that the Flash front end is next. My main concerns are the returntype and access attributes in the cffunctions as well as the cfargument tags. If such front ends require different values for these attributes, can I make them dynamic and pass them in accordingly, or should I just create different cffunctions? Why would CF require a different returntype than Flash? The CFC should be the one to determine what returnType (or argument types) are used. I'm operating on the following assumptions, which may or may not be correct: From what I can tell, any function that works with Flash Remoting requires an access value of remote, whereas a cffunction interacting with a cfm template does not, and in fact will not work with an access=remote value. Also , the Not true. CF can easily call a CFC method with access=remote. Flash remoting app requires you to use cfargument tags before inserting them into the db, where the cfm front end does not, Eh? This makes no sense. The CFARGUMENT tag simply _declares_ the variable names, as well as help provide validation. You can write a method w/o cfargument tags, but would not be wise. For example, for a db insert, can I create one cffunction with a returntype of any, an access value dynamically inserted (or remote if it'll work), and cfargument tags for all data passed in, and use it from both? What exactly is the method doing? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF pda types of devices
David, there is a Flash Player for the Palm OS but Macromedia show it for the Sony Clie.Heres a reference to the article. http://www.webapper.net/index.cfm?fuseaction=Fuseblog.ShowCommentsArticleID =20031013034448 Kind Regards - Mike Brunt Webapper Services LLC Web Site http://www.webapper.com Blog http://www.webapper.net Webapper Web Application Specialists -Original Message- From: David Fafard [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 7:28 AM To: CF-Talk Subject: Re: CF pda types of devices Mike. Yes, Treo is Palm. Is there a flash player for Palm? I know it uses the Blazer web browser. Thanks, Dave - Original Message - From: Mike Brunt To: CF-Talk Sent: Tuesday, December 09, 2003 10:05 AM Subject: RE: CF pda types of devices We already did this sort of thing David using Flash Player 6.0 but on PC2002.I think the Treo is Palm though, am I correct? Kind Regards - Mike Brunt Webapper Services LLC Web Site http://www.webapper.com Blog http://www.webapper.net Webapper Web Application Specialists -Original Message- From: David Fafard [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 5:22 AM To: CF-Talk Subject: Re: CF pda types of devices Speaking of this, I am going to be testing the Treo 600 combination PDA, Phone device. What would be the best direction for developing a CFMX based application for this device? CFMX, Flash ? WAP? I would be interested in having our remote sales team fill some forms from the road. Currently, they do this through the web browser on their laptops. I am trying to possible replace or supplement the laptops for the form filling. Any thoughts? Thanks, Dave Fafard - Original Message - From: Thomas Chiverton To: CF-Talk Sent: Tuesday, December 09, 2003 6:19 AM Subject: Re: CF pda types of devices On Monday 08 Dec 2003 16:40 pm, Dan Farmer wrote: so how would one detect what kind of device ( other than pc ) was accessing my site? would it just be a matter of creating a link ( flash site here | xhtml site here | PDA xhtml site here | WML site here ) You can use Apache's auto-negoatied multiviews. You can have your Application.cfm/page header swap on user_agent and/or the accept headers. I'm sure there are more :-) -- 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]
Application variables between two applications
I have an administrative application that has persistent application variables that I would like to share into another application on the production side. When a user makes a change in the admin, it refreshes the persistence of the variables and I need it somehow to change in both the admin and production application. Any ideas? --- Ricky Fritzsching [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: isXMLDOC
what kind of xml document does this function have to see to return a 1? tony human1/human /tony shouldn't something that simple work? Until you use XmlParse() the one above is just a string, not an XMLDoc... Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: isXMLDOC
what kind of xml document does this function have to see to return a 1? tony human1/human /tony shouldn't something that simple work? That's not an XML document; it's an XML document fragment. You need an XML declaration: ?xml version=1.0? tony ... 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]
RE: isXMLDOC
You probably need the XML declaration: ?xml version=1.0 encoding=UTF-8? -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 10:14 AM To: CF-Talk Subject: isXMLDOC what kind of xml document does this function have to see to return a 1? tony human1/human /tony shouldn't something that simple work? ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFC and ColdfusionQueries
The main problem is this: cfset variables.filelist='' / This is at the end of the method and deletes the existing query. Just remove it. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF pda types of devices
Speaking of devices that combine web browsing with phone and a keyboard ( like the Treo 600 ) is there anything else out there comparable to this phone? In addition to the ones already mentioned, there are a few Pocket PC phones, some of which have integrated thumb keyboards. 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]
RE: The Value of CFQUERYPARAM
I haven't heard anyone mention the security value of cfqueryparam... using this tag will prevent someone from injecting malicious code into your queries. The current discussion of CFQUERYPARAM concerned whether to use it for literal values, rather than values derived from variables. In that case, there's no security issue, since there's no user or program input. 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]
RE: isXMLDOC
Try paring the string to a xml document object. IsXMLDoc() might have been called IsXMLDocObject() to avoid confusion. Ade -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 09 December 2003 16:14 To: CF-Talk Subject: isXMLDOC what kind of xml document does this function have to see to return a 1? tony human1/human /tony shouldn't something that simple work? ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Refresh left frame
Try; script language=_javascript_ type=text/_javascript_ parent.leftFrameName.location.reload(); /script in the successful login screen page that loads on the right. So when that loads it reloads the page in the left frame, john. -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: 09 December 2003 15:25 To: CF-Talk Subject: Refresh left frame Hi I have Login link on left frame which opens login screen on right frame. On successfull login I want to refresh the left frame. But as I am at right frame it just refreshes right one. Reason I want to do is that some links in left are enabled only when appropriate user is logged in. Without refreshing it doesn't show the links to authorised users. Thanks Shahzad.Butt Ph:+44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SOT: XML and the Degree Sign
I'm working on a ColdFusion intranet application that has some pages (which I didn't write) that utilize XML and XSLT to present data pulled from a database.We have some data that includes the degree symbol (ASCII 176) and XML seems to be choking on that.We already use XMLFormat() on the data that should take care of any characters XML can't handle. Trying to view the generatred XML page in a browser (IE5.5, on which the intranet this app runs is standardized) results in a page that says the XML page can not be displayed (An invalid character was found in text content). Other than stripping out the degree symbols in the data first (which is a bit of a kluge and leads to a time when I see us having to strip out other characters), is there something else we can try? Scott -- --- Scott Brady http://www.scottbrady.net/ -- --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT: GeoTrust Certs @ 25$ ?
Jack Dalaa wrote I've *renewed* at least four certificates within the last 3 months So they've changed their pricing, which is only good news for all of us. But I still wouldn't do business with them, and if you search back on RackShack or Geotrust you'll see I used to always chime in for them here. All the re-pricing in the world doesn't excuse sending my customer an email telling him his cert expired 5 days ago, when its actually still in force.I first thought it was a mistake, but I get them on every single expiring domain.It definitely freaks out the client and puts them on my case, which I'm sure is the intent of sending it in the first place. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: XML and the Degree Sign
Scott Other than stripping out the degree symbols in the data first (which is a bit of a kluge and leads to a time when I see us having to strip out other characters), is there something else we can try? Also a kludge I guess but you could substitute them all with the entity deg; Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SQL UNION Trouble
In the following query I want the email addresses from two different tables to be grouped together (for sending in CFMail), can't get it to work, what am I missing? (BTW: the individual queries work just not as a UNION) cfquery name=qMailMessage datasource=#REQUEST.dsnSQL# username=#REQUEST.dsnUID# password=#REQUEST.dsnPWD# SELECT L.email, L.firstname, L.lastname FROM #REQUEST.prefix#_Members_List L WHERE L.email IS NOT NULL UNION SELECT A.assistantfirstname, A.assistantLastName, A.assistantEmail AS A.email FROM #REQUEST.prefix#_Members_AssistantInfo A WHERE A.email IS NOT NULL ORDER BY email /cfquery Thanks, Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Application variables between two applications
Is the Admin tool _for_ the other web site? If so, then just share application names. Otherwise, you can consider using server variables to share data between the apps. Other options include using the ServiceFactory methods which are not supported but work pretty well. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: isXMLDOC
Maybe you're not a human after all.Sorry, I don't have any insight into the problem, just decided to be silly. John -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 11:14 AM To: CF-Talk Subject: isXMLDOC what kind of xml document does this function have to see to return a 1? tony human1/human /tony shouldn't something that simple work? ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL UNION Trouble
Mark In the following query I want the email addresses from two different tables to be grouped together (for sending in CFMail), can't get it to work, what am I missing? (BTW: the individual queries work just not as a UNION) Try putting the column names in the same order in both parts of the union. Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: isXMLDOC
To expand a little. cfsavecontent variable=myXMLrootsubhella/sub/root/cfsavecontent cfdump var=#IsXMLDoc(myXML)# / cfdump var=#IsXMLDoc(XMLParse(myXML))# / Try the above to see the change. IsXMLDoc() returns true if the argument is an xml document object. What you are passing it is a string. Ade -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 09 December 2003 16:32 To: CF-Talk Subject: RE: isXMLDOC Try paring the string to a xml document object. IsXMLDoc() might have been called IsXMLDocObject() to avoid confusion. Ade -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 09 December 2003 16:14 To: CF-Talk Subject: isXMLDOC what kind of xml document does this function have to see to return a 1? tony human1/human /tony shouldn't something that simple work? ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: XML and the Degree Sign
Not a solution but I had the same problem with the £ symbol. If you've been trying solutions and not seeing a change, make sure you're not viewing cached pages, for some reason I kept viewing cached errors with every change I made to the page. But anyway -Original Message- From: Scott Brady [mailto:[EMAIL PROTECTED] Sent: 09 December 2003 16:31 To: CF-Talk Subject: SOT: XML and the Degree Sign I'm working on a ColdFusion intranet application that has some pages (which I didn't write) that utilize XML and XSLT to present data pulled from a database.We have some data that includes the degree symbol (ASCII 176) and XML seems to be choking on that.We already use XMLFormat() on the data that should take care of any characters XML can't handle. Trying to view the generatred XML page in a browser (IE5.5, on which the intranet this app runs is standardized) results in a page that says the XML page can not be displayed (An invalid character was found in text content). Other than stripping out the degree symbols in the data first (which is a bit of a kluge and leads to a time when I see us having to strip out other characters), is there something else we can try? Scott -- --- Scott Brady http://www.scottbrady.net/ http://www.scottbrady.net/ -- --- Scott Brady http://www.scottbrady.net/ http://www.scottbrady.net/ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: isXMLDOC
thanks all, its clear now. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 11:46 AM To: CF-Talk Subject: RE: isXMLDOC To expand a little. cfsavecontent variable=myXMLrootsubhella/sub/root/cfsavecontent cfdump var=#IsXMLDoc(myXML)# / cfdump var=#IsXMLDoc(XMLParse(myXML))# / Try the above to see the change. IsXMLDoc() returns true if the argument is an xml document object. What you are passing it is a string. Ade -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 09 December 2003 16:32 To: CF-Talk Subject: RE: isXMLDOC Try paring the string to a xml document object. IsXMLDoc() might have been called IsXMLDocObject() to avoid confusion. Ade -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 09 December 2003 16:14 To: CF-Talk Subject: isXMLDOC what kind of xml document does this function have to see to return a 1? tony human1/human /tony shouldn't something that simple work? ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL UNION Trouble
Try aliasing your columns. I think you need to have the same column names and number of columns for the union to work. If one query has an extra column as yours does, alias the other query and set it to NULL. SELECT col1, col2, col3, col5 = NULL FROM table1 UNION SELECT col1, col2, col4 AS 'col3', col5 FROM table2 That's a rough guess though, it's been a while since I've done this. Ade -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: 09 December 2003 16:40 To: CF-Talk Subject: SQL UNION Trouble In the following query I want the email addresses from two different tables to be grouped together (for sending in CFMail), can't get it to work, what am I missing? (BTW: the individual queries work just not as a UNION) cfquery name=qMailMessage datasource=#REQUEST.dsnSQL# username=#REQUEST.dsnUID# password=#REQUEST.dsnPWD# SELECT L.email, L.firstname, L.lastname FROM #REQUEST.prefix#_Members_List L WHERE L.email IS NOT NULL UNION SELECT A.assistantfirstname, A.assistantLastName, A.assistantEmail AS A.email FROM #REQUEST.prefix#_Members_AssistantInfo A WHERE A.email IS NOT NULL ORDER BY email /cfquery Thanks, Mark _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfc questions
Hi Ray, For example, for a db insert, can I create one cffunction with a returntype of any, an access value dynamically inserted (or remote if it'll work), and cfargument tags for all data passed in, and use it from both? What exactly is the method doing? I will be building a simple data entry and reporting app.One particular method will simply insert three fields into a SQL Server table: accountNumber (varchar 4), accountType (char 1), and accountName (varchar 25). Validation likely to be done in JS and/or AS. I'm supposing RETURNTYPE will = query only when a SELECT statement is performed on a database, correct? And if I only wanted to return the values that the user inserted, would the RETURNTYPE = struct? Thanks for your response. Sincerely, Andrew [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Application variables between two applications
The admin tool is for the other website. So in a nutshell, are you suggesting that I just rename the application name in the other website to match name of the application in the admin? Server variables - hmm...that might be a thought. I would prefer to keep them in the app scope, but if I have to use the server scope that is ok. Ricky _ From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 10:40 AM To: CF-Talk Subject: RE: Application variables between two applications Is the Admin tool _for_ the other web site? If so, then just share application names. Otherwise, you can consider using server variables to share data between the apps. Other options include using the ServiceFactory methods which are not supported but work pretty well. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]