RE: Is there an Apollo developer's mailing list?
Mark, There is one Apollo Coders mailing list: http://tech.groups.yahoo.com/group/apollocoders/ Hua -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 21, 2007 12:26 PM To: CF-Talk Subject: OT: Is there an Apollo developer's mailing list? I couldn't spot one apart from the Adobe forums? MD ~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273291 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: getMetricData function not work on CF 7 multiserver installation ?
Thanks DK. I've checked the sites and looks like paring log data is the only option ... Hua -Original Message- From: Douglas Knudsen [mailto:[EMAIL PROTECTED] Sent: Thursday, August 10, 2006 3:10 PM To: CF-Talk Subject: Re: getMetricData function not work on CF 7 multiserver installation ? Wei, look at http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_19120 http://tutorial351.easycfm.com/ http://www.robisen.com/index.cfm/2006/5/26/Monitoring-performance-on-ColdFusion-for-J2EE-Multiserver--Outputting-metrics-to-CVS http://www.bpurcell.org/blog/index.cfm?mode=entry&entry=991 getMetrics is not avaiable at all in the multiserver config. Robi Sens's entry above describes how to get the data output so you can import into excel if you need graphs and such. DK On 8/10/06, Hua Wei <[EMAIL PROTECTED]> wrote: > > > Thanks Terrence. > > Too bad getMetricData doesn't work on Multiserver installations. Any > other way to programmably get perfomance metics like what > getMetricData does? > > Hua > > -Original Message- > From: Ryan, Terrence [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 10, 2006 11:52 AM > To: CF-Talk > Subject: RE: getMetricData function not work on CF 7 multiserver > installation ? > > From what I remember, getMetricData doesn't work at all on a > Multiserver configuration. > > What I think that technote does is tell you how to get equivalent > metric data out of Jrun and into a log file, which you can't consume > in ColdFusion (without using cffile.) > > > > Terrence Ryan > Senior Systems Programmer > Wharton Computing and Information Technology > > E-mail: [EMAIL PROTECTED] > > > -Original Message- > From: Hua Wei [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 10, 2006 10:39 AM > To: CF-Talk > Subject: getMetricData function not work on CF 7 multiserver > installation ? > > Hello, > > For some reason, I can't get metrics running on our coldfusion > 7.0.2servers (Enterprise Multiserver Version on windows 2003, window > 2000). I got "The metrics service is not available" error when calling > getMetricData function. > > I followed the instruction of TechNote "ColdFusion MX: Enabling > metrics logging" > (http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_19120) > and enabled JRun metrics logging, seemed the metrics info was logged > into cfusion-out.log, === > 08/09 00:30:56 metrics Web threads (busy/total): 3/5 Sessions: 1 Total > Memory=46144 Free=26914 === > > but when i tried to call function getMetricData("perf_monitor"), I got > "The metrics service is not available." error and the log showed > > > 08/09 00:43:10 Error [jrpp-4] - The metrics service is not > available.Thisexception is usually caused by service startup failure. > Please check your server configuration. The specific sequence of files > included or processed is: F:\wwwroot\test.cfm, line: 6 > > > I noticed the following message during server setup: > "08/09 00:29:46 Information [scheduler-9] - The metrics service is > disabled for the J2EE edition" > > also, according to coldfusion help manual "To receive data, you must > enable PerfMonitor in ColdFusion Administrator before executing the > function.", but I couldn't find the "enable PerfMonitor" option in > coldfusion admin. > (http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/c > om > mon/html/wwhelp.htm?context=ColdFusion_Documentation&file=0489.htm > ) > > > What am i missing here? How to enable the metrics service on > multiserver installs? Does getMetricData not work on multiserver installs ? > > Thanks > > Hua > > > > > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249509 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: getMetricData function not work on CF 7 multiserver installation ?
Thanks Terrence. Too bad getMetricData doesn't work on Multiserver installations. Any other way to programmably get perfomance metics like what getMetricData does? Hua -Original Message- From: Ryan, Terrence [mailto:[EMAIL PROTECTED] Sent: Thursday, August 10, 2006 11:52 AM To: CF-Talk Subject: RE: getMetricData function not work on CF 7 multiserver installation ? >From what I remember, getMetricData doesn't work at all on a Multiserver >configuration. What I think that technote does is tell you how to get equivalent metric data out of Jrun and into a log file, which you can't consume in ColdFusion (without using cffile.) Terrence Ryan Senior Systems Programmer Wharton Computing and Information Technology E-mail: [EMAIL PROTECTED] -Original Message- From: Hua Wei [mailto:[EMAIL PROTECTED] Sent: Thursday, August 10, 2006 10:39 AM To: CF-Talk Subject: getMetricData function not work on CF 7 multiserver installation ? Hello, For some reason, I can't get metrics running on our coldfusion 7.0.2 servers (Enterprise Multiserver Version on windows 2003, window 2000). I got "The metrics service is not available" error when calling getMetricData function. I followed the instruction of TechNote "ColdFusion MX: Enabling metrics logging" (http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_19120) and enabled JRun metrics logging, seemed the metrics info was logged into cfusion-out.log, === 08/09 00:30:56 metrics Web threads (busy/total): 3/5 Sessions: 1 Total Memory=46144 Free=26914 === but when i tried to call function getMetricData("perf_monitor"), I got "The metrics service is not available." error and the log showed 08/09 00:43:10 Error [jrpp-4] - The metrics service is not available.This exception is usually caused by service startup failure. Please check your server configuration. The specific sequence of files included or processed is: F:\wwwroot\test.cfm, line: 6 I noticed the following message during server setup: "08/09 00:29:46 Information [scheduler-9] - The metrics service is disabled for the J2EE edition" also, according to coldfusion help manual "To receive data, you must enable PerfMonitor in ColdFusion Administrator before executing the function.", but I couldn't find the "enable PerfMonitor" option in coldfusion admin. (http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/com mon/html/wwhelp.htm?context=ColdFusion_Documentation&file=0489.htm ) What am i missing here? How to enable the metrics service on multiserver installs? Does getMetricData not work on multiserver installs ? Thanks Hua ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249486 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
getMetricData function not work on CF 7 multiserver installation ?
Hello, For some reason, I can't get metrics running on our coldfusion 7.0.2 servers (Enterprise Multiserver Version on windows 2003, window 2000). I got "The metrics service is not available" error when calling getMetricData function. I followed the instruction of TechNote "ColdFusion MX: Enabling metrics logging" (http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_19120) and enabled JRun metrics logging, seemed the metrics info was logged into cfusion-out.log, === 08/09 00:30:56 metrics Web threads (busy/total): 3/5 Sessions: 1 Total Memory=46144 Free=26914 === but when i tried to call function getMetricData("perf_monitor"), I got "The metrics service is not available." error and the log showed 08/09 00:43:10 Error [jrpp-4] - The metrics service is not available.This exception is usually caused by service startup failure. Please check your server configuration. The specific sequence of files included or processed is: F:\wwwroot\test.cfm, line: 6 I noticed the following message during server setup: "08/09 00:29:46 Information [scheduler-9] - The metrics service is disabled for the J2EE edition" also, according to coldfusion help manual "To receive data, you must enable PerfMonitor in ColdFusion Administrator before executing the function.", but I couldn't find the "enable PerfMonitor" option in coldfusion admin. (http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentation&file=0489.htm ) What am i missing here? How to enable the metrics service on multiserver installs? Does getMetricData not work on multiserver installs ? Thanks Hua ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249458 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: sql question.
select * >From tablename where patindex('%\%\%',dir) = 0 And patindex('%\%',dir) > 0 -Original Message- From: Brian Dumbledore [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 02, 2006 4:31 PM To: CF-Talk Subject: sql question. I am using MS-SQL, I couldn't get this to work.. I tried, patindex,charindex, like combinations, none worked. I have directory paths in a table, given a starting path of a directory, I want to get its first level elements. eg: table has warranty\a\1.jpg warranty\a warranty\a\2.jpg warranty\a22 warranty\a-23 I want to get warranty\a,warranty\a22,warranty\a-23 I tried all combinations, it doesn't work (correctly). I actually get only warranty\a, but don't get the other two (which makes me thing it is because of the numbers in the string.. but doesn't make any sense). Please help Thanks for your time. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248685 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Querying for MAX of join table
SELECT FROM tablename WHERE sort = (SELECT min(sort) FROM tablename ) -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Monday, June 05, 2006 10:07 AM To: CF-Talk Subject: Querying for MAX of join table I have a table that is something like : + id + sort + contact_id + office_id This is a many-to-many join table joining contacts and office. What I would like to do is get a query of that that has only the record with the top SORT for each contact_id. So if I had the data: Id sort cotnact_id office_id - - 11 40 1 21 57 1 32 57 2 41 63 5 I would end up with: Id sort cotnact_id office_id - - 11 40 1 21 57 1 41 63 5 Getting rid of record (id:3) since it has sort 2 and I only want the top sort for contact (id:57). I know I can do stuff with sub queryies and what not, but I was hoping there was a more elegant solution with grouping or something. Thanks! Ben Nadel Web Developer Nylon Technology 350 7th Avenue Floor 10 New York, NY 10001 212.691.1134 212.691.3477 fax www.nylontechnology.com "You know, like nunchuck skills, bowhunting skills, computer hacking skills... Girls only want boyfriends who have great skills." - Napoleon Dynamite ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242387 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Better Way to Query?
You may want to try GROUP BY client.id, client.company Instead of GROUP BY company -Original Message- From: Eric J. Hoffman [mailto:[EMAIL PROTECTED] Sent: Monday, May 08, 2006 3:50 PM To: CF-Talk Subject: Better Way to Query? Not getting good results from this: SELECT COUNT (customer_orders.corder_id) as TOTOT, client.company FROM customer_orders JOIN customer_orders_prod on customer_orders.corder_id = customer_orders_prod.order_id JOIN inventory on customer_orders_prod.product_id = inventory.service_id JOIN client on inventory.client_id = client.id WHERE customer_orders.orderdate BETWEEN #createODBCDate(start9)# AND #createODBCDate(DateAdd('D', 1, end9))# and corder_active = 1 GROUP BY company Each inventory item is tagged with a client ID. There is the order table, which is the summary, and the orders_prod table which is all the line items of inventory. My need is a report of orders by client_id. This query seems to give me more than if I just ran the total of orders. I only need to get one item from the order items to determine the client company. This shows me maybe 14,000+ for one client, when I know the total orders to be 12,000+. Thanks!! Eric J. Hoffman Managing Partner 2081 Industrial Blvd StillwaterMN55082 mail: [EMAIL PROTECTED] www: http://www.ejhassociates.com tel: 651.717.4105 fax: 651.717.4115 mob: 651.245.2717 This message contains confidential information and is intended only for [EMAIL PROTECTED] If you are not cf-talk@houseoffusion.com you should not disseminate, distribute or copy this e-mail. Please notify [EMAIL PROTECTED] immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Eric J. Hoffman therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239865 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Subversion tips?
Matt, Ryan Guill's subversion setup might be helpful . http://www.ryanguill.com/blog/index.cfm/2006/4/11/My-Subversion-Setup Hua -Original Message- From: Matt Williams [mailto:[EMAIL PROTECTED] Sent: Thursday, April 27, 2006 11:49 AM To: CF-Talk Subject: Subversion tips? I'm looking to join the Real World and start using version control software. >From what I've heard, SubVersion is as good as any. My environment is simple, >but may not take full advantage of SubVersion. Windows 2003 server with IIS 6.0 CF 7 Professional 3 developers on 3 Windows XP workstations Mapped network drive to the development server Currentlly each developer just opens a file through the mapped drive, does their edits, saves the file and uses IE/Firefox to browse to the page for testing. I've started reading the svn-book, and so far understand everything. The 'Working Copies' deal is what I'm most unclear on. Would each developer need to run CF locally (developer version) so they can edit and test their 'Working Copy'? If not, how does my server (since I'm not on Apache) know what version a given developer is working on? Any tips would be most appreciated. Matt ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238906 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Japanese text
Stas, Seems to me your local mechine doesn't have the East Asian Languages' package installed, so the mechine only displays blocks for japanese characters . If you are using MSSQL 2000/2005 and setup the propery collation, the data (japanese characters) in the table should be fine. You can test it by pulling the data out and displaying in html, please make sure to use In the coldfusion display page. Hua -Original Message- From: Stas Newdel [mailto:[EMAIL PROTECTED] Sent: Monday, April 24, 2006 1:30 PM To: CF-Talk Subject: Japanese text I am managing an ecommerce app and we are attempting to add Japanese text descriptions for the products. Currently, I am just doing a test of concept type of thing. I added another table that has an FK to products as well as the alternative description column. Our Japanese partner has supplied us with an Excel file containing descriptions in katakana which view fine in Excel. I set the description column's type to nvarchar and set its collation to be Japanese_BIN, however, when I try to paste the Japanese text into it, only some of the Roman characters are visible (as the the descriptions have things like "100% cotton"), but the Japanese characters are displayed as blocks. Could someone point me in the right directions? Thanks, Stas ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238539 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Need help with tricky XPath syntax
Larry, Not sure whether this is what you are looking for: /IDMS/identity/[EMAIL PROTECTED]'Active' and text()='Provost'] Returns this element: Provost Hua -Original Message- From: Lawrence B. Afrin, M.D. [mailto:[EMAIL PROTECTED] Sent: Friday, December 16, 2005 11:25 AM To: CF-Talk Subject: Need help with tricky XPath syntax Howdy -- I'm having difficulty crafting a tricky XPath expression and would appreciate help from any XPath gurus out there. Sample document: Provost Residents HR Provost UMA I need an XPath expression that will extract the array of elements with Active Provost sponsorship. Applying the expression I seek against the above document would yield a one-element array containing only the second element from the document. Extracting the elements with Provost sponsorship is trivial: /IDMS/identity[sponsorship='Provost'] The tricky part seems to be restricting the selection to only the *Active* Provost sponsorships. I've tried a zillion permutations on the following as the second argument to my XMLSearch() call, but none of my experiments has worked right yet: /IDMS/identity[sponsorship='Provost' and [EMAIL PROTECTED]'Active']] I've looked through all the XPath tutorials I could find but couldn't find an answer to this question (at least, not an answer I could understand). Looking at some complex examples I've found in some tutorials, I've gotten a vague sense that somehow "id()" and "self::" are going to be involved in a solution, but otherwise I'm just totally lost. Greatly appreciate any help anyone can provide. -- Larry Afrin Medical University of South Carolina ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227181 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
No need to var exceptionVariable for catch block in a cfc in CFMX 7.0.1?
Hello All, I just noticed that if there is a var exceptionVariable for the catch block in a cfc (code below), CFMX 7.0.1 throws the following error "Cannot declare local variable excpt twice. Local variables cannot have the same names as parameters or other local variables." This used to work on cfmx7. Does this mean no need to var exceptionVariable for the catch block in a cfc? Thanks Hua == code var excpt = ""; try{ // try block } catch (Any excpt) { //catch block } ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221208 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Fedex Shipping in realtime ( XML over https)
Gabriel, I implemented a few with no problem. Fedex service requires a few http header settings for the request: requestheader = structnew(); requestheader["Referer"] = "your company name"; requestheader["Host"] = "Fedex gateway Host"; requestheader["Accept"] = "image/gif, image/jpeg,image/pjpeg, text/plain, text/html, */*"; requestheader["Content-Type"] = "image/gif"; requestheader["Content-Length"] = len(trim(tostring(requestXML))); Hua -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 27, 2005 9:50 AM To: CF-Talk Subject: Fedex Shipping in realtime ( XML over https) I am having trouble using fedex xml over http to connect to their API. Anybody had any luck? The code I am using is the following: http://www.fedex.com/fsmapi"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:noNamespaceSchemaLocation="FDXSubscriptionRequest.xsd"> String 555 Gabriel transex Shipping 555 [EMAIL PROTECTED] 123 candle Houston TX 77754 US https://gatewaybeta.fedex.com:443/GatewayDC";> #CFHTTP.FileContent# http://www.w3.org/2001/XMLSchema-instance"; xsi:noNamespaceSchemaLocation="FDXSubscriptionReply.xsd"> String 1234567 FedEx Express Shipping https://gatewaybeta.fedex.com:443/GatewayDC";> I am also having problems understanding how to get the XML response back from the fedex server. Thanks Gabriel [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219335 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: find identical records
In MSSQL , ROWCOUNT is a Setting for Operations Against Remote Tables Try this: SELECT serialnumber, count(*) FROM inventory GROUP BY serialnumber HAVING count(*) > 1 -Original Message- From: Orlini, Robert [mailto:[EMAIL PROTECTED] Sent: Friday, September 23, 2005 2:54 PM To: CF-Talk Subject: RE: find identical records Using SQL -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Friday, September 23, 2005 2:39 PM To: CF-Talk Subject: Re: find identical records What DB are you using? Perhaps that's a reserved word, and needs to be escaped/changed? cheers, barneyb On 9/23/05, Orlini, Robert <[EMAIL PROTECTED]> wrote: > Thanks Barney. > > It says "Incorrect syntax near the keyword rowcount" > > -Original Message- > From: Barney Boisvert [mailto:[EMAIL PROTECTED] > Sent: Friday, September 23, 2005 2:27 PM > To: CF-Talk > Subject: Re: find identical records > > > SELECT serialnumber, count(*) AS rowCount FROM inventory GROUP BY > serialnumber HAVING rowCount > 1 > > That should give you a list of serials that exist more than once, > along with how many instances there are. And update your AVG, it says > it's out of date. > > cheers, > barneyb -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219136 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Track Visitor Country/City from IP address.
Ben, You can take a look at this: http://www.maxmind.com/app/ccfd_features It has HTTP service, so could be implemented in colfusion pretty easily. Hua -Original Message- From: Nomad [mailto:[EMAIL PROTECTED] Sent: Thursday, September 22, 2005 5:42 PM To: CF-Talk Subject: Track Visitor Country/City from IP address. Hello all, A client of mine is having a hard time with credit card fraudstars placing orders with stolen cards. At this time the client is collecting IP address of every customer placing an order but is having to check each ip address manually to determine the source country. What is the easiest way to track country / city from customer ip address programmatically in real time with CF? Thanks in advance, Ben Thomas ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219026 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: transmitting XML using CFHTTP
Andy, You can use cfhttpparam to build an HTTP request. Example: Hope this helps. Hua -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 20, 2005 11:41 AM To: CF-Talk Subject: transmitting XML using CFHTTP I need to transfer some data from our server to another server with a packet of XML. The transfer will send a string of plain text (XML), must be done with an encoding of application/x-www-form-urlencoded and a method of POST. I thought that cfhttp could do it, but I can't find where I can change the encoding and it appears that cfhttp HAS to send information with a variable name. This transmittion doesn't need a name, just the information sent to it. Is this possible with cfhttp? Here's the PHP we're using for comparison: socket = fsockopen($host, $port) or die('could not open ssl socket for DOMAIN'); fputs($this->socket, $request) or die('could not put to ssl socket for DOMAIN'); [EMAIL PROTECTED]($this->socket, 4096); if (strStr($results,'1')) { // success code here } else { // failure code here } ?> By the way, this is my first post on this list, so "hi". ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218707 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: USPS test 400 Bad Request
I replaced USERID and PASSWORD with mine, your code worked fine. Here is what I got in the cfhttp.FileContent Express2077020852100NoneREGULAR133.65 code used to test http://testing.shippingapis.com/ShippingAPITest.dll?API=Rate&XML=Express2077020852100NoneRegular -Original Message- From: Stan Winchester [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 13, 2005 2:40 PM To: CF-Talk Subject: Re: USPS test 400 Bad Request After looking at your example, I see I posted the wrong test snippet. I should have posted this one: http://testing.shippingapis.com/ShippingAPITest.dll?API=Rate&XML=Express2077020852100NoneRegular > > I think the url of the cfhttp should look like this: > http://testing.shippingapis.com/ShippingAPITest. > dll?API=RateV2&XML=#USPSRequest# > > Hua > > -Original Message- > From: Stan Winchester [mailto:[EMAIL PROTECTED] > Sent: Monday, September 12, 2005 8:28 PM > To: CF-Talk > Subject: USPS test 400 Bad Request > > Any ideas why when I do a test to the USPS test server I get a "400 > Bad Request"? > > I have taken the sample code and cut and pasted it, then sent is via > cfhttp as shown below: > > PASSWORD="x">> PRIORITY10022 tination>20008105 tination>>< > Destination>Cont > ainer>Flat Rate Box ntainer>REGULAR > > > > > Thank you, > Aftershock Web Design, Inc. > by: Stan Winchester > President/Developer > [EMAIL PROTECTED] > http://www.aftershockweb.com/ > Phone 503-244-3440 > Fax 503-244-3454 > > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218075 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: USPS test 400 Bad Request
I think the url of the cfhttp should look like this: http://testing.shippingapis.com/ShippingAPITest.dll?API=RateV2&XML=#USPSRequest# Hua -Original Message- From: Stan Winchester [mailto:[EMAIL PROTECTED] Sent: Monday, September 12, 2005 8:28 PM To: CF-Talk Subject: USPS test 400 Bad Request Any ideas why when I do a test to the USPS test server I get a "400 Bad Request"? I have taken the sample code and cut and pasted it, then sent is via cfhttp as shown below: PRIORITY1002220008105< Destination>Cont ainer>Flat Rate BoxREGULAR Thank you, Aftershock Web Design, Inc. by: Stan Winchester President/Developer [EMAIL PROTECTED] http://www.aftershockweb.com/ Phone 503-244-3440 Fax 503-244-3454 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218016 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: problem loading a JSP tag library into CF
Anthony, According to JRun 4 FAQ http://www.macromedia.com/software/jrun/productinfo/faq/#g200 "What are the major features of JRun 4? . High-performance web container with JSP 1.2 and servlet 2.3 support . " ditchnet-tabs-taglib requires JSP 2.0 spec Hua -Original Message- From: Anthony Prato [mailto:[EMAIL PROTECTED] Sent: Thursday, September 01, 2005 1:49 PM To: CF-Talk Subject: problem loading a JSP tag library into CF I've had a problem loading a JSP tag library. (CFMX7 developer) The livedocs say: Put the tag library, consisting of the taglibname.jar file, and the taglibname.tld file, if one is supplied, in the web_root/WEB-INF/lib directory. The JSP custom tag library must be in this directory for you to use the cfimport tag. Restart ColdFusion. In the ColdFusion page that uses a JSP tag from the tag library, specify the tag library name in a cfimport tag; for example: If the TLD file is not included in the JAR file, use the .tld suffix in place of the .jar suffix. (i restarted CF between all of these steps) The jar I'm trying to load (http://209.61.157.8:8080/taglibs/) has a tld file in it. I first tried the above and got the message: Could not import the tag library specified by "/WEB-INF/lib/ditchnet-tabs-taglib.jar". The following error was encountered: Tag Library Descriptor not found. Please ensure that you have specified a valid tag library. I then pulled the tld out of the jar and put it into the lib directory too... same error I then downloaded the jstl.jar and standard.jar from apache (as the taglib's docs instruct) and i get... same error I tried the last comment from the livedocs and changed my cfimport to at which point i get a 500 error: 500 javax/servlet/jsp/tagext/SimpleTagSupport I downloaded the random taglib from apache and used the code from livedocs and that worked :( The docs for this taglib say that: The Tabs Taglib has only been tested with the Apache Tomcat servlet container v5.0.28. A servlet container that implements at least the JSP 2.0 spec and the Servlet 2.3 spec will be required. What version jsp and servlet does CF7 support? Does anyone have any ideas on how to get this taglib to work? (or any other taglibs that will provide an html equivalent of what the flash forms tabs provide) Anthony ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217152 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Using JavaMail to send/fetch emails via SSL
Paul, thanks for the suggestion. I've searched the forums and googled the web, and seems authentication function is needed for sending emails. My impression is that sending email is more complicated, as a function getPasswordAuthentication needs to be overridden. Not sure how to port that to coldfusion. = Session session = Session.getDefaultInstance(props, new Authenticator(){ protected PasswordAuthentication getPasswordAuthentication() { return new PasswordAuthentication(username, password); }}); As for fetching emails, seems the following java code is needed to handle the ssl settings, I ported to coldfusion, but didn't work. == Security.addProvider(new com.sun.net.ssl.internal.ssl.Provider()); final String SSL_FACTORY = "javax.net.ssl.SSLSocketFactory"; // Get a Properties object Properties props = System.getProperties(); props.setProperty("mail.pop3.socketFactory.class", SSL_FACTORY); props.setProperty("mail.pop3.socketFactory.fallback", "false"); props.setProperty("mail.pop3.port", "995"); props.setProperty("mail.pop3.socketFactory.port", "995"); === Hua -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 30, 2005 1:51 PM To: CF-Talk Subject: Re: Using JavaMail to send/fetch emails via SSL RADEMAKERS Tanguy wrote: > Have you tried using JavaMail to fetch email from a different (non > gmail) ssl mail server? I.E. is the problem gmail specific? BTW: your > debug output ("DEBUG POP3: connecting to host "pop.gmail.com", port > 995, isSSL false") seems to indicate that you are *not* connecting > over SSL... it's been a while since i looked at SSL but if i recall correctly to authenticate SSL in javamail you need to create & pass in an authentication function. i'm at home, no access to any code but if you search the javamail section on jguru or sun's java mail forums there should be examples. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216850 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Using JavaMail to send/fetch emails via SSL
> "pop.gmail.com", port 995, isSSL false", > seems to indicate that you are *not* connecting over SSL... That's what I suspected .. But couldn't figure out why the prop.setProperty code didn't take care of it. And I don't know whether that's gmail specific. Gmail is the only ssl mail server available to me. I will take a look at g4j. Thanks for the help. -Original Message- From: RADEMAKERS Tanguy [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 30, 2005 1:18 PM To: CF-Talk Subject: RE: Using JavaMail to send/fetch emails via SSL Hello Hua, Have you tried using JavaMail to fetch email from a different (non gmail) ssl mail server? I.E. is the problem gmail specific? BTW: your debug output ("DEBUG POP3: connecting to host "pop.gmail.com", port 995, isSSL false") seems to indicate that you are *not* connecting over SSL... You might be interested in checking out the Gmail 4 Java api (available at http://g4j.sourceforge.net/) - at the very least i'm sure you will find some knowledgeable people on their lists/forums/etc. Regs, /t >-Original Message- >Subject: Using JavaMail to send/fetch emails via SSL >From: "Hua Wei" <[EMAIL PROTECTED]> >Date: Tue, 30 Aug 2005 10:05:45 -0400 >Thread: >http://www.houseoffusion.com/cf_lists/index.cfm/method=messages >&threadid=41987&forumid=4#216758 > >Hello All, >Anyone using JavaMail and coldfusion together to send/fetch emails via >SSL? > >I tried gmail, but got time out errors. Increased the time limit, but >didn't help. >non-ssl emails work fine. > >Any suggestions? Thanks in advance > >Hua > >JavaMail version: 1.3.2 >System: CFMX 7 enterprise on windows 2000 > > code > > > username = "[username]"; > password = "[password]"; > debug = true; > > POP_HOST_NAME = "pop.gmail.com"; > POP_PORT = "995"; //995 for gmail > SSL_FACTORY = "javax.net.ssl.SSLSocketFactory"; > > prop = createObject("Java", "java.util.Properties").init(); > prop.setProperty("javax.mail.pop3.starttls.enable", "true"); > prop.setProperty("javax.mail.pop3.socketFactory.class", SSL_FACTORY); > prop.setProperty("javax.mail.pop3.socketFactory.fallback", "false"); > prop.setProperty("javax.mail.pop3.port", POP_PORT); > prop.setProperty("javax.mail.pop3.socketFactory.port", POP_PORT); > > urlName = createObject("Java", "javax.mail.URLName"); > urlName.init("pop3",POP_HOST_NAME,POP_PORT,JavaCast("null", >""),username,password); > > mySession = createObject("java", >"javax.mail.Session").getInstance(prop); > mySession.setDebug(debug); > > store = mySession.getStore(urlName); > > // connect to mailbox > store.connect(); > inbox = store.getFolder("INBOX"); > inbox.open(inbox.READ_ONLY); > > messages = inbox.getMessages(); > store.close(); > >= >=== fetching debug output === >DEBUG: setDebug: JavaMail version 1.3.2 >DEBUG: getProvider() returning >javax.mail.Provider[STORE,pop3,com.sun.mail.pop3.POP3Store,Sun >Microsy stems, Inc] >DEBUG POP3: connecting to host "pop.gmail.com", port 995, isSSL false >S: EOF >08/30 09:43:11 Warning [jrpp-2] - Thread: jrpp-2, processing >template: D:\HTDOCS\webroot\test_gmailget.cfm, completed in 60 seconds, >exceeding the 60 second warning limit >C: QUIT >S: EOF >= ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216826 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Using JavaMail to send/fetch emails via SSL
Hello All, Anyone using JavaMail and coldfusion together to send/fetch emails via SSL? I tried gmail, but got time out errors. Increased the time limit, but didn't help. non-ssl emails work fine. Any suggestions? Thanks in advance Hua JavaMail version: 1.3.2 System: CFMX 7 enterprise on windows 2000 code username = "[username]"; password = "[password]"; debug = true; POP_HOST_NAME = "pop.gmail.com"; POP_PORT = "995"; //995 for gmail SSL_FACTORY = "javax.net.ssl.SSLSocketFactory"; prop = createObject("Java", "java.util.Properties").init(); prop.setProperty("javax.mail.pop3.starttls.enable", "true"); prop.setProperty("javax.mail.pop3.socketFactory.class", SSL_FACTORY); prop.setProperty("javax.mail.pop3.socketFactory.fallback", "false"); prop.setProperty("javax.mail.pop3.port", POP_PORT); prop.setProperty("javax.mail.pop3.socketFactory.port", POP_PORT); urlName = createObject("Java", "javax.mail.URLName"); urlName.init("pop3",POP_HOST_NAME,POP_PORT,JavaCast("null", ""),username,password); mySession = createObject("java", "javax.mail.Session").getInstance(prop); mySession.setDebug(debug); store = mySession.getStore(urlName); // connect to mailbox store.connect(); inbox = store.getFolder("INBOX"); inbox.open(inbox.READ_ONLY); messages = inbox.getMessages(); store.close(); = === fetching debug output === DEBUG: setDebug: JavaMail version 1.3.2 DEBUG: getProvider() returning javax.mail.Provider[STORE,pop3,com.sun.mail.pop3.POP3Store,Sun Microsy stems, Inc] DEBUG POP3: connecting to host "pop.gmail.com", port 995, isSSL false S: EOF 08/30 09:43:11 Warning [jrpp-2] - Thread: jrpp-2, processing template: D:\HTDOCS\webroot\test_gmailget.cfm, completed in 60 seconds, exceeding the 60 second warning limit C: QUIT S: EOF = ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216758 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: query error
You may want to check this techNote: http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_17282 "Operation must use an updateable query error when trying to update Access database This is generally a result of ColdFusion not having appropriate permissions at the Network Operating System level to write to the database." -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED] Sent: Friday, June 03, 2005 1:05 PM To: CF-Talk Subject: query error Can't quite figure out why this would generate an error AND what " Operation must use an updateable query " means: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. The error occurred in E:\Inetpub\wwwroot\test\admin\calendar_admin\addevent.cfm: line 51 49 : 50 : INSERT INTO EventsCalendar(EventName, EventDesc, CreatedBy) 51 :Values('#form.EventName#', '#form.eventdesc#', '#form.createdby#') 52 : Tim ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208544 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Concatenation
On MSSQL 2000, try this SELECT billToAddress1 + ' ' + isnull(billToAddress2,'') AS billToAddress FROM tbl_orderHeader_archive -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Friday, April 01, 2005 11:11 AM To: CF-Talk Subject: SOT: SQL Concatenation Sorry for this, but I've lost my mind this morning. Please is someone could tell me how to do this I would be forever grateful. SELECT billToAddress1 + ' ' + billToAddress2 AS billToAddress FROM tbl_orderHeader_archive If the billToAddress2 column is null or empty this select statement returns empty. Can someone please tell me how to have it return the billToAddress1 and billToAddress2 concatenated even if the billToAddress2 is empty or null? Thanks Bryan ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201189 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: sql ( ms sql ) alter command
On mssql 2000, alter table [tablename] alter column [columnname] varchar(2000) -Original Message- From: Protoculture [mailto:[EMAIL PROTECTED] Sent: Monday, March 14, 2005 10:51 AM To: CF-Talk Subject: sql ( ms sql ) alter command I wish to modify an existing table by increasing the varchar limit from 1000 to 2000. Is there a alter table command that can be used after the field has been created? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198662 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: sql select statement help..
As long as jobNumber is not a unique field, the query works. select count(*) as numofjobs, convert(char(10),logdatetime,101) as DTLOGGED, jobPriority, jobNumber from jobs where logdatetime >= '02/01/2005' and logdatetime <= '02/02/2005' group by convert(char(10),logdatetime,101), jobPriority, jobNumber === Here is a test: create table jobs ( jobid int identity, jobPriority int, jobNumber varchar(30), logdatetime datetime) insert into jobs(jobPriority,jobNumber,logdatetime) values(3,'01JS1003','02/01/2005') insert into jobs(jobPriority,jobNumber,logdatetime) values(3,'01JS1003','02/01/2005') insert into jobs(jobPriority,jobNumber,logdatetime) values(2,'01JS1004','02/01/2005') numofjobs DTLOGGED jobPriority jobNumber --- -- --- -- 1 02/01/2005 2 01JS1004 2 02/01/2005 3 01JS1003 (2 row(s) affected) -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Monday, March 14, 2005 11:43 AM To: CF-Talk Subject: RE: sql select statement help.. Which will of course return a job count of 1 for each row, since it is grouped by jobNumber. To get the result set you want, if your DB supports it, you will need a referential subquery something like this: select j.jobPriority, j.jobNumber, (select count(*) as numofjobs from jobs where jobs.logdatetime = j.logdatetime) from jobs j where j.logdatetime >= #startdate# and j.logdatetime <= #stopdate# This assumes that logdatetime is just a date, not a date and time - you might need to convert to a date part only in the subquery so the equality holds true. -Original Message- From: Hua Wei [mailto:[EMAIL PROTECTED] Sent: Tuesday, 15 March 2005 12:14 To: CF-Talk Subject: RE: sql select statement help.. Cfcoder, = select count(*) as numofjobs, jobPriority, jobNumber from jobs where logdatetime >= #startdate# and logdatetime <= #stopdate# group by logdatetime, jobPriority, jobNumber order by logdatetime,jobNumber -- if need orderby ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198661 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: sql select statement help..
Cfcoder, = select count(*) as numofjobs, jobPriority, jobNumber from jobs where logdatetime >= #startdate# and logdatetime <= #stopdate# group by logdatetime, jobPriority, jobNumber order by logdatetime,jobNumber -- if need orderby = -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: Monday, March 14, 2005 9:23 AM To: CF-Talk Subject: sql select statement help.. Hello everybody, I really need someone to help me here. I'm developing a graphical interface to report the no of jobs logged in a period. The x axis displays the period (days) and the y-axis displays the number of jobs logged in a given day. The data is pulled from the jobs table. The job logged date value is stored in the logdateTime column. I've written a stored procedure to get the count of jobs logged in a given day. Here is the code. EXEC countJobsLogged @startdatedate = '2005/02/01', @stopdate = '2005/02/28' CREATE proc countJobsLogged @startdate datetime, @stopdate datetime as set nocount on declare @x datetime, @count int create table #temp_report( dtlogged varchar(15), jobsCount int ) select @x = @startdate while @x <= @stopdate begin select @count = isnull(count(1),0) from jobs where logdatetime >= @x + '00:00:00' and logdatetime <= @x + '23:59:59' insert into #temp_report values(convert(varchar(15),@x,106), @count) select @x = dateadd(d, 1, @x) end select * from #temp_report drop table #temp_report set nocount off GO The above sp loops from the user selected start date to the user selected end date and returns a recordset showing the no of jobs logged. Ex JOBSCOUNT DTLOGGED 2 01 Feb 2005 3 02 Feb 2005 4 03 Feb 2005 So far so good. I want to modify the select stmt in that I want it to also return the jobPriority and the jobNumber (these are columns in the job table) for jobs that it found logged on a particular day. So for example if say for ex, there are 2 jobs logged on the 01 Feb 2005, I want the final recordset to look something like this JOBSCOUNT DTLOGGEDjobPriority jobNumber 2 01 Feb 2005 3 01JS1003 2 01 Feb 2005 2 01JS1004 3 02 Feb 2005 4 01JS1005 3 02 Feb 2005 4 01JS1006 3 02 Feb 2005 5 01JS1016 4 03 Feb 2005 1 01JS1018 4 03 Feb 2005 2 01JS1020 4 03 Feb 2005 3 01JS1021 4 03 Feb 2005 4 01JS1022 I was hoping someone could show me the sql to achieve this result Best regards cfcoder ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198657 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Coldfusion mx7 run as root on redhat linux AS3
Hello all, I installed coldfuson mx7 enterprise trial version on redhat linux AS3 machine, selected multiserver configuration, configured apache (Apache 2.0.46) as the web server, the installation went well. During the installation, I tried apache (also tried nobody) as the runtime user, but after the coldfusion server started, the cfusion process was run by root. I did a file upload test, the uploaded file was also owned by root. Did I miss something during the installation? is there to way to change the coldfusion process not run by root? Thanks for your help. Hua = [EMAIL PROTECTED] proc]# ps -ef|grep jrun apache 17314 1 0 Feb16 ?00:00:01 /opt/jrun4/verity/k2/_ilnx21/bin/k2admin apache 17431 17314 0 Feb16 ?00:00:01 /opt/jrun4/verity/k2/_ilnx21/bin/k2server -ualias ColdFusionK2_server1 apache 17432 17314 0 Feb16 ?00:00:01 /opt/jrun4/verity/k2/_ilnx21/bin/k2index -ualias ColdFusionK2_indexserver1 root 24222 1 1 Feb16 ?00:09:21 /opt/jrun4/bin/jrun -start cfusion root 25371 25278 0 09:49 pts/100:00:00 grep jrun = ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195169 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: sql question (Quick and easy)
Tony, How about use millisecond in the datepart dateDiff(ms,'01/01/1970 00:00:00.000',DATEADD(Day, 22, '01/01/1970')) however, for milliseconds, the maximum number datediff can produce is 24 days, 20 hours, 31 minutes Hua -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Thursday, August 05, 2004 2:08 PM To: CF-Talk Subject: sql question (Quick and easy) hi there... this query below returns an epoch time, something like 1083851729 select dateDiff(ss,'01/01/1970 00:00:00.000',DATEADD(Day, -91, GetDate())) which is GREAT, and translates into: 05/06/2004 14:55:29 but i need to get: 05/06/2004 00:00:00.000 i can do it all day long in cfml, but i need to do it in sql code. any ideas? thanks. here is my first attempt...but obviously...it gave me an error: select dateDiff(ss,'01/01/1970 00:00:00.000',DATEADD(Day, -91, day(getDate( any help, as always is MUCH Appreciated. -- tony Tony Weeg human. email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ Check out http://www.antiwrap.com to send websites to your friends. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Coldfusion & UNICODE Characters
Does the data in the database saved in its proper charset?(COLLATE) -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 04, 2004 9:34 AM To: CF-Talk Subject: RE: Coldfusion & UNICODE Characters Just tried the following in the page template and the text returned from the database is still like years From: Hua Wei [mailto:[EMAIL PROTECTED] Sent: 04 August 2004 14:31 To: CF-Talk Subject: RE: Coldfusion & UNICODE Characters Ian, try on top of your templates Hua -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 04, 2004 9:26 AM To: CF-Talk Subject: RE: Coldfusion & UNICODE Characters I was only using 'iso-8859-1' as an example (sorry to confuse you!) I used utf-8 in my templates even though that its standard to MX ??? http-equiv="Content-Type" content="text/html; charset=utf-8"> but it some characters are still displaying the square character etc.. From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: 04 August 2004 14:15 To: CF-Talk Subject: Re: Coldfusion & UNICODE Characters Ian Vaughan wrote: > Ive tried the following at the top of the template, but it still displays the square character on certain characters such as ' " - > > > ISO-8859-1? You are in the UK but you are trying to use a charset that doesn't even have the euro symbol? Bite the bullet and convert everything to unicode. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Coldfusion & UNICODE Characters
Ian, try on top of your templates Hua -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 04, 2004 9:26 AM To: CF-Talk Subject: RE: Coldfusion & UNICODE Characters I was only using 'iso-8859-1' as an example (sorry to confuse you!) I used utf-8 in my templates even though that its standard to MX ??? http-equiv="Content-Type" content="text/html; charset=utf-8"> but it some characters are still displaying the square character etc.. From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: 04 August 2004 14:15 To: CF-Talk Subject: Re: Coldfusion & UNICODE Characters Ian Vaughan wrote: > Ive tried the following at the top of the template, but it still displays the square character on certain characters such as ' " - > > > ISO-8859-1? You are in the UK but you are trying to use a charset that doesn't even have the euro symbol? Bite the bullet and convert everything to unicode. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: SQL Find
In MS SQL, you can use CHARINDEX,PATINDEX and STUFF : CHARINDEX: Returns the starting position of the specified _expression_ in a character string PATINDEX: Returns the starting position of the first occurrence of a pattern in a specified _expression_, or zeros if the pattern is not found, on all valid text and character data types. STUFF: Deletes a specified length of characters and inserts another set of characters at a specified starting point. -Original Message- From: Lee [mailto:[EMAIL PROTECTED] Sent: Monday, August 02, 2004 4:37 PM To: CF-Talk Subject: SQL Find Does SQL Server have an function similar to CF's "Find" string function. I need to parse 150,000 names depending on where the comma is in the string and update each record. Not a great task for CF. I'm aware of the substring command but it needs to know what position the comma is in. Lee Surma [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: allow access to database
In ms sql 2000, the fixed database role db_datareader only does the read access. -Original Message- From: Phill B [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 11:18 AM To: CF-Talk Subject: OT: allow access to database I have a developer that needs access to a database. They suggested I give them a backup of it that they can work with. My first thought was OK but then I started thinking about it. I don't like the thought of some one having a complete copy of my database. Here's my question. Wouldn't it be better to just create a user account that has read only access to the tables that they will be working with? The app they are writing only needs read access and I can kill the account when they are done. To me, it seems more secure doing it this way. Thoughts? Phillip B. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Looping a returned query to insert into another table
Mark, Since tableA and tableB use the same REQUEST.dsn1, you can try this: Insert into INTO tableB (fieldnameA, fieldnameB, fieldnameC) SELECT T.field1, T.field2, T.field3 FROM tableA T WHERE T.userID = value="#FORM.userID#"> Hua -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Friday, May 28, 2004 12:15 PM To: CF-Talk Subject: Looping a returned query to insert into another table Hi all, I've never done this before, but how do you loop a query of, say 6 records, and rewrite the output into another table? 1) Retrieve the records: SELECT T.field1, T.field2, T.field3 FROM tableA T WHERE T.userID = value="#FORM.userID#"> 3) Here's the table to insert the records to: INSERT INTO tableB (fieldnameA, fieldnameB, fieldnameC) VALUES (#getRecords.field1#, #getRecords.field2#, #getRecords.field3#) Thanks, Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL question. Someone help!!!
Select * From billing a Where ( (select count(*) from billing b where a.first_name = b.first_name AND a.last_name = b.last_name ) >1) -Original Message- From: Jeff Waris [mailto:[EMAIL PROTECTED] Sent: Friday, April 16, 2004 3:35 PM To: CF-Talk Subject: OT: SQL question. Someone help!!! I am having a hard time finding the right syntax in SQL. Backend Database is SQL Server 7 What I am trying to acomplish. I have some duplicate records that I need to get rid of, the problem is that all these records already have a unique key, but the rest of the fields are the same. I was hoping to be able to join two fieldnames together and look for the duplicates that way.. For example... this is where I was headed... Select from billing.first_name+ billing.last_name AS combined HAVING COUNT( * ) > 1 It wouldn't work Any help would greatly be appreciated. Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFHTTP GET CSV File problem ?
Dave, The CFHTTP URL seems missing "=" after "Symbols". and you may want to make sure the values are in one line. Also make sure the values of COLUMNS are in one line. Hua URL=""> DC+AGNI&format=sl1d1t1c1ohgv&ext=.csv" NAME="GetQuotes" COLUMNS="Symbol,Last_Traded_Price,Last_Traded_Date,Last_Traded_Time,Chan ge,Opening_Price,Days_High,Days_Low,Volume" DELIMITER="," TEXTQUALIFIER="" charset="iso-8859-1" TIMEOUT="400" > === -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 12:28 PM To: CF-Talk Subject: CFHTTP GET CSV File problem ? Everytime I call the following cfhttp snippet it always errors out telling me 'Incorrect number of columns in row." Please check the number of columns specified in the columns attribute and in the target file. I have 9 columns in the columns attribute and the target file contains 9 columns as well. I can paste the link specifed in the cfhttp tag in a browser and it returns a csv file with exactly 9 columns. Is there any bugs in cfhttp? URL=""> C+AG NI&format=sl1d1t1c1ohgv&ext=.csv" NAME="GetQuotes" COLUMNS="Symbol,Last_Traded_Price,Last_Traded_Date,Last_Traded_Time,Chan ge,O pening_Price,Days_High,Days_Low,Volume" DELIMITER="," TEXTQUALIFIER="" charset="iso-8859-1" TIMEOUT="400" proxyserver="xxx.xxx.xxx.xxx" proxyport=""> Regards, Dave Bosky HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfx_getImage error! Don't know what's causing it
>Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.CallComments_attachment'. Table CallComments_attachment doesn't exist in the database? Or it isn't owned by "dbo"? -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 11:52 AM To: CF-Talk Subject: Re: cfx_getImage error! Don't know what's causing it I changed the code a select statement a bit. I appended 'dbo.' before the table name. DATASOURCE="db" USER="dbUserName" PASSWORD="dbPassword" SQL="select filename FROM dbo.Attachment WHERE id = '#url.id#'" OUTPUT="E:\inetpub\wwwroot\tempDocumentsFolder\#getAttachmentDetails.Fil eName#"> This was the error I was getting before I made the above change: SQL:select filename FROM Attachment WHERE id = '01057870' SQLExecDirect Failed szSqlState = S0002 pfNativeError = 208 szErrorMsg = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Attachment'. pcbErrorMsg = 93 And this is what I get now: SQL:select filename FROM Attachment WHERE id = '01057870' SQLExecDirect Failed szSqlState = S0002 pfNativeError = 208 szErrorMsg = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.CallComments_attachment'. pcbErrorMsg = 97 Notice the difference in the pcbErrorMsg value. Does that tell you anything? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfx_getImage error! Don't know what's causing it
>[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Attachment'. This error says the table "Attachment" doesn't exist in the database. Does it exist in your DATASOURCE="db"? -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 9:33 AM To: CF-Talk Subject: cfx_getImage error! Don't know what's causing it Hello Everybody, I'm really hoping that someone will help me. A lot of people have used the cfx_getImage tag to open up office documents (word,excel, blah). I thought I'll use it to do the same. The documents are stored on the database table as binary objects. I registered the cfx tag in the administrator. I'm calling it on the page like this: select * from Attachment where id = '#url.id#' DATASOURCE="db" USER="dbUserName" PASSWORD="dbPassword" SQL="select filename FROM Attachment WHERE id = '#url.id#'" OUTPUT="E:\inetpub\wwwroot\tempDocumentsFolder\#getAttachmentDetails.Fil eName#"> I get this error message: The error occurred in E:\inetpub\wwwroot\viewattachment.cfm: line 8 6 : 7 : DATASOURCE="db" 8 : USER="dbUserName" 9 : PASSWORD="dbPassword" 10 : SQL="select filename FROM Attachment WHERE id = '#url.id#'" (USER="dbUserName" is in bold) SQL:select filename FROM Attachment WHERE id = '01057870' SQLExecDirect Failed szSqlState = S0002 pfNativeError = 208 szErrorMsg = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Attachment'. pcbErrorMsg = 93 Does anybody know why I'm getting this error? I would really appreciate your help Regards, cfcoder __ Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway http://promotions.yahoo.com/design_giveaway/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Web Services and CFMX6.1 -- Why doesn't it work?
I tested on my server, it worked. So the code is fine. You may want to check your server config. Hua -Original Message- From: Sung Woo [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 9:31 AM To: CF-Talk Subject: Web Services and CFMX6.1 -- Why doesn't it work? I'm at my wit's end here, folks. I don't know why my idiotic "hello world" web service just isn't working. Here's a path to my madness: helloworld.cfc returntype="string" output="false"> working."> --- hello_component.cfm (to check if the CFC is working) method="getMessage" returnvariable="aString"> #aString# Output: Hello Bozo, web service is working. --- helloworld.cfc?wsdl Output: works fine, displays the XML --- hello.cfm method="getMessage" returnvariable="aString"> #aString# Output: Could not generate stub objects for web service invocation. Name: http://localhost/ws/helloworld.cfc?wsdl. WSDL: http://localhost/ws/helloworld.cfc?wsdl. org.xml.sax.SAXException: Fatal Error: URI=null Line=1: Missing whitespace before SYSTEM literal URI. -- What the hell am I doing wrong? Any ideas? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX JRun Services on Windows 2000
Adam, You can try this command to add a CF server service on Windows: {Jrun_home}\bin>jrunsvc -install cfusion2 "Macromedia JRun CFusion2 Server" "Macromedia JRun CFusion2 Server" Hua -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 10:19 AM To: CF-Talk Subject: CFMX JRun Services on Windows 2000 CFMX for J2EE, Windows 2000. I've got a number of CF instance running on the server. However only 3 services are running connected to JRun. Admin, Default, and CFusion. (The 3 default instances jrun creates when you install CF) When the server is rebooted, only the 3 default services are restarted. All other instances are not. Looking into the services that are there, shows the same executable (jrunsvc.exe), yet there are no startup parameters to differentiate them. I'm curious as to what the difference is between the three since they all run the same executable. A solution, which seems a bit sloppy, is to create a scheduled task that runs on system startup, which makes the appropriate command line execution. (jrun.exe -start myCFInstance) Is there anyway to add these instance as services like the default cfusion one that is created during the initial install of the server? -adam [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]