Re: Why is this query not working in Access??
i'd rename that 'date' column to something other than date. It's a reserved
word in access.
hth,
charlie
Bob Wilson writes:
html
Hello,br
br
Any help is appreciated here.nbsp; I'm using code I've used before,
butbr
Access keeps giving me a syntax error.nbsp; br
br
Here is the query -br
lt;cfquery datasource=quot;#application.datasource#quot;gt;br
Insert INTO TBLteam ( Title, Team, Author, Date, Body )br
Values('#Title#', '#Team#', '#Author#', '#Date#', '#Body#')br
lt;/cfquerygt;br
br
br
And here is the error ---br
Error Occurred While Processing Requestbr
btable border=1
trth width=624Error Diagnostic Information br
/bODBC Error Code = 37000 (Syntax error or access violation) br
br
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
statement. br
br
The error occurred while processing an element with a general identifier
of (CFQUERY), occupying document position (366:1) to (366:62).br
/th/tr
/table
br
I can't seem to get past the Insert request.nbsp; Oh, the version
isbr
CF 4.5.2.br
br
Any help is very appreciated.br
br
Thanks,br
br
Bobbr
br
/html
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Unicode
I don't understand Unicode that well yet but is it possible to index and search on pages with Verity/CF that use Unicode. TIA ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: JAVA Training in Boston
Allaire are based in Alewyfe there, more than likely macromedia now, give them a ring they should be able to help you. -Original Message- From: Andrew Santos [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 4:56 PM To: CF-Talk Subject: JAVA Training in Boston I am looking for intermediate level JAVA training in the Boston area. Servlets...EJB's...JSP...J2EE...etc. Any recommendations? Thanks __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: BEA JRockit = Fast
Jon Hall wrote: I happened across BEA's JVM today, and tested 2 of my applications with it. Both run without any problems so far. The coolest thing though is that it is blazing fast. On my home computer, with mp3's playing etc. Here are some unscientific averages for the front page of a forum app that deals with some large cached queries, and does some significant heavy lifting. In CF5 this page runs just under 2 seconds. Sun 1.4.01: ~450ms Default (Sun?) 1.3: ~280ms JRockit 3.1.5: ~180ms JRockit also comes with a cool JVM monitor that lets you see visually all sorts of in depth things that are going on the the JVM live. http://commerce.bea.com/downloads/weblogic_jrockit.jsp Just checked it out for myself, and I'm also seeing major speed improvements. I can't find anything on the BEA website about pricing of this beast, so I'm assuming ti's free (?). Jesse __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Amazon webservice
Anyone else using the Amazon soap/wsdl? Mine suddenly quit working and it has been working for the past 2-3 weeks with no problems. Thanks, ~Todd -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Amazon webservice
Have you been able to get soap to work through cold fusion? -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 9:13 AM To: CF-Talk Subject: Amazon webservice Anyone else using the Amazon soap/wsdl? Mine suddenly quit working and it has been working for the past 2-3 weeks with no problems. Thanks, ~Todd -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Amazon webservice
yes I have. in fact, cfmx, wraps the soap envelope around requests you make when consuming a webservice using the cfinvoke tag. ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: it_temp [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 9:17 AM To: CF-Talk Subject: RE: Amazon webservice Have you been able to get soap to work through cold fusion? -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 9:13 AM To: CF-Talk Subject: Amazon webservice Anyone else using the Amazon soap/wsdl? Mine suddenly quit working and it has been working for the past 2-3 weeks with no problems. Thanks, ~Todd -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF mail - mail server
Do you need to add a seperate mail server in order for cold fusion to send mail out CFMAIL ? From everything I read I don't think so. However we keep getting an error and want to rule this out. Error Diagnostic Information unknown exception condition TagCFMail::sendMessage The error occurred while processing an element with a general identifier of (CFMAIL), occupying document position (36:4) to (39:28). ++ Gilbert Midonnet BrokerTec USA, LLC (201) 209-7843 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Building a sitetracker
Still working on this sitetracker project, and I've gotten a bit further. I put the following code in the page to be tracked: iframe src=http://www.stuffbythane.com/sitetracker/test.cfm; width=220 height=100 And the test.cfm page looks like this: CFOUTPUT CFSET Page=CGI.path_info CFIF CGI.http_referer EQ CFSET ReferringPage=None CFELSE CFSET ReferringPage=CGI.http_referer /CFIF font size=-1 Page: #Page#BR Referrer: #ReferringPage#BR Referrer: #Form.referrer#BR IP Address: #CGI.Remote_addr#BR Host: #CGI.Remote_host#BR Sever: #CGI.server_name#BR Browser: #CGI.http_user_agent#BR/font/font /CFOUTPUT Of course, ReferringPage shows the page the iframe code is inserted into. I assume I could insert some javascript into the page I'm tracking that will pass document.referrer as a form variable, but I can't figure out how to do that. How would I pass the referring page information to the tracking page? T __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF mail - mail server
No, you can use any server as long as you have the correct permissions on the server. Here is an article that may help: http://www.macromedia.com/v1/handlers/index.cfm?ID=15821Method=Full HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Gilbert Midonnet [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 9:17 AM Subject: CF mail - mail server Do you need to add a seperate mail server in order for cold fusion to send mail out CFMAIL ? From everything I read I don't think so. However we keep getting an error and want to rule this out. Error Diagnostic Information unknown exception condition TagCFMail::sendMessage The error occurred while processing an element with a general identifier of (CFMAIL), occupying document position (36:4) to (39:28). ++ Gilbert Midonnet BrokerTec USA, LLC (201) 209-7843 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFINPUT default maxlength (255?)
Is there a limit to the number of characters that can be entered in a CFINPUT textbox? I seem to be running into a 255-character cutoff and I haven't specified a maxlength. (Yes, I know TEXTAREA would be more appropriate for lengthy entries, but what the client wants the client gets.) Ricq Pattay Senior Analyst/Programmer College of Veterinary Medicine University of Minnesota - Twin Cities __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFINPUT default maxlength (255?)
Is there a limit to the number of characters that can be entered in a CFINPUT textbox? I seem to be running into a 255-character cutoff and I haven't specified a maxlength. (Yes, I know TEXTAREA would be more appropriate for lengthy entries, but what the client wants the client gets.) The maximum length of a text box (INPUT TYPE=text) is 255 characters. The CFINPUT tag generates an HTML INPUT text box. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Building a sitetracker
Just a thought -- why bother with using javascript and and iframe? stick the call to test.cfm in the application.cfm file and it should already be there. I am not sure what browsers you are targeting, but you could have a problem with old netscape browsers that don't support iframe. Tim P. - Original Message - From: Thane Sherrington [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 9:39 AM Subject: Building a sitetracker Still working on this sitetracker project, and I've gotten a bit further. I put the following code in the page to be tracked: iframe src=http://www.stuffbythane.com/sitetracker/test.cfm; width=220 height=100 And the test.cfm page looks like this: CFOUTPUT CFSET Page=CGI.path_info CFIF CGI.http_referer EQ CFSET ReferringPage=None CFELSE CFSET ReferringPage=CGI.http_referer /CFIF font size=-1 Page: #Page#BR Referrer: #ReferringPage#BR Referrer: #Form.referrer#BR IP Address: #CGI.Remote_addr#BR Host: #CGI.Remote_host#BR Sever: #CGI.server_name#BR Browser: #CGI.http_user_agent#BR/font/font /CFOUTPUT Of course, ReferringPage shows the page the iframe code is inserted into. I assume I could insert some javascript into the page I'm tracking that will pass document.referrer as a form variable, but I can't figure out how to do that. How would I pass the referring page information to the tracking page? T __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Building a sitetracker
At 10:13 AM 20/08/02 -0400, Tim Painter wrote: Just a thought -- why bother with using javascript and and iframe? stick the call to test.cfm in the application.cfm file and it should already be there. Because some of these pages aren't hosted on CF servers. T __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Building a sitetracker
By sticking it in the Application.cfm you are restricking your siteTracker to CF pages only .. what about .html, .asp pages? Just a thought of .02 Paul Giesenhagen QuillDesign Just a thought -- why bother with using javascript and and iframe? stick the call to test.cfm in the application.cfm file and it should already be there. I am not sure what browsers you are targeting, but you could have a problem with old netscape browsers that don't support iframe. Tim P. - Original Message - From: Thane Sherrington [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 9:39 AM Subject: Building a sitetracker Still working on this sitetracker project, and I've gotten a bit further. I put the following code in the page to be tracked: iframe src=http://www.stuffbythane.com/sitetracker/test.cfm; width=220 height=100 And the test.cfm page looks like this: CFOUTPUT CFSET Page=CGI.path_info CFIF CGI.http_referer EQ CFSET ReferringPage=None CFELSE CFSET ReferringPage=CGI.http_referer /CFIF font size=-1 Page: #Page#BR Referrer: #ReferringPage#BR Referrer: #Form.referrer#BR IP Address: #CGI.Remote_addr#BR Host: #CGI.Remote_host#BR Sever: #CGI.server_name#BR Browser: #CGI.http_user_agent#BR/font/font /CFOUTPUT Of course, ReferringPage shows the page the iframe code is inserted into. I assume I could insert some javascript into the page I'm tracking that will pass document.referrer as a form variable, but I can't figure out how to do that. How would I pass the referring page information to the tracking page? T __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Amazon webservice
Where can I get info on this service? - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 9:29 AM Subject: RE: Amazon webservice yes I have. in fact, cfmx, wraps the soap envelope around requests you make when consuming a webservice using the cfinvoke tag. ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: it_temp [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 9:17 AM To: CF-Talk Subject: RE: Amazon webservice Have you been able to get soap to work through cold fusion? -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 9:13 AM To: CF-Talk Subject: Amazon webservice Anyone else using the Amazon soap/wsdl? Mine suddenly quit working and it has been working for the past 2-3 weeks with no problems. Thanks, ~Todd -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SSL
-- Original Message -- from: Brian Thornton [EMAIL PROTECTED] Anyone know of and online, live, and temp. free SSL certs. https://digitalid.verisign.com/server/trial/ __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Amazon webservice
I've not made the amazon one work. however in-house we have made a webservice, using ASP.NET, which awaits a soap transmission, used the cfinvoke tag to send One parameter, received One response and displayed it. However, be ready, cfmx and cfinvoke can only handle webservices that return one response. it shits on itself as soon as you try to get back more than one or even try to consume a webservice that could return more than one response. ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Frank Mamone [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 10:23 AM To: CF-Talk Subject: Re: Amazon webservice Where can I get info on this service? - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 9:29 AM Subject: RE: Amazon webservice yes I have. in fact, cfmx, wraps the soap envelope around requests you make when consuming a webservice using the cfinvoke tag. ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: it_temp [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 9:17 AM To: CF-Talk Subject: RE: Amazon webservice Have you been able to get soap to work through cold fusion? -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 9:13 AM To: CF-Talk Subject: Amazon webservice Anyone else using the Amazon soap/wsdl? Mine suddenly quit working and it has been working for the past 2-3 weeks with no problems. Thanks, ~Todd -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SSL
Not free but, try Instant SSL $49.00 www.instantssl.com Best regards, Dennis Powers UXB Internet - A Web Design and Hosting Company tel: (203)879-2844 fax: (203)879-6254 http://www.uxbinternet.com/ http://dennis.uxb.net/ -Original Message- From: Brian Thornton [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 5:41 PM To: CF-Talk Subject: SSL Anyone know of and online, live, and temp. free SSL certs. Thanks, Brian __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT Question about Flash and GIS
I know this is off-topic, but does anyone know if I can feed GIS info into flash and create images in flash from the GIS coordinates? Does anyone know where I could ask this question? Thanks, Daron J. Smith Web Developer PSEA [EMAIL PROTECTED] 717-255-7141 1-800-944-PSEA (7732) x 7141 Please note new email address (old one with 'mail' will soon expire) FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Session Variables
Any help. How can you, from one central point manage Session variables? Example, I make use of the session variable 'Operator'. From a global file, I need to assess how many instances of the 'Operator' session variables are in existance and retrieve a list of their corresponding values. Please help. Jackie __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Recursive Custom Tag
I had asked about this awhile back without response and wanted to try again ... since the list is quiet, maybe I can get someone to help figure this out for me. I am having a problem with a custom tag that calls itself until it finds all related records, once it finds them all it stops. The only problem is that the last record ALWAYS displays twice. It's job is to display a list of departments available in the database. like so /camping /camping/tents /camping/sleeping bags /fishing /fishing/rods /fishing/reels /fishing/line /fishing/line --- last entry is repeated The DB is setup as so: ID, OWNER, SUB_OBJECT The custom tag starts with the top value and rolls through the owners and gets their sub_object values and then takes the sub_object values and checks to see if a sub_object is the owner of any other sub_objects and so on ... so this output could be available. 156 257 358 469 56 10 68 11 78 12 88 13 9ect.. Here is the custom tag ... any thoughts on how to remove that last double line?! == cfif IsDefined(request.catalog_list) Is No cfset request.catalog_list = ArrayNew(1) /cfif cfparam name=attributes.table default=#request.departmentTable# !--- this is the list that we're building. Prefixing it with 'request' means that any custom tag at any level of execution has access to it. Think of it as a temporary application variable. --- cfparam name=request.catalog_list default= !--- this is the value each instance of this custom tag will use to decide what elements it's looking for out of the database. The default value is 'index' since that's your designation for the top of the catalog tree. --- cfparam name=attributes.owner default=#request.indexID# !--- this is the value each instance of this custom tag will preface values it adds to the listing with. Because the database only contains each item's immediate parent/child value, we have to pass this forward. --- cfparam name=attributes.path default= !--- go get the children for the base owner value we're supposed to be looking for --- cfquery datasource=#request.dsn# username=#request.dbUserName# password=#request.dbPassword# name=getChildren SELECT f.owner, f.sub_object, d.id, d.title FROM fusionTable f, #attributes.table# d WHERE f.sub_object = d.id AND f.owner = cfqueryparam value=#attributes.owner# cfsqltype=CF_SQL_VARCHAR AND f.type = 'department' ORDER BY d.title, f.sub_object /cfquery !--- Loop over the children of the main owner value. Our one and only loop. --- cfloop query=getChildren cfparam name=request.count default=0 cfset request.count = request.count + 1 !--- add the path from the index to this location in the tree in front of the name of this sub-object --- cfset variables.thisitempath = #attributes.path#/#getChildren.title# cfset request.catalog_list[request.count] = StructNew() cfset request.catalog_list[request.count].tree = variables.thisitempath cfset request.catalog_list[request.count].id = getChildren.sub_object !--- Add an item to our list of catalog departments --- cfset temp = ArrayAppend(request.catalog_list, request.catalog_list[request.count]) !--- call this file again, but this time tell it to take a look at the next level down. if there's anything under this department, it will get added to the tree in sequence. --- cf_catdump owner=#sub_object# path=#variables.thisitempath# /cfloop Thank you Paul Giesenhagen __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Session Variables
The ability to manage all sessions has been a request for a LONG time. Currently you can't do this directly. You can 'hack' it by copying session data to the application scope, but this is one way. In order to modify user Foo's session var, you would have to put some kind of status msg in the application scope and wait for Foo to hit the site again. === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : cfjedimaster My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Jakolien Cozma [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 10:33 AM To: CF-Talk Subject: Session Variables Any help. How can you, from one central point manage Session variables? Example, I make use of the session variable 'Operator'. From a global file, I need to assess how many instances of the 'Operator' session variables are in existance and retrieve a list of their corresponding values. Please help. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SSL
You can get a free temp ssl here http://www.thawte.com/ Thanks, Brian Berends -Original Message- From: UXB Internet [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 6:37 AM To: CF-Talk Subject: RE: SSL Not free but, try Instant SSL $49.00 www.instantssl.com Best regards, Dennis Powers UXB Internet - A Web Design and Hosting Company tel: (203)879-2844 fax: (203)879-6254 http://www.uxbinternet.com/ http://dennis.uxb.net/ -Original Message- From: Brian Thornton [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 5:41 PM To: CF-Talk Subject: SSL Anyone know of and online, live, and temp. free SSL certs. Thanks, Brian __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF mail - mail server
In my experience, unknown exception conditions are usually caused by some sort of bug -- it's an unantiscipated error which is why there's no detailed error information as is normally provided... For instance, if you don't specify a mail server in the cfmail tag and no default server is specified in the cfadministrator, the error message says that no mail server has been specified in either location. You might want to post the code for your cfmail tag to the list -- maybe there's something fishy about the syntax... Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 Do you need to add a seperate mail server in order for cold fusion to send mail out CFMAIL ? From everything I read I don't think so. However we keep getting an error and want to rule this out. Error Diagnostic Information unknown exception condition TagCFMail::sendMessage The error occurred while processing an element with a general identifier of (CFMAIL), occupying document position (36:4) to (39:28). ++ Gilbert Midonnet BrokerTec USA, LLC (201) 209-7843 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Building a sitetracker
At 10:13 AM 20/08/02 -0400, Tim Painter wrote: Just a thought -- why bother with using javascript and and iframe? stick the call to test.cfm in the application.cfm file and it should already be there. Because some of these pages aren't hosted on CF servers. You might consider using an image instead of an iframe if support of older NS browsers is an issue... There's an article about using images as data pipes on Jim Davis' site at http://www.depressedpress.com Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Amazon webservice
http://www.amazon.com/webservices/ On Tue, 20 Aug 2002, Frank Mamone wrote: Where can I get info on this service? - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 9:29 AM Subject: RE: Amazon webservice yes I have. in fact, cfmx, wraps the soap envelope around requests you make when consuming a webservice using the cfinvoke tag. ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: it_temp [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 9:17 AM To: CF-Talk Subject: RE: Amazon webservice Have you been able to get soap to work through cold fusion? -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 9:13 AM To: CF-Talk Subject: Amazon webservice Anyone else using the Amazon soap/wsdl? Mine suddenly quit working and it has been working for the past 2-3 weeks with no problems. Thanks, ~Todd -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT Question about Flash and GIS
I can't answer your question, but you might try asking the FlashCoders list. Warning, thought it's extremely high traffic. Sort of like this list. Sometimes much worse. http://chattyfig.figleaf.com I know this is off-topic, but does anyone know if I can feed GIS info into flash and create images in flash from the GIS coordinates? Does anyone know where I could ask this question? __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Amazon webservice
http://www.macromedia.com/desdev/mx/coldfusion/articles/wsamazon.html - Original Message - From: [EMAIL PROTECTED] Date: Tuesday, August 20, 2002 7:13 am Subject: Amazon webservice Anyone else using the Amazon soap/wsdl? Mine suddenly quit working and it has been working for the past 2-3 weeks with no problems. Thanks, ~Todd -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Can CF talk to a ODBC compliant db via an ISDN line.
My client has a sql DB server abroad that he connects to via an ISDN line to check status information of a cash transfer. His inhouse system built in VB does this.Qusetion is - is it possible to get CF to do the same? Any ideas as to how to proceed. Kodjo asks! __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Session Variables
Any help. How can you, from one central point manage Session variables? Example, I make use of the session variable 'Operator'. From a global file, I need to assess how many instances of the 'Operator' session variables are in existance and retrieve a list of their corresponding values. Please help. I believe there's a custom tag to do this on the developer's exchange... Check out http://devex.macromedia.com and do a search for session or manage sessions... I think this is the one I saw before: performs following session administration tasks: retrieve/sort/search/filter active sessions, kill selected sessions, limit number of sessions, block all new logins (so that you can wait until the last active session terminates, and then perform shutdown), remove expired sessions. (see admin example) (New) http://devex.macromedia.com/developer/gallery/info.cfm?ID=AE230230-45FF-11D4 -AA9800508B94F380method=Full Although it may be easier / less invasive to copy the operator session variables to a structure in the application scope... i.e. cfset session.userid = myquery.operator_id cfset session.operator = myquery.operator cfparam name=application.operators type=structure default=#structnew()# cfset application.operators[myquery.operator_id] = myquery.operator Then you can analyze the application variables fairly easily... cfoutput Operators: cfloop index=x list=#structkeylist(application.operators)# div#application.operators[x]#/div/cfloop Total: #ListLen(StructKeyList(application.operators))# /cfoutput And of course remember on CF 5 and before that you need to lock those application and session scope variables... hth Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Building a sitetracker
That makes sense. Instead of an iframe, could you use an img tag instead, so that you would be compatible with other browsers, There is a great article here on using a gif as a data pipe: http://www.depressedpress.com/DepressedPress/Content/ColdFusion/Essays/GIFAsPipe/ HTH, Tim P. - Original Message - From: Thane Sherrington [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 9:39 AM Subject: Building a sitetracker Still working on this sitetracker project, and I've gotten a bit further. I put the following code in the page to be tracked: iframe src=http://www.stuffbythane.com/sitetracker/test.cfm; width=220 height=100 And the test.cfm page looks like this: CFOUTPUT CFSET Page=CGI.path_info CFIF CGI.http_referer EQ CFSET ReferringPage=None CFELSE CFSET ReferringPage=CGI.http_referer /CFIF font size=-1 Page: #Page#BR Referrer: #ReferringPage#BR Referrer: #Form.referrer#BR IP Address: #CGI.Remote_addr#BR Host: #CGI.Remote_host#BR Sever: #CGI.server_name#BR Browser: #CGI.http_user_agent#BR/font/font /CFOUTPUT Of course, ReferringPage shows the page the iframe code is inserted into. I assume I could insert some javascript into the page I'm tracking that will pass document.referrer as a form variable, but I can't figure out how to do that. How would I pass the referring page information to the tracking page? T __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Amazon webservice
I'm not asking for a tutorial. Turns out their Soap service is down or messed up. ~Todd On Tue, 20 Aug 2002 [EMAIL PROTECTED] wrote: http://www.macromedia.com/desdev/mx/coldfusion/articles/wsamazon.html - Original Message - From: [EMAIL PROTECTED] Date: Tuesday, August 20, 2002 7:13 am Subject: Amazon webservice Anyone else using the Amazon soap/wsdl? Mine suddenly quit working and it has been working for the past 2-3 weeks with no problems. Thanks, ~Todd -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT Question about Flash and GIS
oi Daron!! wouldn't you still need an application server such as ArcIMS to process the coordinates etc... -- Critz Macromedia Certified Advanced ColdFusion Developer CFX_BotMaster Network=Efnet Channel=ColdFusion Tuesday, August 20, 2002, 10:37:04 AM, you wrote: SDP I know this is off-topic, but does anyone know if I can feed GIS info into SDP flash and create images in flash from the GIS coordinates? Does anyone know SDP where I could ask this question? SDP Thanks, SDP Daron J. Smith SDP Web Developer SDP PSEA SDP [EMAIL PROTECTED] SDP 717-255-7141 SDP 1-800-944-PSEA (7732) x 7141 SDP Please note new email address (old one with 'mail' will soon expire) SDP FAQ: http://www.thenetprofits.co.uk/coldfusion/faq SDP Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ SDP Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Amazon webservice
Ahh, ok. Your question was sorta ambiguous. No problems. Let's all curse Amazon!! :) - Original Message - From: [EMAIL PROTECTED] Date: Tuesday, August 20, 2002 9:20 am Subject: Re: Amazon webservice I'm not asking for a tutorial. Turns out their Soap service is down or messed up. ~Todd On Tue, 20 Aug 2002 [EMAIL PROTECTED] wrote: http://www.macromedia.com/desdev/mx/coldfusion/articles/wsamazon.html - Original Message - From: [EMAIL PROTECTED] Date: Tuesday, August 20, 2002 7:13 am Subject: Amazon webservice Anyone else using the Amazon soap/wsdl? Mine suddenly quit working and it has been working for the past 2-3 weeks with no problems. Thanks, ~Todd -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Can CF talk to a ODBC compliant db via an ISDN line.
its not a cf issue, I don't think, I think its more of a remote SQL server connectivity issue, once you figure that out, you should be down the right path. ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Kodjo Ackah [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 11:10 AM To: CF-Talk Subject: Can CF talk to a ODBC compliant db via an ISDN line. My client has a sql DB server abroad that he connects to via an ISDN line to check status information of a cash transfer. His inhouse system built in VB does this.Qusetion is - is it possible to get CF to do the same? Any ideas as to how to proceed. Kodjo asks! __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL Help
Does anyone have a good site to bone up on SQL. I am looking to beef up my knowledge of stored procedures and learn all of the functions that MS SQL 2000 support. Thanks. Matt Friedman __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Help
jeez dude, bone up in the privacy of your own home :-) -Original Message- From: Matthew Friedman [mailto:[EMAIL PROTECTED]] Sent: 20 August 2002 16:35 To: CF-Talk Subject: SQL Help Does anyone have a good site to bone up on SQL. I am looking to beef up my knowledge of stored procedures and learn all of the functions that MS SQL 2000 support. Thanks. Matt Friedman __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
days between function in Oracle...
Hi, Does anyone know of a function I can use to get the number of days between 2 dates in Oracle. My basic problem is I can get the dates but on using the round function it's screws up... e.g round(18.12) = 18 days round(18.82) = 19 days What I want is a function which does function(18.12) = 19 days function(18.82) = 19 days Thanks Alex __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Help
had to go there huh neil :) on a serious note, I would get the SQL in 10 minutes book by Mr Forta. its cool. its easy to read. we even got a copy of it last year @ devcon! ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 11:29 AM To: CF-Talk Subject: RE: SQL Help jeez dude, bone up in the privacy of your own home :-) -Original Message- From: Matthew Friedman [mailto:[EMAIL PROTECTED]] Sent: 20 August 2002 16:35 To: CF-Talk Subject: SQL Help Does anyone have a good site to bone up on SQL. I am looking to beef up my knowledge of stored procedures and learn all of the functions that MS SQL 2000 support. Thanks. Matt Friedman __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Help
I bought a copy before I even realised it was by the man... Damn eh? -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: 20 August 2002 16:37 To: CF-Talk Subject: RE: SQL Help had to go there huh neil :) on a serious note, I would get the SQL in 10 minutes book by Mr Forta. its cool. its easy to read. we even got a copy of it last year @ devcon! .tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 11:29 AM To: CF-Talk Subject: RE: SQL Help jeez dude, bone up in the privacy of your own home :-) -Original Message- From: Matthew Friedman [mailto:[EMAIL PROTECTED]] Sent: 20 August 2002 16:35 To: CF-Talk Subject: SQL Help Does anyone have a good site to bone up on SQL. I am looking to beef up my knowledge of stored procedures and learn all of the functions that MS SQL 2000 support. Thanks. Matt Friedman __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Help
I'll second that. Well the bit about it being cool, not the devcon bit :OP Ade -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: 20 August 2002 16:37 To: CF-Talk Subject: RE: SQL Help had to go there huh neil :) on a serious note, I would get the SQL in 10 minutes book by Mr Forta. its cool. its easy to read. we even got a copy of it last year @ devcon! .tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 11:29 AM To: CF-Talk Subject: RE: SQL Help jeez dude, bone up in the privacy of your own home :-) -Original Message- From: Matthew Friedman [mailto:[EMAIL PROTECTED]] Sent: 20 August 2002 16:35 To: CF-Talk Subject: SQL Help Does anyone have a good site to bone up on SQL. I am looking to beef up my knowledge of stored procedures and learn all of the functions that MS SQL 2000 support. Thanks. Matt Friedman __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Recursive Custom Tag
cfparam name=request.count default=0 cfset request.count = request.count + 1 !--- add the path from the index to this location in the tree in front of the name of this sub-object --- cfset variables.thisitempath = #attributes.path#/#getChildren.title# cfset request.catalog_list[request.count] = StructNew() cfset request.catalog_list[request.count].tree = variables.thisitempath cfset request.catalog_list[request.count].id = getChildren.sub_object !--- Add an item to our list of catalog departments --- cfset temp = ArrayAppend(request.catalog_list, request.catalog_list[request.count]) !--- call this file again, but this time tell it to take a look at the next level down. if there's anything under this department, it will get added to the tree in sequence. --- cf_catdump owner=#sub_object# path=#variables.thisitempath# It may be just me, but it looks to me like the cfset temp = ArrayAppend(request.catalog_list,request.catalog_list[request.count]) is extraneous... You're appending the last item in the array to the array? So it's actually duplicating each item in turn, then the next item replaces the last item in the list and gets duplicated again... So at the end only that last item is duplicated. If you remove that arrayappend, I bet that will fix it. That or create the new structure as a separate local variable and then append that local strucutre. hth Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Can CF talk to a ODBC compliant db via an ISDN line.
Will this have anything to do with ODBC ports or something? Please enlighten me on this. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
hidden form fields and macintosh
I have a client that is having a problem with hidden form fields disappearing. The clients browser is Mozilla/4.0 (compatible; MSIE 5.13; Mac_PowerPC). When I search Macromedia's forums I find a lot of issues with mac and file upload but I can't find solutions for form fields disappearing. I tried to search the archives for this list but I can't get any matches using these search strings 'form or mac', 'form mac', 'form mac'. I'm sure threads have come through this list about forms and mac, but I can't find any hits on the keywords I've used. JS __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Help
yea, devcon, was sort of a let down, last year, but im not too sure that I wasn't just a novice at conferences and wasn't too sure how to do the conference thing, how to gather as much useful data as possible, and what things to attend and what things not to attend ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 11:42 AM To: CF-Talk Subject: RE: SQL Help I'll second that. Well the bit about it being cool, not the devcon bit :OP Ade -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: 20 August 2002 16:37 To: CF-Talk Subject: RE: SQL Help had to go there huh neil :) on a serious note, I would get the SQL in 10 minutes book by Mr Forta. its cool. its easy to read. we even got a copy of it last year @ devcon! tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 11:29 AM To: CF-Talk Subject: RE: SQL Help jeez dude, bone up in the privacy of your own home :-) -Original Message- From: Matthew Friedman [mailto:[EMAIL PROTECTED]] Sent: 20 August 2002 16:35 To: CF-Talk Subject: SQL Help Does anyone have a good site to bone up on SQL. I am looking to beef up my knowledge of stored procedures and learn all of the functions that MS SQL 2000 support. Thanks. Matt Friedman __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Help
Does anyone have a good site to bone up on SQL. I am looking to beef up my knowledge of stored procedures and learn all of the functions that MS SQL 2000 support. Try SWYNK.com - they have some useful stuff there Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: hidden form fields and macintosh
are they form fields in table cells with background colors? ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: JS [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 11:45 AM To: CF-Talk Subject: hidden form fields and macintosh I have a client that is having a problem with hidden form fields disappearing. The clients browser is Mozilla/4.0 (compatible; MSIE 5.13; Mac_PowerPC). When I search Macromedia's forums I find a lot of issues with mac and file upload but I can't find solutions for form fields disappearing. I tried to search the archives for this list but I can't get any matches using these search strings 'form or mac', 'form mac', 'form mac'. I'm sure threads have come through this list about forms and mac, but I can't find any hits on the keywords I've used. JS __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Can CF talk to a ODBC compliant db via an ISDN line.
My client has a sql DB server abroad that he connects to via an ISDN line to check status information of a cash transfer. His inhouse system built in VB does this.Qusetion is - is it possible to get CF to do the same? Any ideas as to how to proceed. As long as the server can talk to the SQL Server on the other end of the ISDN, then there should be no reason why not I would need a static IP address and have the user setup for the CF to talk to, but as long as you've got those, there should be no reason why not If you can pcAnywhere to the server, then check to see if you can ping the remote machine, if so, see if you can get a port-scanning piece of software and check to make sure port 1433 is open to you If you can do all of that, then there's no reason why you can't make an ODBC connection Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: hidden form fields and macintosh
Two possibilities I can contribute: 1) Under certain conditions, fields AFTER a form upload field don't get passed when the form is submitted. 2) Under certain conditions, I have found that forms will not submit properly if they are not carefully nested consistently in a table. IE: table form input type=hidden... tr td input type=text... /td input type=hidden... /form /tr /table Move the closing form tag below the /tr tag and it works. Can't remember what platform it was on, and I can't explain it, but it happened. -Cameron - Cameron Childress Sumo Consulting Inc. --- cell: 678-637-5072 aim: cameroncf email: [EMAIL PROTECTED] -Original Message- From: JS [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 11:45 AM To: CF-Talk Subject: hidden form fields and macintosh I have a client that is having a problem with hidden form fields disappearing. The clients browser is Mozilla/4.0 (compatible; MSIE 5.13; Mac_PowerPC). When I search Macromedia's forums I find a lot of issues with mac and file upload but I can't find solutions for form fields disappearing. I tried to search the archives for this list but I can't get any matches using these search strings 'form or mac', 'form mac', 'form mac'. I'm sure threads have come through this list about forms and mac, but I can't find any hits on the keywords I've used. JS __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Amazon webservice
Can someone explain to me how you can make money using the amazon service? - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 11:19 AM Subject: Re: Amazon webservice Ahh, ok. Your question was sorta ambiguous. No problems. Let's all curse Amazon!! :) - Original Message - From: [EMAIL PROTECTED] Date: Tuesday, August 20, 2002 9:20 am Subject: Re: Amazon webservice I'm not asking for a tutorial. Turns out their Soap service is down or messed up. ~Todd On Tue, 20 Aug 2002 [EMAIL PROTECTED] wrote: http://www.macromedia.com/desdev/mx/coldfusion/articles/wsamazon.html - Original Message - From: [EMAIL PROTECTED] Date: Tuesday, August 20, 2002 7:13 am Subject: Amazon webservice Anyone else using the Amazon soap/wsdl? Mine suddenly quit working and it has been working for the past 2-3 weeks with no problems. Thanks, ~Todd -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RESOLVED: Re: Recursive Custom Tag
You get the cookie today ... sheesh ... I looked and looked through that thing and welp that was the problem. I removed: cfset temp = ArrayAppend(request.catalog_list, request.catalog_list[request.count]) Thanks for opening my eyes ... as I was reading it went clear ... funny how that works! Paul Giesenhagen QuillDesign cfparam name=request.count default=0 cfset request.count = request.count + 1 !--- add the path from the index to this location in the tree in front of the name of this sub-object --- cfset variables.thisitempath = #attributes.path#/#getChildren.title# cfset request.catalog_list[request.count] = StructNew() cfset request.catalog_list[request.count].tree = variables.thisitempath cfset request.catalog_list[request.count].id = getChildren.sub_object !--- Add an item to our list of catalog departments --- cfset temp = ArrayAppend(request.catalog_list, request.catalog_list[request.count]) !--- call this file again, but this time tell it to take a look at the next level down. if there's anything under this department, it will get added to the tree in sequence. --- cf_catdump owner=#sub_object# path=#variables.thisitempath# It may be just me, but it looks to me like the cfset temp = ArrayAppend(request.catalog_list,request.catalog_list[request.count]) is extraneous... You're appending the last item in the array to the array? So it's actually duplicating each item in turn, then the next item replaces the last item in the list and gets duplicated again... So at the end only that last item is duplicated. If you remove that arrayappend, I bet that will fix it. That or create the new structure as a separate local variable and then append that local strucutre. hth Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Help
couldn't resist it.. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: 20 August 2002 16:37 To: CF-Talk Subject: RE: SQL Help had to go there huh neil :) on a serious note, I would get the SQL in 10 minutes book by Mr Forta. its cool. its easy to read. we even got a copy of it last year @ devcon! .tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 11:29 AM To: CF-Talk Subject: RE: SQL Help jeez dude, bone up in the privacy of your own home :-) -Original Message- From: Matthew Friedman [mailto:[EMAIL PROTECTED]] Sent: 20 August 2002 16:35 To: CF-Talk Subject: SQL Help Does anyone have a good site to bone up on SQL. I am looking to beef up my knowledge of stored procedures and learn all of the functions that MS SQL 2000 support. Thanks. Matt Friedman __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Can CF talk to a ODBC compliant db via an ISDN line.
its simply a tcp/ip sql server connection. you can connect to remote servers anyway using sql server 2000, and im pretty sure you can using7.0 your challenge is to make that tcp/ip connection propagate to the odbc panel in cf admin, if im correct in my thinking. so that you can then make an odbc datasource. I would think this was possible, although I havent done that before, I have connected to remote sql servers, simply by registering them, but instead of using Named Pipes, the netbios name, I used the sql server machines IP Address. one caveat, make sure you have that connectivity capability installed in your sql server setup. ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Kodjo Ackah [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 11:41 AM To: CF-Talk Subject: RE: Can CF talk to a ODBC compliant db via an ISDN line. Will this have anything to do with ODBC ports or something? Please enlighten me on this. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Amazon webservice
Do you really need to be an affiliate to do this or is the token enough? Also I notice there's no CF example in their kit:( - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 11:08 AM Subject: Re: Amazon webservice http://www.macromedia.com/desdev/mx/coldfusion/articles/wsamazon.html - Original Message - From: [EMAIL PROTECTED] Date: Tuesday, August 20, 2002 7:13 am Subject: Amazon webservice Anyone else using the Amazon soap/wsdl? Mine suddenly quit working and it has been working for the past 2-3 weeks with no problems. Thanks, ~Todd -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: days between function in Oracle...
Using ROUND() on the dates seems to work. Try something like this: ROUND(date2) - ROUND(date1) Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com -Original Message- From: Alex Ninan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 11:32 AM To: CF-Talk Subject: days between function in Oracle... Hi, Does anyone know of a function I can use to get the number of days between 2 dates in Oracle. My basic problem is I can get the dates but on using the round function it's screws up... e.g round(18.12) = 18 days round(18.82) = 19 days What I want is a function which does function(18.12) = 19 days function(18.82) = 19 days Thanks Alex __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: hidden form fields and macintosh
Here is a snippet of the form page, with var names changed. Several people have recommended using the trim function on the action page to reference the form variable, but I don't see how this makes a difference in this case, would it? The error message I had sent to me lists all form variables that are available when the error occurs and no form variables were present in the email. I'm deducing that they were never even passed, there was a valid referrer however, so I don't think bookmarking was the issue. table border=2 width=100% form Name=xxx action=xxx.cfm?RequestTimeout=500 method=POST input type=hidden name=Sh_all value=0 input type=hidden name=strow value=26 input type=hidden name=q_join value= input type=hidden name=q_un_param value=val tr tdnbsp;bfont face=Times New Roman size=2 color=WHITEView: font size=1 select name=strt_row OnChange=parent.storage_frame.x_at_a_time(4121,this.options[this.selectedIndex]) option value=1 1 - 25option value=26 Selected 26 - 50option value=51 51 - 75option value=76 76 - 100option value=101 101 - 125 /select/font /td th align=rightbfont face=Times New Roman size=2 color=WHITEOrdered by:font size=1 select name=qry_ord_by OnChange=document.xxx.strt_row.selectedIndex=0;document.xxx.strt_row.value='1';document.xxx.submit() option value=title Title option value=status Selected Status option value=AgencyName Agency option value=ProjectType Type option value=contact Contact /select/font /th /tr /form /table __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SSL
Interesting. Nice to see competition hammering down prices. Geotrust is a bit more compatible, claiming 98% compatibility instead of 95% (they go back to NN 4.51 and work on Opera). You can get a GeoTrust cert for $49 (not the retail $119) at http://rackshack.net. --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -Original Message- From: UXB Internet [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 7:37 AM To: CF-Talk Subject: RE: SSL Not free but, try Instant SSL $49.00 www.instantssl.com __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: days between function in Oracle...
Use the Oracle trunc function on the dates. Trunc() removes the time portion so both dates are at midnight. trunc(date1) - trunc(date2) Dan -Original Message- From: Alex Ninan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 11:32 AM To: CF-Talk Subject: days between function in Oracle... Hi, Does anyone know of a function I can use to get the number of days between 2 dates in Oracle. My basic problem is I can get the dates but on using the round function it's screws up... __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: days between function in Oracle...
Use the Ceiling or Ceil function (can't remember exactly which one it is) Cheers, Sam - Original Message - From: Alex Ninan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 11:32 AM Subject: days between function in Oracle... Hi, Does anyone know of a function I can use to get the number of days between 2 dates in Oracle. My basic problem is I can get the dates but on using the round function it's screws up... e.g round(18.12) = 18 days round(18.82) = 19 days What I want is a function which does function(18.12) = 19 days function(18.82) = 19 days Thanks Alex __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Help
Hello Everyone, I have a colleague who wants me to design a site for him. The concept is one already being used, he has a list of people who want him to provide a virtual storefront for them. The site would provide a place for vendors to input their information and products. He wants to use PayPal for the processing and payment of products. However if a user purchases a product from multiple vendors, I am unsure how that would be worked out. I am in the very initial stages of this project and would kindly take any advice from anyone who could offer some. Is there a Coldfusion extension out there that can assist me? Marci Watson We are not free, separate, and independent entities, but like links in a chain, and we could not by any means be what we are without those who went before us and showed us the way. ~Thomas Mann __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: days between function in Oracle...
Thanks Sam, That's exactly what I wanted. Learnt something new today... Ceil and Floor functions... -Original Message- From: Sam Farmer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 9:52 AM To: CF-Talk Subject: Re: days between function in Oracle... Use the Ceiling or Ceil function (can't remember exactly which one it is) Cheers, Sam - Original Message - From: Alex Ninan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 11:32 AM Subject: days between function in Oracle... Hi, Does anyone know of a function I can use to get the number of days between 2 dates in Oracle. My basic problem is I can get the dates but on using the round function it's screws up... e.g round(18.12) = 18 days round(18.82) = 19 days What I want is a function which does function(18.12) = 19 days function(18.82) = 19 days Thanks Alex __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Certification
I got the green gym bag, never use it. I took the test in 2000 I think, got an Allaire certificate, then when 5.0 came out, they sent a Macromedia certificate. don't know what's to come. IGOR ILYINSKY CREDIT|FIRST SUISSE|BOSTON -Original Message- From: S.Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 10:06 PM To: CF-Talk Subject: RE: Certification Are you sure of that? I got the logos and didn't get 80% That a new thing? I got the disk and the rules of use and all that gobblety gook. Apparently I was just confused by the way the information reads about it on their website. It sounded to me when I read it like only the Advanced developers were given rights to use the logos. But then that may have just been because I wasn't paying close enough attention. . Yep... I missed the second advanced in this sentence: Certified Advanced ColdFusion Developers are entitled to use the Advanced ColdFusion Developer logo on business cards, letterheads, and Web sites. Isaac www.turnkey.to 954-776-0046 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: days between function in Oracle...
ceiling() will round up What's your question ...days beween dates or rounding? On Tue, 20 Aug 2002, Alex Ninan wrote: Hi, Does anyone know of a function I can use to get the number of days between 2 dates in Oracle. My basic problem is I can get the dates but on using the round function it's screws up... e.g round(18.12) = 18 days round(18.82) = 19 days What I want is a function which does function(18.12) = 19 days function(18.82) = 19 days Thanks Alex __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: days between function in Oracle...
lets say I have certain dates (x) and (y) now I do a ((x) - (y)) in oracle and I get a number like 18.12 or 18.82 I was doing a round of the result above which yielded me 18 or 19 based on the percentile. While I was expecting 19 always, the ceil function helped me to achieve that. Hope that helps clarify the question... More of a rounding issue. -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 10:10 AM To: CF-Talk Subject: Re: days between function in Oracle... ceiling() will round up What's your question ...days beween dates or rounding? On Tue, 20 Aug 2002, Alex Ninan wrote: Hi, Does anyone know of a function I can use to get the number of days between 2 dates in Oracle. My basic problem is I can get the dates but on using the round function it's screws up... e.g round(18.12) = 18 days round(18.82) = 19 days What I want is a function which does function(18.12) = 19 days function(18.82) = 19 days Thanks Alex __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Help
On Tue, 20 Aug 2002, Watson, Marci [NH] wrote: However if a user purchases a product from multiple vendors, I am unsure how that would be worked out. This is a business decision. Also, your subject_line did not describe your problem. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfoutput within cfform problem on MX?
OK, this is so strange I almost don't want to write it. This code doesn't work. The innermost cfoutput is not working as expected. It is only showing the first Product. There are several Products in each Category. If I change cfform to form, it works as expected. I double checked by also moving the cfform tag outside the CFOUTPUT group=Category_ID. Sure enough, even though there are several Categories under each Main Category, only the first one shows. What the heck is that? Is it only me? Has anyone else experienced this? BTW, if I move the cfform tag outside of the main cfoutput, it works as expected. Of course, that's no good as I need individual forms. This is a pretty major problem. Not in this case, because I don't have any cfinput tags, but I can see it killing me in migration of some apps. CFOUTPUT query=getproducts group=Main_Category_ID tr td align=center#Main_Category_Name#/td /tr CFOUTPUT group=Category_ID tr td align=center cfform action=index.cfm #Category_Name#p select name=Product_ID CFOUTPUT option value=#Product_ID##Product_Name# /CFOUTPUT /select /cfform /td /tr /CFOUTPUT /CFOUTPUT -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: days between function in Oracle...
It might be best to trunc() the dates before doing the math, depending on
what date values you may have, and what your intended effect is.
This returns 19.99...
select to_date('28-AUG-2002 23:59:59') - to_date('09-AUG-2002 00:00:01')
fromdual
This returns 20
select ceil(to_date('28-AUG-2002 23:59:59') - to_date('09-AUG-2002
00:00:01'))
fromdual
This returns 19
select trunc(to_date('28-AUG-2002 23:59:59')) - trunc(to_date('09-AUG-2002
00:00:01'))
fromdual
Dan
-Original Message-
From: Alex Ninan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 20, 2002 10:16 AM
To: CF-Talk
Subject: RE: days between function in Oracle...
lets say I have certain dates (x) and (y)
now I do a ((x) - (y)) in oracle and I get a number like 18.12 or 18.82
I was doing a round of the result above which yielded me 18 or 19 based on
the percentile. While I was expecting 19 always, the ceil function helped me
to achieve that.
Hope that helps clarify the question... More of a rounding issue.
-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 20, 2002 10:10 AM
To: CF-Talk
Subject: Re: days between function in Oracle...
ceiling() will round up
What's your question ...days beween dates or rounding?
On Tue, 20 Aug 2002, Alex Ninan wrote:
Hi,
Does anyone know of a function I can use to get the number of days between
2
dates in Oracle. My basic problem is I can get the dates but on using the
round function it's screws up...
e.g
round(18.12) = 18 days
round(18.82) = 19 days
What I want is a function which does
function(18.12) = 19 days
function(18.82) = 19 days
Thanks
Alex
__
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfoutput within cfform problem on MX?
Ya know, I've run into this problem as well, and one of my friends and former associates did too, so much so that we totally stopped using CFFORM and wrote our own validation routines. Doesn't help out much if you're using some of the CF form objects not geared towards validation, but it may be worthwhile to look at another solution. Something about using CFFORM inside of CFOUTPUT just gave us fits. If you're interested I'll send you the validation routines and tag that we wrote to get around cfform. Joshua Miller Web Development :: Programming Eagle Web Development LLC www.eaglewd.com [EMAIL PROTECTED] (304) 622-5676 (Clarksburg Office) (304) 456-4942 (Home Office) -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 1:18 PM To: CF-Talk Subject: cfoutput within cfform problem on MX? OK, this is so strange I almost don't want to write it. This code doesn't work. The innermost cfoutput is not working as expected. It is only showing the first Product. There are several Products in each Category. If I change cfform to form, it works as expected. I double checked by also moving the cfform tag outside the CFOUTPUT group=Category_ID. Sure enough, even though there are several Categories under each Main Category, only the first one shows. What the heck is that? Is it only me? Has anyone else experienced this? BTW, if I move the cfform tag outside of the main cfoutput, it works as expected. Of course, that's no good as I need individual forms. This is a pretty major problem. Not in this case, because I don't have any cfinput tags, but I can see it killing me in migration of some apps. CFOUTPUT query=getproducts group=Main_Category_ID tr td align=center#Main_Category_Name#/td /tr CFOUTPUT group=Category_ID tr td align=center cfform action=index.cfm #Category_Name#p select name=Product_ID CFOUTPUT option value=#Product_ID##Product_Name# /CFOUTPUT /select /cfform /td /tr /CFOUTPUT /CFOUTPUT -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help
Sorry, First time I have utilized CF Talk, I will be more clear in the future. Marci -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 1:18 PM To: CF-Talk Subject: Re: Help On Tue, 20 Aug 2002, Watson, Marci [NH] wrote: However if a user purchases a product from multiple vendors, I am unsure how that would be worked out. This is a business decision. Also, your subject_line did not describe your problem. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Nashville Anyone
Is anyone here, In or close to Nashville? __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Nashville Anyone
What qualifies as close? Rob Edwards Phone: (502) 359-1627 Systems Management Tools Pager: (502) 478-1116 United Parcel Service Fax:(502) 359-0094 EMail: [EMAIL PROTECTED] (2B || !2B) == ? -Original Message- From: Brian Thornton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 1:38 PM To: CF-Talk Subject: Nashville Anyone Is anyone here, In or close to Nashville? __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Help
No problem Marci, oh I see you've met Alex... Sorry, First time I have utilized CF Talk, I will be more clear in the future. Marci -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 1:18 PM To: CF-Talk Subject: Re: Help On Tue, 20 Aug 2002, Watson, Marci [NH] wrote: However if a user purchases a product from multiple vendors, I am unsure how that would be worked out. This is a business decision. Also, your subject_line did not describe your problem. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists _ Join the worldÂ’s largest e-mail service with MSN Hotmail. http://www.hotmail.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: BEA JRockit = Fast
I just got off the phone with BEA Sales. Here's the skinny on JRockit: there is no cost associated with it unless you want to buy a support and maintenance contract with them which would cost you $2,000. Apparently, all of their other products have a 30 day expiration eval license, but he said most likely JRockit is different due to the nature of the app and will continue to work after 30 days. Here's a question, so when the CFMX for J2EE using BEA WebLogic comes out, will it be using the Jrockit JVM??? I would assume so... -Original Message- From: Jesse Houwing [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 5:26 AM To: CF-Talk Subject: Re: BEA JRockit = Fast Jon Hall wrote: I happened across BEA's JVM today, and tested 2 of my applications with it. Both run without any problems so far. The coolest thing though is that it is blazing fast. On my home computer, with mp3's playing etc. Here are some unscientific averages for the front page of a forum app that deals with some large cached queries, and does some significant heavy lifting. In CF5 this page runs just under 2 seconds. Sun 1.4.01: ~450ms Default (Sun?) 1.3: ~280ms JRockit 3.1.5: ~180ms JRockit also comes with a cool JVM monitor that lets you see visually all sorts of in depth things that are going on the the JVM live. http://commerce.bea.com/downloads/weblogic_jrockit.jsp Just checked it out for myself, and I'm also seeing major speed improvements. I can't find anything on the BEA website about pricing of this beast, so I'm assuming ti's free (?). Jesse __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help
You may wish to search the archives of this list for information on working with Paypal. While my own experience with them has not been too rocky, a number of other developers have noted serious issues working with the company. Back in 1999, I worked on a similar project for a group of physicians selling medical supplies and academic materials online. One office was a supplier of the medical supplies, and one office distributed the academic materials. The two sets of products went together logically, but the two businesses were completely separate. What ended up happening is the two physicians, with the help of their lawyer, set up an LLC to handle the finances and divided the revenue generated from the site between the two offices based on the actual costs involved. The point of this story: the solution may not be technological in nature. While I could see someone setting up a new Paypal account to handle the transactions, I find it hard to believe there is a way to 'split' the results of a Paypal transaction into two or more separate accounts. Considering the fact each transaction must be authorized explicitly by the purchaser, the user interface for such a thing would probably be a ghastly thing to see. You may want to suggest a traditional merchant account with Verisign as an alternative. M -Original Message- From: Watson, Marci [NH] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 12:55 PM To: CF-Talk Subject: Help Hello Everyone, I have a colleague who wants me to design a site for him. The concept is one already being used, he has a list of people who want him to provide a virtual storefront for them. The site would provide a place for vendors to input their information and products. He wants to use PayPal for the processing and payment of products. However if a user purchases a product from multiple vendors, I am unsure how that would be worked out. I am in the very initial stages of this project and would kindly take any advice from anyone who could offer some. Is there a Coldfusion extension out there that can assist me? Marci Watson We are not free, separate, and independent entities, but like links in a chain, and we could not by any means be what we are without those who went before us and showed us the way. ~Thomas Mann __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Help
Latest thread on CF and paypal: http://www.houseoffusion.com/cf_lists/index.cfm?method=messagesthreadid=14248forumid=4 Search string: http://www.houseoffusion.com/cf_lists/index.cfm?method=resultsforumid=4Search=paypal You may wish to search the archives of this list for information on working with Paypal. While my own experience with them has not been too rocky, a number of other developers have noted serious issues working with the company. Back in 1999, I worked on a similar project for a group of physicians selling medical supplies and academic materials online. One office was a supplier of the medical supplies, and one office distributed the academic materials. The two sets of products went together logically, but the two businesses were completely separate. What ended up happening is the two physicians, with the help of their lawyer, set up an LLC to handle the finances and divided the revenue generated from the site between the two offices based on the actual costs involved. The point of this story: the solution may not be technological in nature. While I could see someone setting up a new Paypal account to handle the transactions, I find it hard to believe there is a way to 'split' the results of a Paypal transaction into two or more separate accounts. Considering the fact each transaction must be authorized explicitly by the purchaser, the user interface for such a thing would probably be a ghastly thing to see. You may want to suggest a traditional merchant account with Verisign as an alternative. M -Original Message- From: Watson, Marci [NH] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 12:55 PM To: CF-Talk Subject: Help Hello Everyone, I have a colleague who wants me to design a site for him. The concept is one already being used, he has a list of people who want him to provide a virtual storefront for them. The site would provide a place for vendors to input their information and products. He wants to use PayPal for the processing and payment of products. However if a user purchases a product from multiple vendors, I am unsure how that would be worked out. I am in the very initial stages of this project and would kindly take any advice from anyone who could offer some. Is there a Coldfusion extension out there that can assist me? Marci Watson We are not free, separate, and independent entities, but like links in a chain, and we could not by any means be what we are without those who went before us and showed us the way. ~Thomas Mann __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Problem with double and single quotes using CFMX and MSSQL2k
Hello Everyone, This is my first post here, so I apologize in advance if my question is not formed properly. I have an online enrollment built in CFMX and supported with MSSQL2k database. Its fairly simple set of pages that allows our customers to register their contact information, signup for subscriptions and agree to a dynamic generated user agreement. Everything works, but I have a couple of annoying things happening. Within the user agreement pages I pull text out of the database and then process an acceptance of the agreement by CFMAILing them the agreement. In areas of the agreement where a word is either double quoted or single quoted the screen and emails have either square boxes and/or question marks appear in place of the quotes. I have verified that the database fields do have single and double quotes. Furthermore, the fields in MSSQL2k have a data type of Text with a length of 16 and allowing Nulls. For reference and briefly the process of the enrollment is handled as follows: 1. New enrollee begins the process by becoming authenticated with a enrollment code given to them previously. 2. The new enrollee is asked to complete an initial contact information form. At this point their information is stored in a table that is viewed as having temporary information, later to be moved after completion of the enrollment. 3. Next the enrollee chooses from a set of available services they wish to subscribe to. All info is pulled from the database. Updates to the temp table are made when they click on submit. 4. Next they review their selection and cost totals, with an option to edit. 5. Next they see their user agreement. At this point based on their services selection different text will appears. 6. At this point they can accept or decline the whole registration. If they accept then a set of emails is sent to us and the new enrollee. Also when they accept the temp data is moved from the temp tables and put into an enrollee table and the temp data is deleted. In every database step that involves the agreement text the quotes and single quotes appear to be ok and passed along without problems. Its just when the info is seen onscreen or in the emails that the characters are changed. What do I have to do to correct this annoyance. Thank you in advance for your help. Best Regards, Ali Daniali Transact Communication, Inc. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Multivendor shopping cart (was: Help)
Should have read your initial post more carefully. You were asking about the finances only. That aforementioned client used a Verisign Payflow Pro account and did the accounting internally. The specific dollar values were kept track of in the cart system and the site owner paid the vendors directly by check. --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -Original Message- From: Watson, Marci [NH] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 9:55 AM To: CF-Talk Subject: Help Hello Everyone, I have a colleague who wants me to design a site for him. The concept is one already being used, he has a list of people who want him to provide a virtual storefront for them. The site would provide a place for vendors to input their information and products. He wants to use PayPal for the processing and payment of products. However if a user purchases a product from multiple vendors, I am unsure how that would be worked out. I am in the very initial stages of this project and would kindly take any advice from anyone who could offer some. Is there a Coldfusion extension out there that can assist me? Marci Watson We are not free, separate, and independent entities, but like links in a chain, and we could not by any means be what we are without those who went before us and showed us the way. ~Thomas Mann __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF mail - mail server
The mail works fine on our existing site. It works fine on our development box, both boxes have a separate mail server and works fine. Our machine is behind a fire wall. All outgoing SMTP traffic is allowed on the firewall. There is no mail server on this machine. The mail server defined in the CF admin is an IP address outside the firewall. Using CFMAIL to generate an email. C:CFUSION\LOG\mail.log says: Error,TID=2920,08/20/02,13:56:41,An unknown exception happened while attempting to process spooled mail. Polling will continue. The generated mail msg sits in the CF C:\CFUSION\Mail\Spool directory But doesn't sit in C:\CFUSION\MAIL\UNDELIVR We're using: CF 4.5.1 SP 2 Windows 2000 IIS 5.0 Help // glm -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 10:54 AM To: CF-Talk Subject: Re: CF mail - mail server In my experience, unknown exception conditions are usually caused by some sort of bug -- it's an unantiscipated error which is why there's no detailed error information as is normally provided... For instance, if you don't specify a mail server in the cfmail tag and no default server is specified in the cfadministrator, the error message says that no mail server has been specified in either location. You might want to post the code for your cfmail tag to the list -- maybe there's something fishy about the syntax... Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 Do you need to add a seperate mail server in order for cold fusion to send mail out CFMAIL ? From everything I read I don't think so. However we keep getting an error and want to rule this out. Error Diagnostic Information unknown exception condition TagCFMail::sendMessage The error occurred while processing an element with a general identifier of (CFMAIL), occupying document position (36:4) to (39:28). ++ Gilbert Midonnet BrokerTec USA, LLC (201) 209-7843 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfoutput within cfform problem on MX?
On 8/20/02, Joshua Miller penned: Ya know, I've run into this problem as well, and one of my friends and former associates did too, so much so that we totally stopped using CFFORM and wrote our own validation routines. Doesn't help out much if you're using some of the CF form objects not geared towards validation, but it may be worthwhile to look at another solution. Something about using CFFORM inside of CFOUTPUT just gave us fits. If you're interested I'll send you the validation routines and tag that we wrote to get around cfform. Sure thing. Man, I wish they'd try to think about backward compatibility a little bit. I lost my a$$ migrating from 4.0 to 4.5 with the scope attribute they added to cflock, and now it looks like it's going to happen again. I can understand adding the scope attribute, but this is needless. Hopefully they'll get it in a service pack. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFObject
I have a question about using cfobject. I have this dll that was made for asp. I want to convert it to coldfusion since this is what I use. Here is the code for asp % Set ActiveObj = Server.CreateObject(ACTarget.IPGEO) IP=150.48.244.170 IPFullCountry=ActiveObj.FullLookUp(CStr(IP)) Set ActiveObj=nothing % %=IPFullcountry% How would I do this in coldfusion? __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Problem with double and single quotes using CFMX and MSSQL2k
Just a guess, but I think these may not be the characters you think they are. The nomal single quote: chr(39) The left single quote: chr(145) The right single quote: chr(146) The normal double quote: chr(34) The left double quote: chr(147) The right double quote: chr(148) The fancy or smart quotes will not render properly in many instances, and in many fonts. You might think about replacing them with there generic counterparts, or making sure you are rendering the text in a Unicode/DCBS enabled browser. If you are mailing the text as plaintext, you will need to use the text-safe characters, rather than the extended fancy versions. Jerry Johnson [EMAIL PROTECTED] 08/20/02 01:55PM Hello Everyone, This is my first post here, so I apologize in advance if my question is not formed properly. I have an online enrollment built in CFMX and supported with MSSQL2k database. Its fairly simple set of pages that allows our customers to register their contact information, signup for subscriptions and agree to a dynamic generated user agreement. Everything works, but I have a couple of annoying things happening. Within the user agreement pages I pull text out of the database and then process an acceptance of the agreement by CFMAILing them the agreement. In areas of the agreement where a word is either double quoted or single quoted the screen and emails have either square boxes and/or question marks appear in place of the quotes. I have verified that the database fields do have single and double quotes. Furthermore, the fields in MSSQL2k have a data type of Text with a length of 16 and allowing Nulls. For reference and briefly the process of the enrollment is handled as follows: 1. New enrollee begins the process by becoming authenticated with a enrollment code given to them previously. 2. The new enrollee is asked to complete an initial contact information form. At this point their information is stored in a table that is viewed as having temporary information, later to be moved after completion of the enrollment. 3. Next the enrollee chooses from a set of available services they wish to subscribe to. All info is pulled from the database. Updates to the temp table are made when they click on submit. 4. Next they review their selection and cost totals, with an option to edit. 5. Next they see their user agreement. At this point based on their services selection different text will appears. 6. At this point they can accept or decline the whole registration. If they accept then a set of emails is sent to us and the new enrollee. Also when they accept the temp data is moved from the temp tables and put into an enrollee table and the temp data is deleted. In every database step that involves the agreement text the quotes and single quotes appear to be ok and passed along without problems. Its just when the info is seen onscreen or in the emails that the characters are changed. What do I have to do to correct this annoyance. Thank you in advance for your help. Best Regards, Ali Daniali Transact Communication, Inc. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: BEA JRockit = Fast
Dammit it's not on Solaris yet... :\ Thx for the info... -Original Message- From: Ryan Kime [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 1:46 PM To: CF-Talk Subject: RE: BEA JRockit = Fast I just got off the phone with BEA Sales. Here's the skinny on JRockit: there is no cost associated with it unless you want to buy a support and maintenance contract with them which would cost you $2,000. Apparently, all of their other products have a 30 day expiration eval license, but he said most likely JRockit is different due to the nature of the app and will continue to work after 30 days. Here's a question, so when the CFMX for J2EE using BEA WebLogic comes out, will it be using the Jrockit JVM??? I would assume so... -Original Message- From: Jesse Houwing [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 5:26 AM To: CF-Talk Subject: Re: BEA JRockit = Fast Jon Hall wrote: I happened across BEA's JVM today, and tested 2 of my applications with it. Both run without any problems so far. The coolest thing though is that it is blazing fast. On my home computer, with mp3's playing etc. Here are some unscientific averages for the front page of a forum app that deals with some large cached queries, and does some significant heavy lifting. In CF5 this page runs just under 2 seconds. Sun 1.4.01: ~450ms Default (Sun?) 1.3: ~280ms JRockit 3.1.5: ~180ms JRockit also comes with a cool JVM monitor that lets you see visually all sorts of in depth things that are going on the the JVM live. http://commerce.bea.com/downloads/weblogic_jrockit.jsp Just checked it out for myself, and I'm also seeing major speed improvements. I can't find anything on the BEA website about pricing of this beast, so I'm assuming ti's free (?). Jesse __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problem with double and single quotes using CFMX and MSSQL2k
Not in any of the pages within the enrollment. Thanks, Ali -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 11:14 AM To: CF-Talk Subject: RE: Problem with double and single quotes using CFMX and MSSQL2k Are you using trim() inside of a cfqueryparam tag? Might be it, known issue... Stace -Original Message- From: Ali Daniali [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 1:56 PM To: CF-Talk Subject: Problem with double and single quotes using CFMX and MSSQL2k Hello Everyone, This is my first post here, so I apologize in advance if my question is not formed properly. I have an online enrollment built in CFMX and supported with MSSQL2k database. Its fairly simple set of pages that allows our customers to register their contact information, signup for subscriptions and agree to a dynamic generated user agreement. Everything works, but I have a couple of annoying things happening. Within the user agreement pages I pull text out of the database and then process an acceptance of the agreement by CFMAILing them the agreement. In areas of the agreement where a word is either double quoted or single quoted the screen and emails have either square boxes and/or question marks appear in place of the quotes. I have verified that the database fields do have single and double quotes. Furthermore, the fields in MSSQL2k have a data type of Text with a length of 16 and allowing Nulls. For reference and briefly the process of the enrollment is handled as follows: 1. New enrollee begins the process by becoming authenticated with a enrollment code given to them previously. 2. The new enrollee is asked to complete an initial contact information form. At this point their information is stored in a table that is viewed as having temporary information, later to be moved after completion of the enrollment. 3. Next the enrollee chooses from a set of available services they wish to subscribe to. All info is pulled from the database. Updates to the temp table are made when they click on submit. 4. Next they review their selection and cost totals, with an option to edit. 5. Next they see their user agreement. At this point based on their services selection different text will appears. 6. At this point they can accept or decline the whole registration. If they accept then a set of emails is sent to us and the new enrollee. Also when they accept the temp data is moved from the temp tables and put into an enrollee table and the temp data is deleted. In every database step that involves the agreement text the quotes and single quotes appear to be ok and passed along without problems. Its just when the info is seen onscreen or in the emails that the characters are changed. What do I have to do to correct this annoyance. Thank you in advance for your help. Best Regards, Ali Daniali Transact Communication, Inc. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Best Way To Return Query Row Number?
Is there a pseudo column I can return on a QofQ that provides the rownumber? Say for example I have: cfquery name=test type=query SELECT name FROM mytable WHERE name = test /cfquery Or anyone have an alternate solution? Thanks! AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Any Fusebox and CFMX issues?
I've done a couple of quasi-Fusebox style sites using CF 4.5. Working up towards going whole-hog Fusebox on the next one, which would be on CFMX. Any issues I should be aware of, or changes between CF4.5/5 to MX that I need to be aware of in relation to Fusebox? Fusebox Pros? Fusebox Cons? As usual, your opinions are greatly appreciated and respected! Fusebox has been really good to me when I've been able to use it. It's nice to have the structure ( particularly in FB3 since they've condensed it and it's a lot simpler now )... Once when I downloaded the core files from fusebox.org there was a small bug with an undefined fusebox.homecircuit variable although it was easily repaired -- when I went back to download them again at a different location, apparently that bug had been fixed, but there was also a change in the manner in which the fusebox.circuits string elements were interpreted, which took me a few minutes to sort out since I'd been used to a different syntax... I didn't notice the version on the core files changing between those 2 times, although it may have. The only other thing I will mention is that if you think you may need to use cfflush for anything, you should put some additional forethought into the site layout and how you want to approach that. You may find that you want to continue to use the FB3 core files nested layout stuff for the majority of the site or application, however, any page which requires cfflush will not be able to use the current FB3 core files layout features, because it places the bulk of the page content ( non-layout ) within either a cfsavecontent tag or a custom tag, neither of which are allowed to have cfflush within them... Though Hal recently confirmed that the fusebox org are currently working on a new model for layout. Thanks Hal! :) Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Best Way To Return Query Row Number?
Uh, test.rowcolumn doesn't work? ~Todd On Tue, 20 Aug 2002, Stacy Young wrote: Is there a pseudo column I can return on a QofQ that provides the rownumber? Say for example I have: cfquery name=test type=query SELECT name FROM mytable WHERE name = test /cfquery Or anyone have an alternate solution? Thanks! AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Best Way To Return Query Row Number? (fwd)
I meant test.currentRow, sorry. -- Forwarded message -- Date: Tue, 20 Aug 2002 14:31:57 -0400 (EDT) From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: Best Way To Return Query Row Number? Uh, test.rowcolumn doesn't work? ~Todd On Tue, 20 Aug 2002, Stacy Young wrote: Is there a pseudo column I can return on a QofQ that provides the rownumber? Say for example I have: cfquery name=test type=query SELECT name FROM mytable WHERE name = test /cfquery Or anyone have an alternate solution? Thanks! AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Any Fusebox and CFMX issues?
On Tuesday, August 20, 2002, at 10:47 , Les Mizzell wrote: Any issues I should be aware of, or changes between CF4.5/5 to MX that I need to be aware of in relation to Fusebox? I don't know if anyone has addressed performance issues with the Fusebox architecture on CFMX but here are some of my thoughts about Fusebox itself: http://www.corfield.org/coldfusion.phtml?cfsection=coldfusion/fusebox If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Best Way To Return Query Row Number?
In oracle for instance it's rownum , wondering if there's an equivalent in QofQ... -Original Message- From: Stacy Young Sent: Tuesday, August 20, 2002 2:30 PM To: '[EMAIL PROTECTED]' Subject: RE: Best Way To Return Query Row Number? What that might not have been clear...I need the rownumber in which the record was found (for updating later)... Stace -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 2:20 PM To: CF-Talk Subject: Best Way To Return Query Row Number? Is there a pseudo column I can return on a QofQ that provides the rownumber? Say for example I have: cfquery name=test type=query SELECT name FROM mytable WHERE name = test /cfquery Or anyone have an alternate solution? Thanks! AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF mail - mail server
The mail works fine on our existing site. It works fine on our development box, both boxes have a separate mail server and works fine. Our machine is behind a fire wall. All outgoing SMTP traffic is allowed on the firewall. There is no mail server on this machine. The mail server defined in the CF admin is an IP address outside the firewall. Using CFMAIL to generate an email. C:CFUSION\LOG\mail.log says: Error,TID=2920,08/20/02,13:56:41,An unknown exception happened while attempting to process spooled mail. Polling will continue. The generated mail msg sits in the CF C:\CFUSION\Mail\Spool directory But doesn't sit in C:\CFUSION\MAIL\UNDELIVR We're using: CF 4.5.1 SP 2 Windows 2000 IIS 5.0 Help That really sounds like a tech-support call. I would have a really hard time imagining that the firewall would be related to an unknown exception condition -- it sounds to me like an internal problem with your coldfusion server -- like a corrupted file or somesuch... although I'm not a support agent for CF ... I used to do 1st-2nd lvl tech support for HP's Vectras, but that hardly qualifies me and it doesn't help your situation. :-/ Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Best Way To Return Query Row Number?
This seems quite dangerous to me - why not just use the primary key? === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : cfjedimaster My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 2:32 PM To: CF-Talk Subject: RE: Best Way To Return Query Row Number? In oracle for instance it's rownum , wondering if there's an equivalent in QofQ... -Original Message- From: Stacy Young Sent: Tuesday, August 20, 2002 2:30 PM To: '[EMAIL PROTECTED]' Subject: RE: Best Way To Return Query Row Number? What that might not have been clear...I need the rownumber in which the record was found (for updating later)... Stace -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 2:20 PM To: CF-Talk Subject: Best Way To Return Query Row Number? Is there a pseudo column I can return on a QofQ that provides the rownumber? Say for example I have: cfquery name=test type=query SELECT name FROM mytable WHERE name = test /cfquery Or anyone have an alternate solution? Thanks! AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Best Way To Return Query Row Number?
There is a CFMX specific way to do that with any query. Simply use the undocumented query method getRow e.g. queryName.getRow(). Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ V: 415-577-8070 F: 415-341-8906 P: [EMAIL PROTECTED] -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 11:20 AM To: CF-Talk Subject: Best Way To Return Query Row Number? Is there a pseudo column I can return on a QofQ that provides the rownumber? Say for example I have: cfquery name=test type=query SELECT name FROM mytable WHERE name = test /cfquery Or anyone have an alternate solution? Thanks! AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Best Way To Return Query Row Number?
Is there a pseudo column I can return on a QofQ that provides the rownumber? Say for example I have: cfquery name=test type=query SELECT name FROM mytable WHERE name = test /cfquery Or anyone have an alternate solution? If you want to get the row number containing a given value (I'm guessing here), you can use something like cfset idx = ListFindNoCase(ValueList(myquery.name),test) hth Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problem with double and single quotes using CFMX and MSSQL2k
Looks like this suggestion worked...I had those fancy quotes in the darn DB. Must have been imported from MSWORD when they were cut and pasted into Access originally! Got to love clean data. Thanks for your time and help. Best Regards, Ali Daniali -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 11:10 AM To: CF-Talk Subject: Re: Problem with double and single quotes using CFMX and MSSQL2k Just a guess, but I think these may not be the characters you think they are. The nomal single quote: chr(39) The left single quote: chr(145) The right single quote: chr(146) The normal double quote: chr(34) The left double quote: chr(147) The right double quote: chr(148) The fancy or smart quotes will not render properly in many instances, and in many fonts. You might think about replacing them with there generic counterparts, or making sure you are rendering the text in a Unicode/DCBS enabled browser. If you are mailing the text as plaintext, you will need to use the text-safe characters, rather than the extended fancy versions. Jerry Johnson [EMAIL PROTECTED] 08/20/02 01:55PM Hello Everyone, This is my first post here, so I apologize in advance if my question is not formed properly. I have an online enrollment built in CFMX and supported with MSSQL2k database. Its fairly simple set of pages that allows our customers to register their contact information, signup for subscriptions and agree to a dynamic generated user agreement. Everything works, but I have a couple of annoying things happening. Within the user agreement pages I pull text out of the database and then process an acceptance of the agreement by CFMAILing them the agreement. In areas of the agreement where a word is either double quoted or single quoted the screen and emails have either square boxes and/or question marks appear in place of the quotes. I have verified that the database fields do have single and double quotes. Furthermore, the fields in MSSQL2k have a data type of Text with a length of 16 and allowing Nulls. For reference and briefly the process of the enrollment is handled as follows: 1. New enrollee begins the process by becoming authenticated with a enrollment code given to them previously. 2. The new enrollee is asked to complete an initial contact information form. At this point their information is stored in a table that is viewed as having temporary information, later to be moved after completion of the enrollment. 3. Next the enrollee chooses from a set of available services they wish to subscribe to. All info is pulled from the database. Updates to the temp table are made when they click on submit. 4. Next they review their selection and cost totals, with an option to edit. 5. Next they see their user agreement. At this point based on their services selection different text will appears. 6. At this point they can accept or decline the whole registration. If they accept then a set of emails is sent to us and the new enrollee. Also when they accept the temp data is moved from the temp tables and put into an enrollee table and the temp data is deleted. In every database step that involves the agreement text the quotes and single quotes appear to be ok and passed along without problems. Its just when the info is seen onscreen or in the emails that the characters are changed. What do I have to do to correct this annoyance. Thank you in advance for your help. Best Regards, Ali Daniali Transact Communication, Inc. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Best Way To Return Query Row Number?
What that might not have been clear...I need the rownumber in which the record was found (for updating later)... Stace -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 2:20 PM To: CF-Talk Subject: Best Way To Return Query Row Number? Is there a pseudo column I can return on a QofQ that provides the rownumber? Say for example I have: cfquery name=test type=query SELECT name FROM mytable WHERE name = test /cfquery Or anyone have an alternate solution? Thanks! AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Best Way To Return Query Row Number?
It's a special case on a small query in memory...going to try another solution...thx -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 2:35 PM To: CF-Talk Subject: RE: Best Way To Return Query Row Number? This seems quite dangerous to me - why not just use the primary key? === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : cfjedimaster My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 2:32 PM To: CF-Talk Subject: RE: Best Way To Return Query Row Number? In oracle for instance it's rownum , wondering if there's an equivalent in QofQ... -Original Message- From: Stacy Young Sent: Tuesday, August 20, 2002 2:30 PM To: '[EMAIL PROTECTED]' Subject: RE: Best Way To Return Query Row Number? What that might not have been clear...I need the rownumber in which the record was found (for updating later)... Stace -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 2:20 PM To: CF-Talk Subject: Best Way To Return Query Row Number? Is there a pseudo column I can return on a QofQ that provides the rownumber? Say for example I have: cfquery name=test type=query SELECT name FROM mytable WHERE name = test /cfquery Or anyone have an alternate solution? Thanks! AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Best Way To Return Query Row Number?
Matt, What does getRow() return? -mk -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 1:34 PM To: CF-Talk Subject: RE: Best Way To Return Query Row Number? There is a CFMX specific way to do that with any query. Simply use the undocumented query method getRow e.g. queryName.getRow(). Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ V: 415-577-8070 F: 415-341-8906 P: [EMAIL PROTECTED] -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 11:20 AM To: CF-Talk Subject: Best Way To Return Query Row Number? Is there a pseudo column I can return on a QofQ that provides the rownumber? Say for example I have: cfquery name=test type=query SELECT name FROM mytable WHERE name = test /cfquery Or anyone have an alternate solution? Thanks! AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Best Way To Return Query Row Number?
You want to select a row # of a particular query? I don't quite understand your question. === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : cfjedimaster My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 2:20 PM To: CF-Talk Subject: Best Way To Return Query Row Number? Is there a pseudo column I can return on a QofQ that provides the rownumber? Say for example I have: cfquery name=test type=query SELECT name FROM mytable WHERE name = test /cfquery Or anyone have an alternate solution? Thanks! __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Best Way To Return Query Row Number?
I'm using a QofQ to locate a row based on given WHERE clause and would like to also return the row number the result was located on. Stace -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 2:26 PM To: CF-Talk Subject: RE: Best Way To Return Query Row Number? You want to select a row # of a particular query? I don't quite understand your question. === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : cfjedimaster My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 2:20 PM To: CF-Talk Subject: Best Way To Return Query Row Number? Is there a pseudo column I can return on a QofQ that provides the rownumber? Say for example I have: cfquery name=test type=query SELECT name FROM mytable WHERE name = test /cfquery Or anyone have an alternate solution? Thanks! __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
