RE: large cf ecom sites?
Autobytel.com is pretty stinkin big. They're CF. -Original Message- From: Emmet McGovern [mailto:[EMAIL PROTECTED] Sent: Friday, December 17, 2004 12:00 PM To: CF-Talk Subject: large cf ecom sites? I have a client that is starting to backpedal on wanting to use coldfusion for their ecommerce site. Some idiot in their marketing department is a fierce opponent of cf. Luckily he's not the deal breaker for cf but he does have some influence. Does anyone know of some other well known cf commerce sites such as potterybarn.com? Emmet ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188942 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: Joins
Just do a SELECT DISTINCT... -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: Monday, December 06, 2004 4:16 PM To: CF-Talk Subject: Re: Joins Hi, I'm getting an error with both your reply and Michaels so I don't know if it's something I explained incorrectly. I'm getting this error: http://www.020.com/webs/020/content.cfm?writers [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'articleAuthenticated'. I do however have that column name. It is in the tbl_020articleDetails table. !-- Get author information -- cfquery name=GetAuthors datasource=user020 SELECT tbl_020authorDetails.authorID, tbl_020articleDetails.authorID, authorFirstName, authorSurname, articleAuthenticated FROM tbl_020authorDetails, tbl_020articleDetails WHERE tbl_020authorDetails.authorID = tbl_020articleDetails.authorID and tbl_020articleDetails.articleAuthenticated = 1 /cfquery Thanks, Saturday On 6/12/04 11:04 pm, Adrocknaphobia [EMAIL PROTECTED] wrote: Well there are a million ways to SQL a cat. Here is one: SELECT Q.authorID, A.authorFirstName, A.authorSurname, A.articleAuthenticated FROM ( SELECT authorID FROM tbl_020articleDetails WHERE articleAuthenticated = 1 GROUP BY authorID ) Q INNER JOIN tbl_020authorDetails A ON Q.authorID = A.authorID Should do the trick. -Adam On Mon, 6 Dec 2004 22:45:37 -, Stuart Kidd [EMAIL PROTECTED] wrote: Hi guys, I've got a query whereby I am getting a list of all authors (table: tbl_020authorDetails) in my database. I am cross referencing against all the articles (tbl_020articleDetails) and only displaying the authors who have an article published (articleAuthenticated = 1). The problem I am coming across is that when an author has two articles published it is displaying their name twice in my list and of course I only want it outputted the once. Can anyone see where I'm going wrong? !-- Get author information -- cfquery name=GetAuthors datasource=user020 SELECT tbl_020authorDetails.authorID, tbl_020articleDetails.authorID, authorFirstName, authorSurname, articleAuthenticated FROM tbl_020authorDetails, tbl_020articleDetails WHERE tbl_020authorDetails.authorID = tbl_020articleDetails.authorID and tbl_020articleDetails.articleAuthenticated = 1 /cfquery Thanks very much for your help. Saturday ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186401 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: My First Shopping Cart
For high traffic and easily modifiable code, nothing compares to Netready. Check it out: http://www.cfnetready.com http://www.cfnetready.com +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Donna French [mailto:[EMAIL PROTECTED] Sent: Thursday, August 19, 2004 8:46 AM To: CF-Talk Subject: My First Shopping Cart Okay guys/gals, I am going to start doing the planning for my first custom shopping cart and would like any pointers you all can give me? The best I can tell so far, my best bet is to use session variables because it is a high traffic site - please correct me if I'm wrong. And I plan to have things like a wish list, view past orders, multiple shipping addresses for return customers - just to name a few. At any rate, ANY advice that you can give would be greatly appreciated. Thank you, Donna French _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Inserting a query string into a text field
PreserveSingleQuotes causes CF to NOT escape the single quotes in your text string.Since the your text string has single quotes in it that need to be inserted into the DB, then you need to let CF escape them or the query will err out. INSERT INTO tbl_CampaignMgrActionData (ActionString) VALUES ('!---Query String begins ---FROM tpines.mail_recipient T1 WHERE mail_user_id = 'Mitch' AND ( EXISTS (SELECT message_to_recipient_id FROM tpines.message_to_recipient WITH (index(mr_message_id)) WHERE mr_message_id = 10193 AND tpines.message_to_recipient.mr_recipient_id = T1.recipient_id) ) AND ( EXISTS (SELECT message_to_recipient_id FROM tpines.message_to_recipient WHERE mr_message_id = 10452 AND mr_user_id = 'Mitch' AND mr_result = 4 AND tpines.message_to_recipient.mr_recipient_id = T1.recipient_id) And EXISTS (SELECT message_to_recipient_id FROM tpines.message_to_recipient WHERE mr_message_id = 10132 AND mr_user_id = 'Mitch' AND mr_result = 4 AND tpines.message_to_recipient.mr_recipient_id = T1.recipient_id) )!---Query String ends ---') WHERE tbl_CampaignMgrActionData.ActionID = 68 f +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 17, 2004 12:38 PM To: CF-Talk Subject: Inserting a query string into a text field Here's kind of a weird one folks. I'm trying to insert a sql query string into a text field. The DB will be queried on a scheduler and the string inserted into a query. I've tried PreserveSingleQuotes but CF still tries to run the query string instead of inserting it. HALP!!! sas Real Magnet Scott Stewart Web Application Developer [EMAIL PROTECTED] 5039 Connecticut Ave. NW Washington DC 20009 tel: 202-244-7845 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Inserting a query string into a text field
PreserveSingleQuotes causes CF to NOT escape the single quotes in your text string.Since the your text string has single quotes in it that need to be inserted into the DB, then you need to let CF escape them or the query will err out.In other words, don't use PreserveSingleQuotes - let CF automatically escape all the single quotes in your string. INSERT INTO tbl_CampaignMgrActionData (ActionString) VALUES ('!---Query String begins ---FROM tpines.mail_recipient T1 WHERE mail_user_id = 'Mitch' AND ( EXISTS (SELECT message_to_recipient_id FROM tpines.message_to_recipient WITH (index(mr_message_id)) WHERE mr_message_id = 10193 AND tpines.message_to_recipient.mr_recipient_id = T1.recipient_id) ) AND ( EXISTS (SELECT message_to_recipient_id FROM tpines.message_to_recipient WHERE mr_message_id = 10452 AND mr_user_id = 'Mitch' AND mr_result = 4 AND tpines.message_to_recipient.mr_recipient_id = T1.recipient_id) And EXISTS (SELECT message_to_recipient_id FROM tpines.message_to_recipient WHERE mr_message_id = 10132 AND mr_user_id = 'Mitch' AND mr_result = 4 AND tpines.message_to_recipient.mr_recipient_id = T1.recipient_id) )!---Query String ends ---') WHERE tbl_CampaignMgrActionData.ActionID = 68 The DB thinks that the single quote in front of Mitch marks the end of the string, that's why you need to let CF escape it before sending it to the DB. +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 17, 2004 12:38 PM To: CF-Talk Subject: Inserting a query string into a text field Here's kind of a weird one folks. I'm trying to insert a sql query string into a text field. The DB will be queried on a scheduler and the string inserted into a query. I've tried PreserveSingleQuotes but CF still tries to run the query string instead of inserting it. HALP!!! sas Real Magnet Scott Stewart Web Application Developer [EMAIL PROTECTED] 5039 Connecticut Ave. NW Washington DC 20009 tel: 202-244-7845 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: ecommerce storefronts
Check out the new website for Netready: http://cfnetready.com/ http://cfnetready.com/ And as part of our kickoff for this website, we'll sell our software for $200 to anyone who mentions this message through the end of August! +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: daniel kessler [mailto:[EMAIL PROTECTED] Sent: Thursday, July 29, 2004 12:49 PM To: CF-Talk Subject: ecommerce storefronts It seems like that when people speak of ecommerce and CF together, they're talking about storefronts.Do I use these systems (some listed below) to go directly to VISA/MC or do I always have to go through an online merchant bank, which I find for myself? Here are the ones that I've seen listed on my houseOfFusion search: NetReady: http://www.aloha-webdesign.com/index.asp?fuseaction=detailspid=19 CFWebStore: http://cfwebstore.com/-- looks nice SiteDirector: http://www.quilldesign.com/site/index.cfm And here's some payment services that we've considered instead of storefronts: http://www.clickandpledge.com/ https://www.verisign.com/products-services/payment-processing/online-payment /payflow-pro/index.html www.paypal.com https://www.paypal.com/PROMO/GOOGLE/MR69 http://www.prestocart.com/cgi-bin/prestocart_donations.pl?ref=google3fr=pch Most any comments are welcome. thanks. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: SQL help!
That would work, but if you have more than a thousand or so items in the sub-select, you're query will not return the expected results.Some databases limit the list length for the IN clause to 1,000 items. Better to do it this way SELECT t1.id FROM table1 t1 LEFT OUTER JOIN table2 t2 ON t1.id = t2.id WHERE t2.id IS NULL (Oracle) SELECT t1.id FROM table1 t1, table2 t2 WHERE t1.id = t2.id(+) AND t2.id IS NULL +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Phillip Beazley [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 10, 2004 12:23 PM To: CF-Talk Subject: Re: SQL help! At 03:18 PM 8/10/2004, you wrote: This is probably basic, but my brain is not functioning at this point today... I need to compare two tables. They both contain customer numbers. One table mimics the other so the same data *should* be in each. It has come to my attention that there are orphans in one of the tables. What I'd like to do is compare one table against the other, find the orphans in that table and list them out. Then vice versa with the other table. I was attempting to do a Inner join but it didn't seem to work. Anyone with ideas? You could do something like... SELECT * FROM table1 WHERE id NOT IN (SELECT id FROM table2) SELECT * FROM table2 WHERE id NOT IN (SELECT id FROM table1) Not super-fab, but it'll show you what's in one that isn't in the other... -- Phillip Beazley Onvix -- Website Hosting, Development E-commerce Visit http://www.onvix.com/ or call 727-578-9600. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: getting rid of Evaluate in CF 5.0
reconsider the way you create those variables.How are RM1DAY and the other variables getting created?A struct or an array would probably work very nicely to store those variable values differently and speed up your code. Also, it's generally a very bad idea to put a query inside a loop.Of all the times I've seen someone do that, over 90% of them could have been avoided by structuring the logic differently. +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Jim Louis [mailto:[EMAIL PROTECTED] Sent: Thursday, August 12, 2004 9:47 AM To: CF-Talk Subject: getting rid of Evaluate in CF 5.0 I have a complex page that I use this system right now.This isa sample of the text. CFIF Query.DATE EQ #Query2.DATE1# CFSET A1=1 CFLOOP INDEX=Date1 FROM=#Starting# TO=#Ending# !--- No Roommates --- cfif (EVALUATE(RM1DAY A1) is '0') and (EVALUATE(RM2DAY A1) is '0') and (EVALUATE(RM3DAY A1) is '0') CFQUERY DATASOURCE=#db# NAME=Update UPDATE table SET Day#a1# = 1 WHERE ID = #query3.New_ID# /CFQUERY CFSET NEW_TOTAL = EVALUATE(query1.DAY A1) + 1 CFQUERY DATASOURCE=#db# NAME=UpdateHotel UPDATE table2 SET day#a1# = #new_total# WHERE ID = #query.H_ID# /CFQUERY /cfif More code CFSET A1=A1+1 /cfloop Is there any what to get rid of all of these evaluate tags. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Is this possible in SQL
Join the tables together so they are treated like a single table...(assuming they are join-able) SELECT c.categoryid, sc.sub_CategoryId FROM categories c, sub_category sc WHERE c.categoryID = sc.categoryID AND (c.category = '#form.searchVal#' OR sc.sub_Category = '#form.searchVal#') LIMIT 1 +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Andy J [mailto:[EMAIL PROTECTED] Sent: Monday, August 09, 2004 4:22 PM To: CF-Talk Subject: Is this possible in SQL I have two tables which I want to query at the same time. I'm thinking something along the lines of SELECT c.categoryid, sc.sub_CategoryId FROM categories c, sub_category sc WHERE c.category = '#form.searchVal#' OR sc.sub_Category = '#form.searchVal#' LIMIT 1 But where this is a left join it will always return a result for either column whether it makes a match or not. I could do something like the code below, but it seems to cumbersum for the job. cfquery name=qryName SELECT c.categoryid AS catId FROM categories c WHERE c.category = '#form.searchVal#' /cfquery cif NOT qry.recordCount cfquery name=qryName SELECT sc.sub_CategoryId AS catId FROM sub_category sc WHERE sc.sub_Category = '#form.searchVal#' /cfquery /cfif cfset variables.catId =qryName.catId Cheers Andy --- Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.735 / Virus Database: 489 - Release Date: 06/08/2004 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: advanced search
What kind of database are you using?If you are using Oracle, you might look into CONTEXT indexes.I'm not sure offhand if they'll do what you want them to, but they are useful for indexing long text fields. Other than that your only choice is to use multiple comparisons. SELECT * FROM QBOS_HELPFILE WHERE keywordsLIKE '%#word1#%' OR keywordsLIKE '%#word2#%'... etc... +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Frank Dewey [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 16, 2004 1:59 PM To: CF-Talk Subject: advanced search Hello all, I'm looking into searching a website for a particular string or occurence of a string.I would like for this to be an advanced search (what I am looking for is something more complex than a simple LIKE). In the database - QBOS_HELPFILE (id, name,keywords) - I am storing a list of words separated only by spaces.And I am starting out with this query: SELECT * FROM QBOS_HELPFILE WHERE keywordsLIKE '%#form.words#%' I've tried separating the words by commas and using the IN operator, but that only works if the field (keywords) contains one word Maybe a combination of the In operator and LIKE depending on the search text - if the search text has quotes or not.Of course the text should be first parsed.I'm not sure what the best way to go about this is. Are their some good examples out there?I've looked at Verity a little...but I'm not sure that is what I need. Are there any suggestions/help on this matter that ya'll can help me with?Thank you - Frank --- The Preceeding Email Has Been Scanned and Verified By QBOS Security Systems --- QBOS, Inc. 14275 Midway Rd.Suite 220 Addison, TX 75001 972.233.5066 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: ECommerce practices
If you are going to store it in the Session scope, then don't bother converting to WDDX.You only need to convert to WDDX when you need to store a complex variable (struct or array) as a string.If you want to store the FORM struct in the SESSION struct, just do this: cfset session.myform = form Now session.myform points to the same struct as form and you won't lose it. +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Ryan Kime [mailto:[EMAIL PROTECTED] Sent: Thursday, March 25, 2004 6:52 AM To: CF-Talk Subject: RE: ECommerce practices To answer some of your questions My favorite way to pass variables from page to page is to create a struct of the form variables and then throw it in a wddx using the session scope. You could write a struct for each section and keep rolling it into wddx's. Then in the end roll them out and append the different structs into one which makes it easy to pass the variables as an argumentcollection in a CFC. -Original Message- From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 24, 2004 7:10 PM To: CF-Talk Subject: ECommerce practices Just looking for other's insight. Can't think of a better group to ask... I'm setting up a custom ecomm area (current is a setup using the JASC component my boss implemented before I got here). What the big boss would like is something that wouldn't fit into the general templates you find all over, so I'm working from scratch on most of this. I'm trying to find what would be the best method for initially handling order details. Most of the items are apparel. The user would first select a category, then select a specific item/design from a thumbnail. Next they would be shown a larger image with the different colors it would be offered in. The user would select the color they want, taking them to the next screen where different size options would be available. The user would enter in the quantity of each size they may want. The next step would verify the item/design, basic product detail, color, sizes and quantities, and the price (showing price differences for oversized products as well). At this point it would then continue to the basics (name, addy, payment, etc.) My question is this. Every step of this process is some type of form. I could use hidden form fields to carry over all of the information from screen to screen, but this seems a little tedious, inelegant, and possibly somewhat insecure. What is suggested process in this type of situation? Should I set up some kind of struct var to handle the details? Would this best be handled within the session or client scopes? How does one best prevent race conditions? The end run is to write the details to a db once the order is processed, but I've seen what can happen when writing the details to a db from the get go and then having the user cancel the order or the payment is not approved (not my design, and it was ugly...) So, any suggestions are welcome and appreciated. TIA Cutter _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Loosing sessions on the same server with SSL
Cookies.Cookies keep track of the CFID and CFTOKEN which is how the server knows which session vars belong to who.Try adding CFID and CFTOKEN to the URL when the transition is made from non-ssl to ssl. If that's not it then I've got some other ideas, but try that first. +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: stas [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 17, 2004 6:29 AM To: CF-Talk Subject: Loosing sessions on the same server with SSL I've got an e-commerce app (a very old version of CF Webstore). My ISP has provided me with an SSL url to use for the final stages of the purchasing process. So during browsing, production selection the user is on: http://mystore.com/ The SSL protected pages go through: https://commerce.myisp.com/mystore/ It's a shared SSL account. What I am noticing is that the session variable that holds the basket gets erased after the users hits the SSLd pages. I'd appreciate some insight... Thanks! _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Pre-Written E-commerce Packages in ColdFusion
Yes, it's written in ColdFusion. +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Butch Zaccheo [mailto:[EMAIL PROTECTED] Sent: Friday, February 20, 2004 4:56 PM To: CF-Talk Subject: Re: Pre-Written E-commerce Packages in ColdFusion Hi Bryan... Is there a version of NetReady written in coldfusion? BZaccheo On 2/20/04 4:42 PM, Bryan Love [EMAIL PROTECTED] wrote: Try Netready,it's full of features, insanely fast and scalable, and super easy to modify.It also works with MySQL, MS SQL Server, Oracle, and Access.It's a steal for the price! http://aloha-webdesign.com/index.asp?fuseaction=details http://aloha-webdesign.com/index.asp?fuseaction=details http://aloha-webdesign.com/index.asp?fuseaction=detailspid=19 pid=19 +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Butch Zaccheo [mailto:[EMAIL PROTECTED] Sent: Thursday, February 19, 2004 9:47 AM To: CF-Talk Subject: Pre-Written E-commerce Packages in ColdFusion Does anyone have any recommendations for Pre-Written E-commerce packages using Cold Fusion? BZaccheo _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Pre-Written E-commerce Packages in ColdFusion
Try Netready,it's full of features, insanely fast and scalable, and super easy to modify.It also works with MySQL, MS SQL Server, Oracle, and Access.It's a steal for the price! http://aloha-webdesign.com/index.asp?fuseaction=details http://aloha-webdesign.com/index.asp?fuseaction=detailspid=19 pid=19 +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Butch Zaccheo [mailto:[EMAIL PROTECTED] Sent: Thursday, February 19, 2004 9:47 AM To: CF-Talk Subject: Pre-Written E-commerce Packages in ColdFusion Does anyone have any recommendations for Pre-Written E-commerce packages using Cold Fusion? BZaccheo _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Merchant Account Suggestions
I'd recommend Authorize.net.I've integrated Authorize.net, SkipJack, and Verisign.Verisign is good, but their CF tag doesn't work, so I had to use COM to integrate it into my shopping cart.SkipJack is also good, but more restrictive than AuthNet.Authorize.net allows the ability to pay by ECHECK if you so choose, and integration is fairly simple (unless you have a Wells Fargo SecureSource account - then it gets slightly more complex).I think if I was a store owner I'd tend toward whichever is the cheapest between these three options, but as a developer I'd tend toward SkipJack or AuthNet. -Original Message- From: Ricky Fritzsching [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 7:30 AM To: CF-Talk Subject: Merchant Account Suggestions I have a small business that I am doing an e-commerce application for and they are wanting to setup a merchant/gateway account for the website. I have not had any experience with setting up a this type of an account and I am wondering what are my options. Is there something that is not rather expensive that you have used?I am prepared for the monthly payments and %'s taken out, but there are just so many damn options. All suggestions are welcome.Thank you! --- Ricky Fritzsching _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Constrain on a clob
I don't know for sure if you can search *LOBs, but I know you can search TEXT fields... have you thought about whether or not you can use a TEXT field instead?You might already know about this, but in case you don't: They are called ConText indexes... and the creation of them looks something like this: CREATE INDEX myindex ON [tblname]([txt column name]) INDEXTYPE IS CTXSYS.CONTEXT; Anyway, these indexes require constant maintenance to keep them up to date. There are other similar indexes used for different styles of searching.A web search should turn up some information if you are interested. -Original Message- From: Sean McCarthy [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 15, 2003 5:50 AM To: CF-Talk Subject: RE: Constrain on a clob Sorry should have been more clear.It is a clob.From what I have read there is no way I can search against the data?Any ideas?Looks like I could use interMedia? thanks sean -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 15, 2003 4:34 AM To: CF-Talk Subject: RE: Constrain on a blob Shouldn't you be storing the data in a CLOB or TEXT field if it's text? afaik BLOB = binary large object, not reallly where you want to be storing text. -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: 15 October 2003 01:26 To: CF-Talk Subject: Re: Constrain on a blob Ya you need to convert it via a functionand for the life of me I can't remember what it's called (just found it a month ago)...try Google...Oracle 9 SELECT BLOBshould point ya in the right direction ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Sean McCarthy To: CF-Talk Sent: Tuesday, October 14, 2003 4:37 PM Subject: RE: Constrain on a blob its an oracle 9 db and im working in toad (fancy sql plus) rite now seems like i need to perform some sort of convert method on the data first? -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 14, 2003 7:37 PM To: CF-Talk Subject: Re: Constrain on a blob What DB and what version of CF? CF 5 and earlier cannot select a BLOBbut you can get some Java based custom tags to do it Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Sean McCarthy To: CF-Talk Sent: Tuesday, October 14, 2003 4:07 PM Subject: Constrain on a blob I get and 'inconsistent datatype' error when I try to: SELECT title FROM myTable WHERE myBlob = 'abc' Is it possible to constrain on the information in a blob. Optimally I would like the ability to do a 'like %foo%' _ _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL : Finding element in list of values in a query field.
First of all the DB design is incorrect for what you are trying to do... That being said, I've had to deal with this before and here is the best possible solution without changing the DB... 1) modify the GUI you use for data entry so that the talents list is inserted into the database with a comma at the beginning and at the end. So a list of talents looks like this in the DB: ,running,dancing,cooking, 2) run a query that will modify the data that is already in the DB by adding a comma before and after the talents string: UPDATE [table] SET talents = ',' + talents + ',' WHERE talents IS NOT NULL AND talents '' 3) now you can run queries like this: SELECT * FROM [table] WHERE talents LIKE '%,#aTalent#,%' +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 10:34 AM To: CF-Talk Subject: SQL : Finding element in list of values in a query field. Hey all, Say for example I have a table: Firstname Lastname Address Talents. Talents for one record is: acting,dancing,singing. For another record it is : dancing,singing,music I want to construct a query to find all those with dancing as a talent. How would I do that using SQL...*can* I do that using SQL? -Angel ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: XML shopping cart?
You could cheat and use WDDX - it converts structures to XML and back again... +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Monday, August 25, 2003 9:30 AM To: CF-Talk Subject: XML shopping cart? I have just started to get my feet wet with XML and CF. I thought I would play with the idea of converting my current shopping basket code so it would store all of the items in an XML structure that is stored in a session variable. I have figured out how to create the XML structure and search the structure for the items with XmlSearch(). My question is how do I delete XML nodes from the structure? Like when someone wants to remove an item from their shopping basket. Also how do you append new nodes to the XML structure? I am assuming you use XmlElemNew() but I have not tried it yet. Also how do you edit the XML structure? Like when a person updates the quantity of a product. Thanks, Chad ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: DateDiff question
Here's an excerpt direct from ColdFusion Studio's help pages ;) When datepart is Weekday (w), DateDiff returns the number of weeks between the two dates. If date1 falls on a Monday, DateDiff counts the number of Mondays until date2. It counts date2 but not date1. If interval is Week (ww), however, the DateDiff function returns the number of calendar weeks between the two dates. It counts the number of Sundays between date1 and date2. DateDiff counts date2 if it falls on a Sunday; but it doesn't count date1, even if it does fall on a Sunday. +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Lofback, Chris [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 19, 2003 1:14 PM To: CF-Talk Subject: DateDiff question Platform: CF5/Win2K/IIS5 I'm seeing wierd results from DateDiff when using 'ww' (weeks) as the date part. Can anyone explain these results? CFSET d1 = 08/3/2003 CFSET d2 = 08/10/2003 CFOUTPUT P#DateDiff('ww',d1,d2)# !--- Result: 1 --- /CFOUTPUT CFSET d1 = 08/4/2003 CFSET d2 = 08/11/2003 CFOUTPUT P#DateDiff('ww',d1,d2)# !--- Result: 0 --- /CFOUTPUT To me, these should both be 1 week. CFSET d1 = 1/1/2003 CFSET d2 = 1/11/2003 CFOUTPUT P#DateDiff('ww',d1,d2)# !--- Result: 0 --- /CFOUTPUT CFSET d1 = 1/1/2003 CFSET d2 = 1/12/2003 CFOUTPUT P#DateDiff('ww',d1,d2)# !--- Result: 1 --- /CFOUTPUT I don't know *what* this means. I thought maybe it was based on ordinal weeks, but it doesn't seem to be. Is this expected behavior? Thanks, Chris ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: SQL Question...
The database design is not conducive to what you are trying to do. The column should be of decimal type where the number represents the length. So 3/4 would be in the DB as .75 I don't believe there is a way to do what you are trying to do with SQL. +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2003 10:17 AM To: CF-Talk Subject: SQL Question... In my db I've got a varchar column called 'width'. It has values like 3/4 or 5/8, etc. I'd like to write a where clause in a SQL query that does something like this: WHERE 0=0 AND (WIDTH BETWEEN #FORM.Width1# AND #FORM.Width2#) [i.e. -- (AND (0.75 BETWEEN 0.5 AND 1))] What do I need to do to make this work? Covert? Cast? Che Vilnonis Application Developer Advertising Systems Incorporated 8470C Remington Avenue Pennsauken, NJ 08110 p: 856.488.2211 f: 856.488.1990 www.asitv.com ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: HELP! Can't clear the CLIENT scope
The client scope is NOT a struct ;) +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Bud [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 7:12 AM To: CF-Talk Subject: Re: HELP! Can't clear the CLIENT scope I'm having some trouble...I'm using CLIENT scoped variables because we are in a load-balanced environment. I need to delete some variables from the client scope and it's just not working...structClear(CLIENT) seems to work when I refresh the browser window to load that code, but when I go back, all of the data that was in the CLIENT scope before is still there. I tried to go in and delete specific keys by doing structDelete(CLIENT,client_data), one at a time, but that didn't work either. Is there a reliable way to delete values from the CLIENT scope? Or am I doing something stupid? I do it like this: cfset clientlist = GetClientVariablesList() cfloop index=i list=#clientlist# cfset temp = DeleteClientVariable('#i#') /cfloop -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ 954.721.3452 - Toll Free: 877.207.6397 - Fax: 954.721.7493 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Totally Stupid Array[1][2] Output Question
Just curious... why are you using a two-dimensional array? Why not just use a normal array and make all the odd indices questions and all the even indices answers? +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 1:11 PM To: CF-Talk Subject: RE: Totally Stupid Array[1][2] Output Question OK, The below is ugly, but it works: cfloop index=x from=1 to=#ArrayLen(QSNDSC_array)# cfoutput#QSNDSC_array[x][1]# #QSNDSC_array[x][2]#/cfoutput /cfloop Is there a better way tht anybody knows of? :: #arrayName[1,1]# #arrayName[1,2]# :: maybe? :: So, how do I output all values in the following (assume it's a question :: [1] /answer [2] pair): :: :: #QSNDSC[1][2]# :: :: Output like (for all questions and answers) :: :: question 1 - answer 1 :: question 2 - answer 2 :: question 3 - answer 3 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Doing Forms in Series
I've dealt with this one before. The best way I found to do it is to have every page post to the same handler page. That handler page has two sections: one to validate form data and a second to display a form. This is really simple to do using fusebox (NOT FB3). So you end up with this (this is an actual page from one of my apps): index.cfm - !--- || BEGIN FUSEDOC || || RESPONSIBILITIES || this is the switch index for the CHECKOUT fusebox NOTE::: This page differs from all other index switches for one main reason: cookies. The CFLOCATIONS that used to happen at the end of each successful act_* page were causing client vars to not be set when using cookies. By seperating the act_* pages into a seperate switch there is no longer a need for CFLOCATION, I can simply change the action variable and cause a new page to display in the second switch. || HISTORY || Author: Bryan Love ; [EMAIL PROTECTED] ; 2/1/01 || VARIABLES || - variables.fuseAction || END FUSEDOC || --- !---### action switch ###--- cfswitch expression=#url.action# !--- billAddress --- cfcase value=billAddress cfinclude template=act_recordBillAddress.cfm /cfcase !--- shipAddress --- cfcase value=shipAddress cfinclude template=act_recordShipAddress.cfm /cfcase !--- ShipMethod --- cfcase value=shipMethod cfinclude template=act_recordShipMethod.cfm /cfcase !--- cardInfo --- cfcase value=payMethod cfinclude template=act_recordPaymethod.cfm /cfcase !--- place Order --- cfcase value=placeOrder cfinclude template=act_placeOrder.cfm cfinclude template=act_cyberCash.cfm cfinclude template=act_authNet.cfm cfinclude template=act_mailOrder.cfm /cfcase /cfswitch !--- display switch --- cfswitch expression=#url.action# !--- billAddress --- cfcase value=billAddress cfinclude template=dsp_header.cfm cfinclude template=dsp_billAddress.cfm cfinclude template=dsp_footer.cfm /cfcase !--- shipAddress --- cfcase value=shipAddress cfinclude template=dsp_header.cfm cfinclude template=dsp_shipAddress.cfm cfinclude template=dsp_footer.cfm /cfcase !--- ShipMethod --- cfcase value=shipMethod cfinclude template=dsp_header.cfm cfinclude template=dsp_ShipMethod.cfm cfinclude template=dsp_footer.cfm /cfcase !--- cardInfo --- cfcase value=payMethod cfinclude template=dsp_header.cfm cfinclude template=dsp_payMethod.cfm cfinclude template=dsp_footer.cfm /cfcase !--- checkoutReview --- cfcase value=checkoutReview cfinclude template=act_checkDiscount.cfm cfinclude template=dsp_header.cfm cfinclude template=dsp_checkoutReview.cfm cfinclude template=dsp_footer.cfm /cfcase cfdefaultcase action cfoutputb#url.action#/b/cfoutput not found /cfdefaultcase /cfswitch -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:15 AM To: CF-Talk Subject: Re: Doing Forms in Series I don't really want to stash the data in a temporary table, since this web site currently isn't data-driven and has no data source available. Also, I don't want to user session variables. When the second form is being built, just create hidden form variables holding the values from the first form. When you submit the second form, both groups of vars get passed. Essentially you're transferring the first batch of data twice, but unless you've got a ton of data, it shouldn't be an issue. No problems there. I already use hidden form fields within the second form. The quesion is how to get from the template that displays FormA to the template doing FormB by doing a POST. I commonly do this with a CFLOCATION and URL variables when there's not much data to be passed. It's not as simple to do a POST. Maybe the answer is to use a single template and then CFINCLUDE the individual forms from that template (or they could be entirely contained in one template if I want to manage one gigantic source file). Jim ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm
RE: Mach II
I totally agree with you regarding FuseBox 3, but the older FuseBox architectures were simpler and far more easy to learn/understand/implement. I've written many apps using FB2-ish architecture and they absolutely fly when it comes to performance and I've gotten a lot of positive feedback from developers modifying the code and zero bad feedback. Consider using FB, but don't let it get out of control like FB3 did. -Original Message- From: Alexander Sherwood [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:41 AM To: CF-Talk Subject: RE: Mach II At 06:25 PM 7/29/2003 +0100, you wrote: I had a quick look at the example too. It seems like machII is really adding a lifecycle to cfcs?? Am I wrong? WG I always thought that Fusebox was a little too much. It was a little overkill for most CF apps, and it often confused developers and shyed them right back into spaghetti code. I like Mach-II, though. I've built my own framework (s) over the year, but with the advent of CFCs, something like Mach-II, which uses XML files to link components and events together is a damned good approach. It's very clean and easy to follow once you understand the underlying components that handle interactions. The fact that it's built on the MVC methodology is the single most compelling reason to experiment with it. Typical CF code has all kinds of code wrapped in a single template, and MVC (when followed properly) makes, as Hal stresses every chance he gets, code much more maintainable and reusable. Looking forward to learning more about Mach-II. -- Alex Sherwood PHS Collection Agency THE COLLECTORS T: 301.215.4200 F: 301.664.6834 W: www.phs-net.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: [sql] grouping
Here is your best bet: Run this query: SELECT Agency_No, Fund_No, completed, count(*) as totalRecs, FROM SCO567_568 WHERE (Agency_No = #client.agency_no#) GROUP BY Agency_No, Fund_No, completed ORDER BY Agency_No, Fund_No, completed You'll get results like this: AGY FUND Completed TotalRecs 418 001 0 4 418 001 1 4 418 534 0 2 418 534 1 1 Now output like this (untested): AGY Fund TotalRecs Completed cfloop from=2 to=#query.recordcount# index=i step=2 cfset total = totalRecs + myquery.totalRecs[i-1] #AGY# #FUND# #Total# #totalRecs#br /cfloop +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Andrew Peterson [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 12:01 PM To: CF-Talk Subject: [sql] grouping Hi I've got a rather simple query (SQL Server 2000) and its result set looks like this: AGY FUND TotalRecs 418 001 8 418 534 3 I'm basically selecting a couple of fields and doing a grouping for the third field (COUNT(*) AS totalRecs). This works fine. The user, however, wants a sub grouping, depending on other fields in the result set, and I can't figure out how to do it. Basically, they want their result set to look like this: AGY Fund TotalRecs Completed 418 001 8 total 4 418 534 3 total 1 The added field, Completed, is a yes/no field. I can incorporate this field into the result set, by doing this SQL: SELECT Agency_No, Fund_No, count(*) as totalRecs, (SELECT COUNT(Completed) FROM sco567_568 WHERE Completed = 1 AND AGENCY_NO =#client.Agency_No#) AS totCompleted FROM SCO567_568 WHERE (Agency_No = #client.agency_no#) This gives the following result: AGY Fund TotalRecs Completed 418 001 8 total 5 418 534 3 total 5 This fourth field, Completed, is displayed in the manner I expect, which is to say that it is giving me the total number of records Completed for the Agency_Number passed in. But what I need to do is factor in a WHERE clause based also on the Fund_No, which is not passed in to the query but rather obtained from the value SELECTed from the current row of the table. In other words, the total for all the records for Completed based on the agency_no passed in is 5, but what I want is the Completed total for each row (Agency_No of 418 and Fund_No of 001 has 4 of its 8 total items marked Completed (not 5), and the second row, the total is 1 (not 5). Is there any way finagling I can do to this query to get the results I want, or perhaps another way to present the data in a row-based format to achieve the same results? I actually told the user that I didn't think it could be done, but it would be so sweet if it could. Any ideas? Thanks in advance. Sincerely, Andrew ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: on-line stores
Try NetReady. It has everything you listed below, including PayPal integration, and then some. It's also very well written and easy to modify. It's a very powerful commerce engine and you just can't beat it for the price... http://aloha-webdesign.com +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 7:54 AM To: CF-Talk Subject: on-line stores Because I am lazy and do not want to re-invent the wheel, I was wondering what you all would recommend for a pre-built on-line store (except AbleCommerce of course) that is easily extensible, open source and inexpensive (under a grand as I am small time right now). I have rolled my own store for the time being but it is simple and primitive compared to others out there. What I am looking for regarding features is this: inventory management image management ability to tie in images to descriptions a GOOD shopping cart integration with Pay Pal (I can do this if I have to) order management product management There are other features that I cannot think of right now, but I think you all get the picture. Thanks, Bruce Sorge CF Developer and Entrepreneur ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Structure, Array, Both?
First of all, why are you doing it? Why store the whole thing in memory? +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: James Blaha [mailto:[EMAIL PROTECTED] Sent: Friday, July 18, 2003 7:59 AM To: CF-Talk Subject: Structure, Array, Both? All: Structure or Array? I have a large table that I want in server memory but I'm not sure what the best route to follow is. There are many columns. Let say its White Pages information. Tables Columns e.g. : ID, FirstName, LastName, Address, City, State, Zip and Notes What is the best route to follow for a CFQUERY e.g. (Select * From Table) to place all its information into a structure or array? Regards, James Blaha ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Cons to Fusebox
Mary Jo, I hope the work on converting CFWebstore to FB is successful, I won't ever need another CF e-commerce app again! Why not try NetReady? It's already done in Fusebox and has an impressive feature list... Since the last update of the web page below there have been a few other additions, such as PayPal integration and the ability to handle bulk discounts. It's definitely worth checking out, and it's in use on a few high end commerce sights out there, even though it hasn't had a lot of publicity. http://aloha-webdesign.com/index.asp?fuseaction=detailspid=19 -Original Message- From: Stas Newdel [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 7:42 PM To: CF-Talk Subject: Re: Cons to Fusebox I find Fusebox very useful when I go out to get a 3rd party application to customize for a client. I know exactly where to look to modify things or implement new modules. In reality though, I've personally found relatively few polished commercial or otherwise apps implemented in FB that I can purchase and modify... They must all be custom in-house projects then. Is there some kind of Fusebox registry that I had missed? Mary Jo, I hope the work on converting CFWebstore to FB is successful, I won't ever need another CF e-commerce app again! - Original Message - From: Shawn Grover [EMAIL PROTECTED] I work pretty much in the same fashion Dave has indicated. However, I have absolutely no data layer logic on my display page. Any data layer logic is accessed via a function call to a business rule object, and the business rule object accesses whatever data layer objects it needs. I then have my basic data that I place into the page as needed. So, by simply applying OOP principles, I achieve the abstraction and encapsulation you and other FB proponents seem to be offering as what makes FB so good. Seing as all actions start from a page request, why not let the page determine what needs to be done? FB does the same thing, using a different method (index.cfm switch case). In both cases (FB vs OOP), the end result is a page that is rendered correctly and using some kind of architecture. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
good Forums software?
It's been too long since I incorporated a good forums application. Anyone have any suggestions? If it's configurable then I don't care too much how it's written, but if it's not, then I much prefer something in FB2 - NOT FB3. Bryan Love ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Data Types?
depends entirely on what DB you are using, whether or not you want it to be searchable, and what you want the max allowable size to be. +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: James Blaha [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 12:54 PM To: CF-Talk Subject: Data Types? CFer's, I have users who are cutting and pasting from a word document into a text area within a form. I need to insert that information into one field in SQL Server 7. What is the best data type to use? Regards, JB ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Is there a way to test to see if a data source exists?
on Windows you can check the registry: CFREGISTRY ACTION=GETALL NAME=DS_ODBC_List TYPE=ANY BRANCH=HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources cfset DSNnames = valueList(DS_ODBC_LIST.entry) cfif listFind(DSNnames,DSN) !--- a datasource with that name already exists, so do whatever --- /cfif !--- Make sure that this DSN does not exist as a an existing CF DSN --- CFREGISTRY ACTION=GETALL NAME=DS_Native_List TYPE=KEY BRANCH=HKEY_LOCAL_MACHINE\SOFTWARE\Allaire\ColdFusion\CurrentVersion\DataSo urces cfset DSNnames = valueList(DS_ODBC_LIST.entry) cfif listFind(DSNnames,DSN) !--- a datasource with that name already exists, so do whatever --- /cfif -Original Message- From: Stan Winchester [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 10:55 AM To: CF-Talk Subject: Is there a way to test to see if a data source exists? Is there a way to test to see if a data source exists? I am creating a setup routine where the user will enter the data source name, and I would like to check to see if it exists before using it. Stan Winchester [EMAIL PROTECTED] http://www.aftershockweb.com/ Tel. 503-244-3440 Fax 503-244-3454 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Decision operators as variables
here ya go - here's an example: cfset w = 0 cfset x = NEQ cfset y = 1 cfif evaluate(#w# #x# #y#)hi/cfif +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 10:12 AM To: CF-Talk Subject: Decision operators as variables Hello, I'm probably missing something simple, but how can I make this cfif statement work using only variables? cfif NOT Evaluate(arguments.FormVars.#this.aFieldsCart[i].RequiredFieldName#) this.aFieldsCart[i].FieldComparisonValue this.aFieldsCart[i].FieldComparisonValue Where Evaluate(arguments.FormVars.#this.aFieldsCart[i].RequiredFieldName#) is the variable name, this.aFieldsCart[i].FieldComparisonValue is a Decision Operator (gt, lt, gte, lte, eq, etc...) And this.aFieldsCart[i].FieldComparisonValue is the value I'm checking against. Thanks, Jonathan Jonathan Mauney Manager, Digital Media Properties / Web Application Developer 1110 WBT AM / 107.9 the LINK (WLNK-FM) / Jefferson-Pilot Radio Network Jefferson-Pilot Communications Co. One Julian Price Place Charlotte, North Carolina 28208 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFC performance difficulties
post the code you are using to create the array of structs from the query results. +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Mike Pacella [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 12:12 PM To: CF-Talk Subject: CFC performance difficulties Thanks for the reply Sean. My one question is that I've been doing Java for about 2 years and this is primarily the methodology we, as a company subscribed to.In situations where we had objects that would need to be looked up frequently, we'd create Hashtables whose values would be the objects we needed to look up. This would give us easy access to the objects...I thought that, with ColdFusion, structures were essentially Hashtables. And, CFCs were essentially objects. So I figured this would be a slam dunk. Is there another way you would suggest, just speaking in general OO terms even, that would speed up this problem? If I'm catching your drift properly, you are suggesting that my design is weak, and that CFC limitations aren't the problem. So, any help on the fallacies of my design would be greatly appreciated... ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFC performance difficulties
Wow, you have a lot going on here. It's no wonder it takes a while to execute Is there any reason you do not want to run two queries instead? You are transferring the work load of the DB to the CF server in the code below - you should let the DB do what it does best. You'll need one query to get the list of campuses and another to display the information about a chosen campus, right? That's how CF was meant to work best. +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Mike Pacella [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 12:48 PM To: CF-Talk Subject: CFC performance difficulties cfcomponent hint=Creates the CampusDAO CF component, which will provide database interaction with the Campus table displayName=CampusDAO !--- Function: selectCampuses Purpose:Returns a query of all campuses in the database Parameters: - String dataSource (required) : Datasource to update data Returns:- Structure stCampusData : Structure of CampusData objects keyed by CampusCd --- cffunction name=selectCampuses hint=Returns a query of all campuss in the database returnType=struct access=public cfargument name=dataSource type=string required=true hint=Datasource to update data !--- Select the data --- cfquery name=qSelectCampus datasource=#arguments.dataSource# dbtype=odbc SELECT campusCode, typeCode, campusName, localName, openDate, addedDate, changedDate, terminalID, communityInd, locationCode FROM CAMPUS /cfquery cfscript QueryAddRow(qSelectCampus); QuerySetCell(qSelectCampus, campusCode, 8); QuerySetCell(qSelectCampus, campusName, RF - SYSTEM ADMIN); stCampusData = StructNew(); /cfscript cfloop query=qSelectCampus cfscript // Create the campus object stCampusDataArgs = StructNew(); stCampusDataArgs.campusCd = campusCode; if (typeCode neq ) stCampusDataArgs.campusTypeCd = typeCode; if (campusName neq ) stCampusDataArgs.campusNm = campusName; if (localName neq ) stCampusDataArgs.campusLocalNm = localName; if (openDate neq ) stCampusDataArgs.campusOpenDt = openDate; if (addedDate neq ) stCampusDataArgs.campusAddDt = addedDate; if (changedDate neq ) stCampusDataArgs.campusChangeDt = changedDate; if (terminalID neq ) stCampusDataArgs.trmId = terminalID; if (communityInd neq ) stCampusDataArgs.cmmColInd = communityInd; if (locationCode neq ) stCampusDataArgs.locCd = locationCode; /cfscript cfinvoke argumentcollection=#stCampusDataArgs# component=mike.cfc.CampusData method=getInstance returnvariable=objCampusData /cfinvoke cfscript StructInsert(stCampusData, campusCode, objCampusData); /cfscript /cfloop !--- Return the structure of CampusData --- cfreturn stCampusData /cffunction /cfcomponent ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http
RE: CFC performance difficulties
also if you insist on doing it with one query you have other options... cache the query and use this (untested code): cfset campusList = valueList(selectCampuses.campusCode) cfset idx = listFind(campusList,chosenCampusCode) !--- output info --- cfoutput #selectCampuses[idx].campusCd# #selectCampuses[idx] . /cfoutput +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Mike Pacella [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 12:48 PM To: CF-Talk Subject: CFC performance difficulties cfcomponent hint=Creates the CampusDAO CF component, which will provide database interaction with the Campus table displayName=CampusDAO !--- Function: selectCampuses Purpose:Returns a query of all campuses in the database Parameters: - String dataSource (required) : Datasource to update data Returns:- Structure stCampusData : Structure of CampusData objects keyed by CampusCd --- cffunction name=selectCampuses hint=Returns a query of all campuss in the database returnType=struct access=public cfargument name=dataSource type=string required=true hint=Datasource to update data !--- Select the data --- cfquery name=qSelectCampus datasource=#arguments.dataSource# dbtype=odbc SELECT campusCode, typeCode, campusName, localName, openDate, addedDate, changedDate, terminalID, communityInd, locationCode FROM CAMPUS /cfquery cfscript QueryAddRow(qSelectCampus); QuerySetCell(qSelectCampus, campusCode, 8); QuerySetCell(qSelectCampus, campusName, RF - SYSTEM ADMIN); stCampusData = StructNew(); /cfscript cfloop query=qSelectCampus cfscript // Create the campus object stCampusDataArgs = StructNew(); stCampusDataArgs.campusCd = campusCode; if (typeCode neq ) stCampusDataArgs.campusTypeCd = typeCode; if (campusName neq ) stCampusDataArgs.campusNm = campusName; if (localName neq ) stCampusDataArgs.campusLocalNm = localName; if (openDate neq ) stCampusDataArgs.campusOpenDt = openDate; if (addedDate neq ) stCampusDataArgs.campusAddDt = addedDate; if (changedDate neq ) stCampusDataArgs.campusChangeDt = changedDate; if (terminalID neq ) stCampusDataArgs.trmId = terminalID; if (communityInd neq ) stCampusDataArgs.cmmColInd = communityInd; if (locationCode neq ) stCampusDataArgs.locCd = locationCode; /cfscript cfinvoke argumentcollection=#stCampusDataArgs# component=mike.cfc.CampusData method=getInstance returnvariable=objCampusData /cfinvoke cfscript StructInsert(stCampusData, campusCode, objCampusData); /cfscript /cfloop !--- Return the structure of CampusData --- cfreturn stCampusData /cffunction /cfcomponent ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com
RE: how to get the tablenames in a database
What type of DB? +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 12:52 PM To: CF-Talk Subject: how to get the tablenames in a database I have a DSN. From this i can easily get the name if database it is pointing to. But how to get the tables in that database at run time? Thanks, Dave 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. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Creating a CF Data Source with CF Code - Possible?
I can write you a custom tag if you want... -Original Message- From: James Johnson [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 7:59 PM To: CF-Talk Subject: Creating a CF Data Source with CF Code - Possible? Hello, I'm creating an application where trusted users can upload MDB files for processing. I plan on verifying the uploaded MDB file with a simple cfquery then if it passes, continue on with the processing. Part of the app is a way to Add/Modify/Delete these users. My plan is to have a DSN for each user based on their assigned name. The MDB file assigned to this DSN will be a dummy file, just so I can create the DSN. The process will copy the uploaded MDB file to the appropriate directory, thus allowing me to do the cfquery. This DSN will be held in a variable when they log on, so I can do the cfquery on the MDB they just uploaded. My question is this. Is it possible to create a CF Data Source without having to use CF Administrator? All users of the Add/Modify/Delete portion of the app will be trusted employees. However, I'd like to make the process as automated as possible. Thanks, James ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Charsets when querying db
What version of MySQL are you using? Try switching to 4.1 if you aren't using it... http://www.mysql.com/doc/en/Charset-Unicode.html +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 1:45 PM To: CF-Talk Subject: Charsets when querying db Hello Im having some trouble with querying my db (Mysql on mx), and im getting ú replaced by funny characters and all sorts like that. I have a feeling its to do with the character sets the db is returning, and the charset on the page... I tried to change the page charset, but no difference, is there any way of forcing the db to return a charset... Either that or its a problem with cfmx... :) Ryan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Vertical Display...
here is the query version (I did it with states): ...query for all states... cfset columns = 3 cfset maxPerCol = ceiling(qStates.recordcount / columns) !--- states list --- tr td valign=top table cellpadding=0 cellspacing=2 border=0 width=100% cfloop query=qStates tr td align=right class=fieldDesc nowrap#stateName# :/td td input type=text size=5 name=newTaxList maxlength=7 value=#numberFormat(taxRate,0.0)# input type=hidden name=oldTaxList value=0#taxRate# input type=hidden name=stateIDList value=#stateID# /td /tr cfif NOT currentRow MOD maxPerCol /table /td td valign=top table cellpadding=0 cellspacing=2 border=0 width=100% /cfif /cfloop /table /td /tr The list version would be similar: cfset columns = 3 cfset maxPerCol = ceiling(listlen(PairSizeList) / columns) . +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 2:07 PM To: CF-Talk Subject: Vertical Display... Last week there was code to display a query's content's 'vertically'. Say I have the folllowing list: cfset PairSizeList = 8,8.5,9,10,11,12,13,14,15,16,17,18,19,20,22,24,26,28,30,32,34,36,38,40,42,4 4,46,48 How would I display that list in a table 'vertically' with 4 columns??? TIA-Ché ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Vertical Display...
here's another version: cfset pairSizeArr = listToArray(PairSizeList) cfset columns = 3 cfset maxPerCol = ceiling(arrayLen(PairSizeArr) / columns) cfset start = 1 cfset xtra = table tr cfloop from=1 to=#columns# index=i td cfset end = start + maxPerCol cfif end GT arrayLen(PairSizeArr) cfset end = arrayLen(PairSizeArr) cfset xtra = repeatString(trtdnbsp;/td/tr,maxPerCol-(end-start)) /cfif table cfloop from=#start# to=#end# index=j trtd#pairSizeArr[j]#/td/tr /cfloop !--- this will keep your table from looking ugly with empty cells --- #xtra# /table cfset start = start + maxPerCol /td /cfloop /tr /table +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 2:25 PM To: CF-Talk Subject: RE: Vertical Display... matthew...you da man! thanks! -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 5:21 PM To: CF-Talk Subject: Re: Vertical Display... cfset cols = 4 cfset rows = ceiling(listlen(PairSizeList) / cols) cfset data = arraynew(2) cfloop from=1 to=#cols# index=col cfloop from=1 to=#rows# index=row cfset data[col][row] = listgetat(PairSizeList, (col - 1) * rows + row) /cfloop /cfloop cfoutput table cfloop from=1 to=#rows# index=row tr cfloop from=1 to=#cols# index=col td #data[col][row]# /td /cfloop /tr /cfloop /table /cfoutput Haven't checked this, and you'd need also to check what happens when listlen(PairSizeList) is not a multiple of 4. Matthew Walker Electric Sheep Web http://www.electricsheep.co.nz/ - Original Message - From: Che Vilnonis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 9:07 AM Subject: Vertical Display... Last week there was code to display a query's content's 'vertically'. Say I have the folllowing list: cfset PairSizeList = 8,8.5,9,10,11,12,13,14,15,16,17,18,19,20,22,24,26,28,30,32,34,36,38,40,42,4 4,46,48 How would I display that list in a table 'vertically' with 4 columns??? TIA-Ché ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Charsets when querying db
My mistake, I was reading up on the differences in unicode handling between 4.0 and 4.1 and I had 4.1 on my mind. Jochem is correct, you would not want to use 4.1. Good lookin' out, Jochem! +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 2:16 PM To: CF-Talk Subject: Re: Charsets when querying db Bryan Love wrote: What version of MySQL are you using? Try switching to 4.1 if you aren't using it... You are recommending people to switch to an alpha release? It might be a better idea to try the following in the connectionstring first (presuming the database charset is iso-8859-1): useUnicode=truecharacterEncoding=iso-8859-1 Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Called as module or include?
you might try checking for the existence of the CALLER scope. cfif isdefined(caller) AND isStruct(caller) this template was called using CFMODULE cfelse this template was called using CFINCLUDE /cfif +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Peter Mayer [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 10:29 AM To: CF-Talk Subject: Called as module or include? Hello! Is there a possibility to get to know if a template is called either via cfmodule or cfinclude? I can see the difference between standalone and cfinclude/cfmodule by executing a check with GetBaseTemplatePath but no difference between the cfmodule and cfinclude methods. Best regards, Peter ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Called as module or include?
unless of course you practice the ridiculous art of converting everything to the attributes scope - as per fusebox. I always claim that the apps I write use FBX (a derivation of FB2 or FB3) because I've always refused to convert everything to the attributes scope. Think this thread will start a fire? ;) +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 11:39 AM To: CF-Talk Subject: RE: Called as module or include? Is there a possibility to get to know if a template is called either via cfmodule or cfinclude? I can see the difference between standalone and cfinclude /cfmodule by executing a check with GetBaseTemplatePath but no difference between the cfmodule and cfinclude methods. I imagine you could test for the existence of the ThisTag scope, which will only exist within a custom tag. But, this seems like an odd question; if you write something to be used as a custom tag, it isn't likely to work at all if you CFINCLUDE it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Called as module or include?
Who is to say JSP does it right? Personally, I love having my URL/Form scopes split. Amen to that! +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 12:24 PM To: CF-Talk Subject: RE: Called as module or include? unless of course you practice the ridiculous art of converting everything to the attributes scope - as per fusebox. Kinda like JSP does -- request.getAttributes(). What a crazy idea.. Who is to say JSP does it right? Personally, I love having my URL/Form scopes split. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Called as module or include?
For one, it adds definition to the code. It's easier to see what's going on when the FORM or URL scope is explicity used. For two, there are a few times when you'll have a page that could accept a variabl via form or url. In this case you MAY choose to leave the variable name unscoped so that either one will be picked up by the code, but further down in the same code you may need to distinguish between FORM or URL to determine a course of action. There are plenty more reasons hiding out there, but these are two I can think of right now... I'm sure someone will berate me for even mentioning the second one, and to them I say there is a time and place for everything ;) +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 12:58 PM To: CF-Talk Subject: Re: Called as module or include? - Original Message - From: Bryan Love [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, June 19, 2003 3:45 PM Subject: RE: Called as module or include? Who is to say JSP does it right? Personally, I love having my URL/Form scopes split. Amen to that! OK, I'll bite. Why? What good does it do? Regards, John Paul Ashenfelter CTO/TransitionPoint +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 12:24 PM To: CF-Talk Subject: RE: Called as module or include? unless of course you practice the ridiculous art of converting everything to the attributes scope - as per fusebox. Kinda like JSP does -- request.getAttributes(). What a crazy idea.. Who is to say JSP does it right? Personally, I love having my URL/Form scopes split. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Switching to OLE DB
You'll find people on both sides of the fence with this one. In all the research I've done it looks like ODBC seems to be the better choice. I've heard that OLE can be buggier than ODBC and many of the performance improvements that some people attribute to OLE are just myth. Anyhow, I HIGHLY doubt that switching will make any difference one way or another. Maybe your problem is DB related - maybe not - but it almost certainly is not related to your choice of ODBC or OLE drivers. +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 4:18 PM To: CF-Talk Subject: RE: Switching to OLE DB Hmmm... I probably should have checked the archives first :-) -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 2:53 PM To: CF-Talk Subject: Re: Switching to OLE DB Well, I don't know if it's that clear cut, but I initially switched to oledb, thinking that it was the *way to go*, because it was more native and faster than odbc. When I posted my problems, the few cftalkers that responded said that oledb was probably *not* the way to go. :-/ Hopefully, others will chime in, and have *all* the answers. Jamie On Wed, 18 Jun 2003 13:24:58 -0700, in cf-talk you wrote: Hmm... So oledb no work... That sux... -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 12:57 PM To: CF-Talk Subject: Re: Switching to OLE DB [whoops, newsgroup users, i posted to only the newsgroup the first time] When I tried OLEDB, I had a couple of problems. One, a query would fail for some mysterious reason (a connection problem) one in, maybe 1000 queries, but I could never get it to fail myself, nor could I nail down why it was happening. I went back to ODBC, and it never happened again. Someone else confirmed similar problems. Two, (my memory's foggier on this one) I could not retrieve more than one text field per query... terribly annoying when 1 were needed. Jamie On Wed, 18 Jun 2003 12:21:29 -0700, in cf-talk you wrote: Please, help... Our ColdFusion 5 services have been crashing and restarting lately, and I've been thinking of converting to OLEDB drivers instead of ODBC to see if the memory leak is related to the use of ODBC alone. It's not much, but it'll help I'm sure. So naturally, I piced the SQLOLEDB drivers first. Those are great. I get this error: Unknown Data Access Error. every time I try to envoke a stored procedure. Pretty uninformative. I've found little information on this, and those who had the problem never got an answer... Fine. I figured let's try using MSDASQL instead... Not the best to use an OLEDB to ODBC bridge, but still, at least it's not just ODBC. I am particularly trying to find the source of the memory leaks. So with MSDASQL, I get an error message on stored procedures with output variabls: Miltiple-Step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. I found this article on that: http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q269495 Well, the key already exists for MSDASQL, so that kb article does nothing for me. I have tried with MDAC 2.6 and MDAC 2.7... Any thoughts on what to do next? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Data getting truncated on select
Are you using CFMX? I've had that problem using WDDX packets in client vars that are stored in the DB because the Java type that CFMX uses is/was (fixed yet? dunno) not large enough to handle the string. Perhaps you are having the same issue. +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 10:51 AM To: CF-Talk Subject: Data getting truncated on select Greetings, I am querying a row in a table bringing back a large about of html data from a column named RawData, data type TEXT, When outputting a lot of data is not getting output, this is really strange, But I went into query analyzer and updated the field with a really large text string, data data etc... end on outputting the data it was prove somehow on select its being truncated as end did not get output. My stored proc looks like this, CREATE PROCEDURE leo4_getScheduledData ( @customerID INT, @MacroName VARCHAR(50), @ContainerID INT ) AS SELECT * FROMSchedulesContainer WHERE [EMAIL PROTECTED] AND [EMAIL PROTECTED] AND [EMAIL PROTECTED] any ideas would be appreciated. J ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Shopping Cart
Try NetReady. It's written using Fusebox and performs extremely well. If you need a cart that can scale, this is it. Best of all it's VERY easy to modify and integrate. Oh yeah, it also works with MySQL, Oracle, Access, and SQL Server. http://aloha-webdesign.com +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Joel Blanchette [mailto:[EMAIL PROTECTED] Sent: Monday, June 16, 2003 2:41 PM To: CF-Talk Subject: Shopping Cart Hello All, Does anyone know of a good shopping cart. Nothing too elaborate, but something easy to implement. I don't feel like re-inventing the wheel. Thanks Joel ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: saving textarea input to rtf
??? As far as I know you can't put bold and italics in a text area. +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Andrew Henry [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 8:17 PM To: CF-Talk Subject: saving textarea input to rtf Hi, Somewhat of a newbie question I expect. I have to save input from a textarea, in which the user has the opportunity to alter the text in the area(e.g. bold, italic), into an rtf file. That is to say, I need to save what the user sees in the textarea into an rtf file so that when the user opens the rtf file, from say Word the bold and italicized text are retained. Thanks for any ideas you have to offer. Cheers, Andrew Henry ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Pagination (Next n records) for an inner join and grouped out put...
I've run into this one before and it sucks. Your best bet, if you want the number of unique property ids is to run another query that does a SELECT COUNT DISTINCT propertyID AS pCount... But whether or not it will work to use this number as the recordcount is anyone's guess. You may have to keep track manually. +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Jeff [mailto:[EMAIL PROTECTED] Sent: Thursday, June 12, 2003 11:22 AM To: CF-Talk Subject: Pagination (Next n records) for an inner join and grouped output... I've got an inner join that I'm trying to make work with paging the records and I *think* I see what the problem is, but I don't know how to proceed... The inner joins are working correctly. In fact, when I go to output, I simply group them by property ID, and I get the right number of Properties, and the right rates for each property...but the pagination is ALL wonky. I'm using Dreamweaver's Next N results, which is fairly easy to understand, and normally works great... Here's my query: cfif IsDefined(URL.Bedrooms) cfquery name=getMyListings datasource=#Application.DSN# SELECT * FROM (tblRentalLocations INNER JOIN tblRentalProperties ON tblRentalLocations.LocationID=tblRentalProperties.frn_LocationID) INNER JOIN tblRentalRates ON tblRentalProperties.PropertyID=tblRentalRates.frn_PropertyID cfif URL.Bedrooms NEQ 'ANY' WHERE tblRentalProperties.PropertyBedrooms = #URL.Bedrooms# /cfif ORDER BY tblRentalProperties.PropertyName, tblRentalRates.RatesOrder, tblRentalRates.RatesLength Desc /cfquery /cfif My Next N code looks like this: cfset MaxRows_getMyListings=10 cfset StartRow_getMyListings=Min((PageNum_getMyListings-1)*MaxRows_getMyListings+1 ,Max(getMyListings.RecordCount,1)) cfset EndRow_getMyListings=Min(StartRow_getMyListings+MaxRows_getMyListings-1,getM yListings.RecordCount) cfset TotalPages_getMyListings=Ceiling(getMyListings.RecordCount/MaxRows_getMyList ings) cfset QueryString_getMyListings=Iif(CGI.QUERY_STRING NEQ ,DE(CGI.QUERY_STRING),DE()) cfset tempPos=ListContainsNoCase(QueryString_getMyListings,PageNum_getMyListings= ,) cfif tempPos NEQ 0 cfset QueryString_getMyListings=ListDeleteAt(QueryString_getMyListings,tempPos, ) /cfif Now, here's where it gets wonky. On the query, the actual recordcount is the total number of rows returned, when I use the grouped output and nest my cfoutput tags, it works perfectly, but it gives me a wrong recordCount and that, in turn, throws the next n browsing all to heck and back. I THINK I should somehow be totalling the number of unique PropertyIDs there are in the query, and use that instead of recordCount...am I on the right track? I tried COUNT(PropertyID) AS PropertyCount but that didn't work, it won't let you use that AND a * in the same query, and when I went to all the trouble to place all my fieldnames in there, it didn't work either... ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Arrrgh...that's not good...Re: Pagination (Next n records) fo r an inner join and grouped output...
Post the code you are using to output the query. The information you are trying to display could make or break this effort. I'm assuming you have something like this: cfoutput query=foo group=propertyID #propertyID# ? cfoutput #some info#... /cfoutput /cfoutput and you want to outputsay...10 propertyIDs per page? Without running the SELECT COUNT DISTINCT... you will only be able to use next page and previous page links because you won't know how many total pages there are. +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Jeff [mailto:[EMAIL PROTECTED] Sent: Thursday, June 12, 2003 12:08 PM To: CF-Talk Subject: Arrrgh...that's not good...Re: Pagination (Next n records) for an inner join and grouped output... on 6/12/03 2:34 PM, Bryan Love at [EMAIL PROTECTED] wrote: I've run into this one before and it sucks. Your best bet, if you want the number of unique property ids is to run another query that does a SELECT COUNT DISTINCT propertyID AS pCount... But whether or not it will work to use this number as the recordcount is anyone's guess. You may have to keep track manually. You're kidding me... I had thought about jury-rigging it by doing exactly that. But thought I'd be ashamed of doing something like that... Am I correct in assuming that the recordcount of the join is actually correct? It's a fact that I can verify whenever I group them properly (by grouping them on propertyID) and it always comes out correct. This leads me to believe that the query is actually *THE* correct way to retrieve this information in this particular manner...it's just going to be a pain to do a next n records browse type of function? Is this correct? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Not creating sessions???
It's most likely not the server itself. Remember there are ONLY two possible ways to track a user's session: 1. Cookies store CFID and CFTOKEN 2. Pass CFID and CFTOKEN in the url string If you can't create and hold a session using code that you know is good then one of these two things is failing. Most likely the cookies aren't being set and/or transmitted. Did the domain name change? +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Staff [mailto:[EMAIL PROTECTED] Sent: Thursday, June 12, 2003 3:22 PM To: CF-Talk Subject: CF Not creating sessions??? HELP HELP HELP . . . Anyone got any idea why CF may not create sessions?? I simply moved a working functional CF site to another WIn2K Advanced server, just like the one it came from, and for some reason CF5 will not hold the create and maintain a session. Try to log in and it keeps bumping me back to log in page . . . I determined it is not creating and maintaining a session . . . I uninstalled and reinstalled CF and same shit . . . anone got any ideas??? I can only think to reinstall . . .OS . . .and all . . . jim ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Arrrgh...that's not good...Re: Pagination (Next n records) fo r an inner join and grouped output...
No you can't. When you use aggregate functions in an SQL statement you MUST put all of the fields you are selecting into the GROUP BY clause. That means you will need two queries since you want to select more fields than you want to GROUP BY. I wouldn't look down on yourself too much for that. Two queries is not that big a deal. It's when you put queries inside loops that you deserve to be shot ;) +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Jeff [mailto:[EMAIL PROTECTED] Sent: Thursday, June 12, 2003 2:03 PM To: CF-Talk Subject: Re: Arrrgh...that's not good...Re: Pagination (Next n records) fo r an inner join and grouped output... on 6/12/03 4:47 PM, Bryan Love at [EMAIL PROTECTED] wrote: Post the code you are using to output the query. The information you are trying to display could make or break this effort. I'm assuming you have something like this: cfoutput query=foo group=propertyID #propertyID# ? cfoutput #some info#... /cfoutput /cfoutput That's exactly my output... and you want to outputsay...10 propertyIDs per page? Without running the SELECT COUNT DISTINCT... you will only be able to use next page and previous page links because you won't know how many total pages there are. Can I somehow calculate that DURING the inner join query below? I tried to add it to the SELECT statement with disastrous results... cfif IsDefined(URL.Bedrooms) cfquery name=getMyListings datasource=#Application.DSN# SELECT * FROM (tblRentalLocations INNER JOIN tblRentalProperties ON tblRentalLocations.LocationID=tblRentalProperties.frn_LocationID) INNER JOIN tblRentalRates ON tblRentalProperties.PropertyID=tblRentalRates.frn_PropertyID cfif URL.Bedrooms NEQ 'ANY' WHERE tblRentalProperties.PropertyBedrooms = #URL.Bedrooms# /cfif ORDER BY tblRentalProperties.PropertyName, tblRentalRates.RatesOrder, tblRentalRates.RatesLength Desc /cfquery /cfif ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ArrayDeleteAt for a 2d array?
If you are going to have many values stored for each item in the array then you may also be better off using an array of structs instead of an array of arrays A struct can store unlimited key value pairs so you'd end up with code like this instead... cfset x = arrayNew(1) cfloop from=1 to=20 index=i cfset y = structNew() cfset y.userID = 123 cfset y.userName = fubar cfset arrayAppend(x,y) /cfloop You can reference the values like this... x[1].userID x[1].userName x[2].userID and so on +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 4:15 PM To: CF-Talk Subject: RE: ArrayDeleteAt for a 2d array? Perfect, Brian. I do indeed have to save more than 2 items to each row. I was trying ArrayDeleteAt but screwing up the syntax. Thanks very much for your help yesterday and today nursemaiding me thru this. In case its useful to anyone poking around in the archives some day, here's the template I used to test the creation and deletion of 2d array items. cflock scope=APPLICATION type=EXCLUSIVE timeout=10 cfparam name=url.row default=1 cfset client.UserID=url.Row cfparam default=N name=url.Delete cfif not isdefined (application.myArray) cfset application.myArray=ArrayNew(2) /cfif cfif url.Delete is Y cfloop from=1 to=#ArrayLen(application.myArray)# index=ArrayRows cfif not Compare(application.myArray[ArrayRows][2],client.UserID) cfset arrayDeleteAt(application.myArray,ArrayRows) cfbreak /cfif /cfloop cfelse cfset start=ArrayLen(application.myArray)+1 cfset stop=ArrayLen(application.myArray)+1 cfloop from=#start# to=#stop# index=i cfset application.myArray[i] = arrayNew(1) cfset trash=arrayAppend(application.myArray[i],i) cfset trash=arrayAppend(application.myArray[i],i) cfset trash=arrayAppend(application.myArray[i],now()) /cfloop /cfif htmlheadtitle/title/headbody Click Plain to add array itemshr cfoutput cfloop from=1 to=10 index=i A href=#cgi.script_name#?Delete=YRow=#i#del #i#/A /cfloop A href=#cgi.script_name#Plain/A /cfoutput cfdump var=#application# label=application variables /body/html /cflock --- Matt Robertson, [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- Original Message -- From: Bryan Love [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 10 Jun 2003 15:28:02 -0700 Here you go. By the way, if you are only storing two values you would be much better off using a single array where, say, odd indices are the userID and even indices are the username. Then you could do something like this (it doesn't buy you much here, but if you do other manipulations it could save you some headaches): cfloop from=1 to=#ArrayLen(LoginArray)# index=ArrayRows step=2 cfif not Compare(LoginArray[ArrayRows],client.UserID) !--- delete array row code goes here --- cfset arrayDeleteAt(LoginArray,ArrayRows) cfset arrayDeleteAt(LoginArray,ArrayRows+1) cfbreak /cfif /cfloop but here is the answer to your original question: !--- LoginArray[1]=Username LoginArray[2]=User ID # --- cfloop from=1 to=#ArrayLen(LoginArray)# index=ArrayRows cfif not Compare(LoginArray[ArrayRows][2],client.UserID) !--- delete array row code goes here --- cfset arrayDeleteAt(LoginArray,ArrayRows) cfbreak /cfif /cfloop +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 2:50 PM To: CF-Talk Subject: ArrayDeleteAt for a 2d array? How do you loop over a *2d* array and delete a single row (and all its elements), where that row is determined by a test of the contents. Like so: !--- LoginArray[1]=Username LoginArray[2]=User ID # --- cfloop from=1 to=#ArrayLen
RE: SQL Question - Could CF make this easier?
sure, the IN and NOT IN clauses are much faster than using multiple ANDs, but don't transfer the load to CF - allow the DB to do what it's best at... cfquery name=qCrop datasource=common_as SELECT DISTINCT Description FROMVCT WHERE description NOT IN ('ANISE','APPLES','ASPARAGUS','BEETS','BROCCOLI') ORDER BY Description /cfquery +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Jillian Carroll [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 11:37 AM To: CF-Talk Subject: SOT: SQL Question - Could CF make this easier? I am creating a drop-down list of items, but I want to keep several items from appearing in the drop-down. Is there a more efficient way to accomplish this (there will be several more exclusions): cfquery name=qCrop datasource=common_as SELECT DISTINCT Description FROMVCT ORDER BY Description WHERE description != 'ANISE' AND description != 'APPLES' AND description != 'ASPARAGUS' AND description != 'BEETS' AND description != 'BROCCOLI' /cfquery -- Jillian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: populate the damn array
just move ad = StructNew(); inside the for loop and problem solved. The reason it's doing that is because you only declared structNew once. When you declare structNew it causes the variable (ad) to point to a memory address (let's use 0x1234 for this example). You then add this memory address to the array 36 times so you have an array where each item points to the exact same memory space. The last loop of the for loop sets the values in that memory space to the last item in the file and so it will appear that all the array items are the same (which they are) and they all point to the last item from the file. Put structNew inside the for loop and each iteration of the list will give ad a new memory pointer and each array item will be unique. +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 11:33 AM To: CF-Talk Subject: populate the damn array OK, this probably something real stupid, but I'm not seeing it ... This code takes a tabbed file and is supposed to parse it into an array of structures. The problem is, the array is populating with 36 elements of the same data. Whatever the last item in the file is, that because the repeated element ... which means that each array append is overwriting previous data, or something like that ... below is the complete code ... can anyone see what the error is? Probably something simple and stupid: cfscript Manifest=Replace(manifest, chr(09), ;, ALL); ListFileLen=ListLen(Manifest, #chr(10)##chr(13)#); container = ArrayNew(1); ad = StructNew(); for (y=1; y LTE ListFileLen; y=y+1) { ListFileText=#ListGetAt(Manifest, y, #chr(10)##chr(13)#)#; ad.attribute_name=#ListGetAt(ListFileText, 2, ;)#; ad.ad_id=#ListGetAt(ListFileText, 3, ;)#; ad.display_text=Caption; ad.attribute_cdata=#ListGetAt(ListFileText, 4, ;)#; ad.startdate=#ListGetAt(ListFileText, 5, ;)#; ad.stopdate=#ListGetAt(ListFileText, 5, ;)#; containerAds = ArrayAppend(container, ad); } /cfscript ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Running two applications?
It's been a while since I've done this, so I hope it still works like I remember... In your case you can pass the cfid and cftoken through the url string. But it still won't find the original session you say? It will if the cfapplication tags for both sites have the same name attribute ;) +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Critz [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 6:41 AM To: CF-Talk Subject: Running two applications? oi CF-Talk,!! I've got a website that will allow for ppl to login. A few tidbits of their information is displayed on the site... they have the option of updating their profile, etc... They also have a link which will open the main application in a nother window. I do not really want to put the main website underneath the same application.cfm as the application, but I need to be able to pass their session to the new window/application. any suggestions as to the best way to handle this? Crit --- [This E-mail scanned for viruses by Declude Virus] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ArrayDeleteAt for a 2d array?
Here you go. By the way, if you are only storing two values you would be much better off using a single array where, say, odd indices are the userID and even indices are the username. Then you could do something like this (it doesn't buy you much here, but if you do other manipulations it could save you some headaches): cfloop from=1 to=#ArrayLen(LoginArray)# index=ArrayRows step=2 cfif not Compare(LoginArray[ArrayRows],client.UserID) !--- delete array row code goes here --- cfset arrayDeleteAt(LoginArray,ArrayRows) cfset arrayDeleteAt(LoginArray,ArrayRows+1) cfbreak /cfif /cfloop but here is the answer to your original question: !--- LoginArray[1]=Username LoginArray[2]=User ID # --- cfloop from=1 to=#ArrayLen(LoginArray)# index=ArrayRows cfif not Compare(LoginArray[ArrayRows][2],client.UserID) !--- delete array row code goes here --- cfset arrayDeleteAt(LoginArray,ArrayRows) cfbreak /cfif /cfloop +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 2:50 PM To: CF-Talk Subject: ArrayDeleteAt for a 2d array? How do you loop over a *2d* array and delete a single row (and all its elements), where that row is determined by a test of the contents. Like so: !--- LoginArray[1]=Username LoginArray[2]=User ID # --- cfloop from=1 to=#ArrayLen(LoginArray)# index=ArrayRows cfif not Compare(LoginArray[ArrayRows][2],client.UserID) !--- delete array row code goes here --- cfbreak /cfif /cfloop I've been fighting a losing battle with this all afternoon. --- Matt Robertson, [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ArrayAppend with a 2d array?
In a two dimensional array the only thing you can append to the first dimension is another 1-dimensional array. That means that in the loop you'd need to build a one dimensional array then append it (or something comparable) This would work: cfset x = arrayNew(2) cfloop from=1 to=20 index=i cfset x[i] = arrayNew(1) cfset trash = arrayAppend(x[i],foo) cfset trash = arrayAppend(x[i],bar) /cfloop or this: cfset x = arrayNew(2) cfloop from=1 to=20 index=i cfset y = arrayNew(1) cfset trash = arrayAppend(y,foo) cfset trash = arrayAppend(y,bar) cfset trash = arrayAppend(x,y) /cfloop +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2003 4:15 PM To: CF-Talk Subject: ArrayAppend with a 2d array? Today is my day for dumb questions I suppose... I've always appended to 2d arrays while in a loop, as part of the initial array build process, so determining the first dimension value was never a problem. Never needed to come back to them and append something later, but I do now. All of the examples for ArrayAppend() are for 1d arrays. I can't seem to cobble together a solution. Any helpful pointers would be appreciated. --- Matt Robertson, [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- Original Message -- From: Matt Robertson [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Mon, 9 Jun 2003 15:59:17 -0700 Perfect. CFBREAK was just what I needed and couldn't find. Can't use a conditional under the circumstances. Thx all, --Matt-- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
MS Outlook and CF
Anyone know how to access MS Outlook's calendar using CF? I assume there is an object I can tap, but I don't know what it would be... +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MS Outlook and CF
nevermind, found it in the houseoffusion archives after a lengthy search :) +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2003 1:28 PM To: CF-Talk Subject: MS Outlook and CF Anyone know how to access MS Outlook's calendar using CF? I assume there is an object I can tap, but I don't know what it would be... +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Custom Tag Question
Actually, you have two choices here: you can either use pound signs: cf_thistag condition=#get_data.summary_id# eq 263012 (this will dereferenc get_data.summary_id before passing it to the tag) or reference the caller scope inside the tag: . cfif evaluate(caller.#attributes.condition#) . +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 11:58 AM To: CF-Talk Subject: Re: Custom Tag Question What that is doing os converting the get_data.summary_id to the actual value before it is past over to the customtag. One being a string value and the other a value. Might try to convert the ID to a VAL within the call to the customtag cf_thistag condition=VAL(get_data.summary_id) eq 263012 Not tried it but worth a shot.. [EMAIL PROTECTED] 06/03/03 02:26PM All, I need to pass a portion of a conditional statement to a custom tag, like cf_thistag condition=get_data.summary_id eq 263012 then in the custom tag I wanna do something like cfoutput query=attributes.queryname cfif attributes.condition neq cfif #attributes.condition# then do this cfelse otherwise do this /cfif cfelse do this /cfif /cfoutput I have tried: cfif attributes.condition cfif #attributes.condition# cfif #Evaluate(attributes.condition)# adding the cfif into the attribute like cf_thistag condition=cfif get_data.summary_id eq 263012 and then doing #Evaluate(attributes.condition)# or #attributes.condition# no luck, i keep getting an error saying cannot convert the value 263012 eq 263012 to a boolean. Or sometimes I get an incomplete cfif tag error. I am using MX by the way. Is this process just not possible in Cold Fusion? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFLOOP, almost there
??? The number of characters on each line shouldn't make any difference in the code below. It sees each line as a space-delimited list and grabs the list item that contains the @ symbol. The character length of each line is not part of the equation. +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 11:27 AM To: CF-Talk Subject: RE: CFLOOP, almost there Great! This is the closest I've come yet. The problem is the number of charactors on each liine isn't the same. so some lines, I get just the e-mail, others I get the last name and the e-mail address. So close! Something like this? CFSET CRLF = Chr(13) Chr(10) CFLOOP LIST=#emailtext# DELIMITERS=#CRLF# INDEX=TheLine CFSET EmailItem = ListContains(TheLine,@, ) CFIF EmailItem CFSET EmailAddress = ListGetAt(TheLine, EmailItem , ) !--- Do whatever you want with #EmailAddress# --- /CFIF /CFLOOP -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 1:00 PM To: CF-Talk Subject: CFLOOP, almost there Hi, All I need is some code that will strip out the e-mail address. Ingar Bae Swnary [EMAIL PROTECTED] Ral Diaz Argentina [EMAIL PROTECTED] Cris Grass Uk [EMAIL PROTECTED] Thanks. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Custom Tag Question
ahh, then the second suggestion will still work - putting caller. in front of the query name. +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 2:03 PM To: CF-Talk Subject: RE: Custom Tag Question I don't think so. That would execute when the tag calls. I _believe_ he wants the condition to be run inside the tag, in this case, every time for every row in a query. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 2:22 PM To: CF-Talk Subject: RE: Custom Tag Question Actually, you have two choices here: you can either use pound signs: cf_thistag condition=#get_data.summary_id# eq 263012 (this will dereferenc get_data.summary_id before passing it to the tag) or reference the caller scope inside the tag: . cfif evaluate(caller.#attributes.condition#) . +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 11:58 AM To: CF-Talk Subject: Re: Custom Tag Question What that is doing os converting the get_data.summary_id to the actual value before it is past over to the customtag. One being a string value and the other a value. Might try to convert the ID to a VAL within the call to the customtag cf_thistag condition=VAL(get_data.summary_id) eq 263012 Not tried it but worth a shot.. [EMAIL PROTECTED] 06/03/03 02:26PM All, I need to pass a portion of a conditional statement to a custom tag, like cf_thistag condition=get_data.summary_id eq 263012 then in the custom tag I wanna do something like cfoutput query=attributes.queryname cfif attributes.condition neq cfif #attributes.condition# then do this cfelse otherwise do this /cfif cfelse do this /cfif /cfoutput I have tried: cfif attributes.condition cfif #attributes.condition# cfif #Evaluate(attributes.condition)# adding the cfif into the attribute like cf_thistag condition=cfif get_data.summary_id eq 263012 and then doing #Evaluate(attributes.condition)# or #attributes.condition# no luck, i keep getting an error saying cannot convert the value 263012 eq 263012 to a boolean. Or sometimes I get an incomplete cfif tag error. I am using MX by the way. Is this process just not possible in Cold Fusion? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Client variables and SSL problem
As you know, client variables are keyed off of cfid and cftoken which MUST be passed via cookie or url in order to maintain state. What you might not know is that client variables are also keyed off of the application name (as specified in cfapplication...). Make sure the application name is the same for the http site and the https site and perhaps that will fix it. +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 7:26 AM To: CF-Talk Subject: Client variables and SSL problem Hi folks, I'm working with a client who has a legacy (read that as pretty poorly written) ColdFusion 5 application and I'm experiencing some weirdness with client-scoped variables when the protocol changes from http to https (which it does somewhat randomly on their site). Client variables hold the login information. Everything works fine for users on the http portion of the site. Many users (NOT all -- some work fine) get the you are not a registered user, please login which is triggered by the absense of client variables when they move from the http portion of the site to https. The problem has gotten worse recently, which correlates with some changes I have made. I enabled setDomainCookies since the site is moving to a cluster. I moved the physical location of the client variable storage from one MSSQL database (on the same box) to a dedicated database server -- I copied the client variable storage database from the original to the new machine. I've also renamed the underlying machine for the web site (again, as part of the cluster rollout) and it's a Win2k box running Apache 1.3 and OpenSSL (which is possibly relevant since SSL/https is where the issue occurs). Any ideas? I'm coming through the code archives to see if anything else changed, but I'm puzzled. I honestly think there's some pretty bad code in the whole security process, but the site was working more reliably in the past so it can't simply be the code is garbage. Regards, John Paul Ashenfelter CTO/TransitionPoint ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfobject is not working in CFMX --- urgent issue
don't know about CFMX, but in other versions of CF you need the full path to the jvm.dll. This is what I have and it works: Java Virtual Machine Path c:\jre\1.2\bin\classic\jvm.dll +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: ramesh d [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 12:13 PM To: CF-Talk Subject: cfobject is not working in CFMX --- urgent issue Hi Cfobject (type is Java ) is not working after upgradation from cf4.5 to CFMX (the same cfobject code works fine in cf4.5 but not in CFMX version. Pls could you suggest me these my following setting are correct or not. And if you have any suggestion that would be great also.) do you guys any idea where all class files and jar files and related files need to set up.. Here we are giving the path in CFMX admin page like this, Java Virtual Machine Path C:\CFusionMX\runtime\jre Class Path C:\CFusionMX\wwwroot\WEB-INF\siteminder_P3d1.jar,C:\CFusionMX\wwwroot\WEB-IN F\classes12.zip,C:\CFusionMX\wwwroot\WEB-INF\classes, i can see following directories and classes or jar files in i windows explorer. C:\CFusionMX\wwwroot\WEB-INF\siteminder_P3d1.jar C:\CFusionMX\wwwroot\WEB-INF\classes12.zip C:\CFusionMX\wwwroot\WEB-INF\classes - siteworks -siteminider -phase_IIId -- businessobject dataobject utilities when i execute my application i am getting the error is like this. siteminder.properties (The system cannot find the file specified) (this will be coming from java object only.) 13:51:02.002 - java.io.FileNotFoundException - in C:\Inetpub\wwwroot\sw\do_create_budget.cfm : line 206 And when i go into log files it showing me detailed following error. pls see following error report. Error,jrpp-1,05/28/03,11:20:16,study_startup,siteminder.propertie s (The system cannot find the file specified) The specific sequence of files included or processed is: C:\Inetpub\wwwroot\sw\do_create_budget.cfm java.io.FileNotFoundException: siteminder.properties (The system cannot find the file specified) at java.io.FileInputStream.open(Native Method) at java.io.FileInputStream.init(Unknown Source) at siteworks.siteminder.Phase_IIId.util.PropertiesFileManager.loadData(Properti esFileManager.java:178) at siteworks.siteminder.Phase_IIId.dataobject.AbstractSqlDataObject$Database.i nit(AbstractSqlDataObject.java:1961) at siteworks.siteminder.Phase_IIId.dataobject.AbstractSqlDataObject$Database.ge tDatabase(AbstractSqlDataObject.java:1834) at siteworks.siteminder.Phase_IIId.dataobject.AbstractSqlDataObject.generatePri maryKey(AbstractSqlDataObject.java:216) at siteworks.siteminder.Phase_IIId.dataobject.BudgetDataObject.init(BudgetDat aObject.java:562) at siteworks.siteminder.Phase_IIId.businessobject.Budget.create(Budget.java:102 ) at java.lang.reflect.Method.invoke(Native Method) at coldfusion.runtime.java.JavaProxy.invoke(Unknown Source) at coldfusion.runtime.CfJspPage._invoke(Unknown Source) at cfdo_create_budget2ecfm986965308.runPage(C:\Inetpub\wwwroot\sw\do_create_bud get.cfm:206) at coldfusion.runtime.CfJspPage.invoke(Unknown Source) at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source) at coldfusion.filter.CfincludeFilter.invoke(Unknown Source) at coldfusion.filter.ApplicationFilter.invoke(Unknown Source) at coldfusion.filter.PathFilter.invoke(Unknown Source) at coldfusion.filter.ExceptionFilter.invoke(Unknown Source) at coldfusion.filter.BrowserDebugFilter.invoke(Unknown Source) at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown Source) at coldfusion.filter.BrowserFilter.invoke(Unknown Source) at coldfusion.filter.GlobalsFilter.invoke(Unknown Source) at coldfusion.filter.DatasourceFilter.invoke(Unknown Source) at coldfusion.CfmServlet.service(Unknown Source) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:226) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java: 348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:29 4) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) (NOTE : Any suggestions will be greatful.) Thanks in Advance Best regards ramesh Thanks regards Ramesh Deva 205
RE: cftransaction cftry order
Actually, you'd want the try/catch outside the cftransaction.. because the catch clause would prevent the second transaction tag from executing. This isn't a big deal if you explicitly specify the rollback command, but you don't have to do that if you put the try/catch outside the transaction. In the following example the the first two queries would commit even though the third errors out: cftransaction cftry cfquery datasource=blove_syb5 name= good query /cfquery cfquery datasource=blove_syb5 name= good query /cfquery cfquery datasource=blove_syb5 name= bad query /cfquery cfcatch oops /cfcatch /cftry /cftransaction In this example it works as you expect: the first two queries are rolled back before the cfcatch tag is executed. In the above example you would have to specify a rollback tag, but in this one you don't. cftry cftransaction cfquery datasource=blove_syb5 name= good query /cfquery cfquery datasource=blove_syb5 name= good query /cfquery cfquery datasource=blove_syb5 name= bad query /cfquery /cftransaction cfcatch oops /cfcatch /cftry +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 1:49 PM To: CF-Talk Subject: RE: cftransaction cftry order The first one, so you can rollback the transaction in the CFCATCH block: cftransaction action=begin cftry cfquery cfquery cfquery !--- this is optional --- cftransaction action=commit / cfcatch !--- something happened, roll it back --- cftransaction action=rollback / /cfcatch /cftry /cftransaction --- Barney Boisvert, Senior Development Engineer AudienceCentral (formerly PIER System, Inc.) [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 12:38 PM To: CF-Talk Subject: cftransaction cftry order Brain crampWhich is best/correct: cftransaction cftry cfcatch /cftry /cftransaction OR cftry cftransaction /cftransaction cfcatch /cftry ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFFILE Upload question
try it and see :) +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Scott Wolf [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 2:14 PM To: CF-Talk Subject: CFFILE Upload question If I specify MIME types in the ACCEPT attribute such as: CFFILE ACTION=UPLOAD FILEFIELD=Form.Upload1 DESTINATION=C:\Inetpub\wwwroot\imghost\#SecureCheck.txtUserName# NAMECONFLICT=MAKEUNIQUE ACCEPT=text/html What happens if someone tries to upload a file that isn't on the accept list (like a jpg)? Does a CF error page display? I'm new to working with CFFILE and I'm not even sure if I'm asking the right question. Any help would be greatly appreciated. Thanks! Scott Wolf ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Leave first letter uppercase . . .
What DB are you using? Oracle8i has a neat function named initcap that will do it for you. You could say: SELECT INITCAP(LOWER(city)) as city FROM someTable... +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Earl, George [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 10:54 AM To: CF-Talk Subject: Leave first letter uppercase . . . Is there an existing function or tag that can take an all upper case phrase and convert it so only the first letter in each word remains uppercase and the rest of each word is lower case? Specifically, we have City and State information in our database as all uppercase and we want to display the City with only the first letter capitalized . . . Thanks! George [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Block Competitors from Web site
Just have a pre-page pop up that asks them if they are a competitor. Problem solved. just kidding :) +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 9:09 AM To: CF-Talk Subject: Block Competitors from Web site Hello, Any have any other creative ideas on how to block competitors from gaining access to a Web site. My idea, which isn't fool proof is to try and find out what their network IP address is and write code in your site wide header to redirect or block traffic from a IP sub set, as long you know they company owns the IP sub set. I know the user could just log in fromo their home connection to open a TS session outside of their company. I want to make sure they are blocked from the company. Any other ideas? Thanks. D ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Block Competitors from Web site
An excellent choice! +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: jon hall [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 11:49 AM To: CF-Talk Subject: Re: Block Competitors from Web site Perhaps by leveraging the new evil bit... http://www.armware.dk/RFC/rfc/rfc3514.html -- jon mailto:[EMAIL PROTECTED] Tuesday, May 27, 2003, 12:39:49 PM, you wrote: MK If I read it right, he wants the site to be open, with all his own MK customers and prospective customers getting access to everything, but MK doesn't want to do his competitors' work for them. Make them do their MK own homework. So having closed off areas wouldn't work - his own MK prospective customers wouldn't see what he needs them to see. MK I think he just wants to make it difficult for a few well-defined people MK to see what they're up to and pinch all their ideas. MK Lots of luck though, I can't see how that's possible. MK Cheers, MK Michael Kear MK Windsor, NSW, Australia MK AFP Webworks. -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 1:11 PM To: CF-Talk Subject: Block Competitors from Web site Hello, Any have any other creative ideas on how to block competitors from MK gaining access to a Web site. My idea, which isn't fool proof is to try and find out what their MK network IP address is and write code in your site wide header to redirect or MK block traffic from a IP sub set, as long you know they company owns the IP sub set. I know the user could just log in fromo their home connection to open MK a TS session outside of their company. I want to make sure they are MK blocked from the company. Any other ideas? Thanks. D MK ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfdirectory
cfdirectory uses the OS's file system - it does not go through the web server. I'm guessing since you said virtual directory that you created it in ... IIS? Well it only exists in IIS so when cfdirectory looks to the OS's file system it won't be there. +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Tim Do [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 1:43 PM To: CF-Talk Subject: cfdirectory Hello All, I have a virtual directed created and I'm trying to access it using cfdirectory. I'm calling it like this: directory=\\servername\directory\ file://\\servername\directory\ . Nothing is getting returned, Permission on this account is ready only. Any ideas? Thanks, Tim ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Advanced SQL Query Question
This seemingly simple query can turn nasty in a hurry... If you don't have very many records then use CF to do it like so: SELECT FROM table1 ORDER BY theCategory, theDate cfoutput query=myquery group=theCategory #whatever# /cfoutput Notice this will only print the first record for each new category and since they are sorted by category then date you'll get the most recent. Your other option (if you have lots of records) is to pre-mark the most recent one with a boolean flag when you insert it. Your table would have a column named mostRecent that is either 0 or 1 and each time you insert a record you set all other records in that category to 0 and set the new one to 1. Then your query just says: SELECT ... FROM table1 WHERE mostRecent = 1 +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 1:45 PM To: CF-Talk Subject: RE: Advanced SQL Query Question Jonathan, Try this out: ** Untested code!!! ** SELECT * FROM tblWhatever a INNER JOIN ( SELECT category,max(update_date) update_date FROM tblWhatever ) max_dates ON a.category = max_dates.category AND a.update_date = max_dates.update_date -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 3:06 PM To: CF-Talk Subject: Advanced SQL Query Question Hello, I'm working on a project where records will be added to a single table, and each record will be assigned to one of six categories (using a category column). Is there a way I can do a single query to pull the most recent record from each of the six categories? Or is my only option to do queries of queries on my CF template? Thanks, Jonathan Jonathan Mauney Manager, Digital Media Properties / Web Application Developer 1110 WBT AM / 107.9 the LINK (WLNK-FM) / Jefferson-Pilot Radio Network Jefferson-Pilot Communications Co. One Julian Price Place Charlotte, North Carolina 28208 704.374.3862 [voice] 704.374.3884 [fax] [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [email] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfdirectory
you could do something like this... cfdirectory directory=#expandPath([virtual directory])# +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Tim Do [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 2:31 PM To: CF-Talk Subject: RE: cfdirectory Yes, I created it in IIS.. Guess that explains it. Thanks -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 2:14 PM To: CF-Talk Subject: RE: cfdirectory cfdirectory uses the OS's file system - it does not go through the web server. I'm guessing since you said virtual directory that you created it in ... IIS? Well it only exists in IIS so when cfdirectory looks to the OS's file system it won't be there. +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Tim Do [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 1:43 PM To: CF-Talk Subject: cfdirectory Hello All, I have a virtual directed created and I'm trying to access it using cfdirectory. I'm calling it like this: directory=\\servername\directory\ file://\\servername\directory\ . Nothing is getting returned, Permission on this account is ready only. Any ideas? Thanks, Tim ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: days in a month
FYI - sometimes people find themselves running the same loop over and over again in a page. For example if you have a page that lets the user pick 4 or 5 different dates then you might find yourself looping over the days in a month 4 or 5 times. In times like this it is much faster to run the loop once and record the results to a string, then use the string in 4 or 5 different places +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 12:25 PM To: CF-Talk Subject: days in a month Hello. I'm trying to simplify the code for a drop down list of total # of possible days in a month (31). to look something like what I'm using to display months in a year, which looks like this: select name=firstmonth size=1 cfloop index=firstmonth FROM=1 TO=12 cfoutput option value=#firstmonth##MonthasString(firstmonth)# /cfoutput /cfloop /option /select I tried the code below but it only returns the number 31 in the drop down box (I'm not sure this function was meant for this type of thing anyway): select name=firstday cfloop index=firstday FROM=1 TO=31 cfoutput option value=#firstday##daysinmonth(firstday)# /cfoutput /cfloop /option /select Tim ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Query How-To
ORDER BY name +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 22, 2003 4:56 PM To: CF-Talk Subject: Query How-To How can I go about ordering the following query by first name? cfquery name=emp datasource=#dsn# SELECT DISTINCT(t.employeeid), e.firstname + e.lastname AS name FROM transactions t LEFT JOIN employees e ON t.employeeid = e.employeeid /cfquery The following query throws an error about a conflict between the ORDER BY and DISTINCT. cfquery name=emp datasource=#dsn# SELECT DISTINCT(t.employeeid), e.firstname + e.lastname AS name FROM transactions t LEFT JOIN employees e ON t.employeeid = e.employeeid ORDER BY e.firstname /cfquery Thanks, Jim ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Passing URL vars between pages
You may want to reconsider the way you are doing things... It might be cleaner to write to the DB immediately then pass just the key to the next page. If you must do it the way you are, then you probably would want to just use a session variable. There would be no reason to use WDDX unless you have to store the information in a cookie (that includes client variables). If you must use the url and cannot write to the db before relocating, then you must have some very strict checks in place on the page that does write to the DB to avoid hackers messing with your database. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 16, 2003 1:07 PM To: CF-Talk Subject: Passing URL vars between pages Hi all, I've got a messy (lengthy) cflocation URL=process.cfm?emailaddress=#URLEncodedFormat(URL.emailadr)#... which I contemplated passing about 25 URL variables between one page and a second. On the second page, I would use the URL vars to populate a db. I don't need to keep the vars beyond the second page after they've been written. With this amount of vars what's a good way to accomplish: session, WDDX packet, etc? I know how to write a session, but it seems like a lot for just a one-page pass. If I do a WDDX Serialization, I don't know how to write it, and need an example. Thanks in advance. Mark ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OLE DB and Maintain Connections
The hosting company is on crack. If you have a low traffic site and a weak server then you MIGHT be ahead to NOT maintain DB connections. This is because holding DB connections open is expensive from a hardware resource perspective. Using OLE for your DB connections is nuts. Why would you? What is their reasoning behind this recommendation? Are you storing any client vars in the registry? That can kill your server's performance... Also, you may want to restrict resources for SQL Server - it will chew up ALL your resources if you let it (I've seen it happen). You'll need a DBA to investigate just how much RAM and disk space SQL Server is allowed to consume. I've also seen CFX tags that caused a server to stop responding sometimes. Are you using any of these? +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 15, 2003 1:26 PM To: CF-Talk Subject: OLE DB and Maintain Connections Hi all, We've got a server that's suddenly become very cranky - running slowly, hanging, etc. 3-4 times per day. The hosting company told us that we should: 1. Uncheck 'maintain database connections' for all ODBC datasources. 2. Only use OLE DB for MSSQL datasources. Both of these seem counterintuitive to me - OLE DB is buggy as all get out, and I've always been told that 'maintain database connections' is a performance enhancer, not a drag. We're using CF 4.5.1 - traffic levels are about what they've always been, and all session/app vars are appropriately locked. Any input? Ian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Comparing elements in a list to comma delimited data in a tab le field
First of all I'd like to say that it's almost never a good idea to use comma-delimited lists in a database. It violates the whole DB concept. You should have another table that is used solely to relate record(s) of type A to record(s) of type B. That being said, here is the solution to your original question: 1. Jerry is correct about placing commas before and after the list in the DB - it is a must. 2. CONTAINS is a CF function, not SQL. You must use LIKE. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 07, 2003 12:01 PM To: CF-Talk Subject: SQL: Comparing elements in a list to comma delimited data in a table field Hello all, I want to take a comma delimited list created in a Search form, and check to see if any of the elements in that list is contained in a field in the database which is also comma delimited in a compound CFQUERY statement. SO...form.coatings = 1,5,10,13 The field coatings in the database contains 1,3,14. So therefore that record will be a part of the resultset. The next record coatings field may contain 7,8,9 and therefore should NOT be a part of the resultset. The SQL I tried was: CFQUERY name=sresults datasource=napca SELECT * FROM tblMembers WHERE 0=0 CFIF IsDefined(membertype) AND #membertype# NEQ 0 AND member_type = #form.membertype# /CFIF CFIF IsDefined(form.company) AND #form.company# NEQ AND company_name LIKE '%#form.company#%' /CFIF CFIF IsDefined(form.coating_search)!--- If the user selected a coating search option then check for coatins --- !--- Loop through every coating that the user multiselected on the search form --- AND coatings CONTAINS '#ListFirst(form.coatings)#' !---DEBUGGING CFLOOP list=#form.coatings# index=coating OR coatings = '#coating#' /CFLOOP DEBUGGING --- /CFIF /CFQUERY I was just testing the correct syntax with just checking for one element of the form field list. But I keep getting syntax errors. How can I accomplish this?? -Gel ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: loop query check??how to do this
The GUI should not allow you to choose to be the mainteacher for students who already have one... It seems to me that the error lies in the GUI and should be fixed there, not behind the scenes. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 9:02 AM To: CF-Talk Subject: loop query check??how to do this I have a table- that users can add to their classlist. When adding they can choose multiple students. I can easily do that loop. My prob. Each student will have only one MainTeacher and many peripheral teachers So before a student is added to a classlist it would need to be checked if there's any conflict- that 2 teachers are claiming to be the MainTeacher. So what should happen if 1. one of the 10 students I chose and checked as MainTeacher is already in the db as having a different MainTeacher? How does that fit into the loop?? Thanks ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: Query Question
make sure when you put values in the seeking column to add a comma before and after the list. So a list of 1,2,3 becomes ,1,2,3, That way when you run the query you can say: WHERE seeking LIKE '%,2,%' +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Double Down, Inc. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 1:05 PM To: CF-Talk Subject: Query Question I have this statement in a query: (cfloop index=ii list=#form.seeking# delimiters=,seeking LIKE '%#ii#make %'cfif NOT listlast(form.seeking, ,) is ii and /cfif/cfloop It will select the record if the field (a comma delimitated list) has the value (the values are number). The problem I am having is that if I want to pull the records that contain the number 2, it is giving me the records that contain 2, 22, 23, etc. etc. How do I set this up so it will pull ONLY the records that have the number 2 in it? TIA ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: CFLOOP issues
The most obvious thing is that the cfset... should be inside the cfif... you should also use form[strImage#i#New] instead of evaluate. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Cutter (CF_Talk) [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 2002 11:51 AM To: CF-Talk Subject: CFLOOP issues *** Sorry if this is repost, still having mail server/client issues *** Something new for me within CF so any help is greatly appreciated. I'm trying to loop through a number of form fields (form.strImage1, form.strImage2, form.strImage3, form.strImage4), do some checking, set some variables. But what I'm doing (and I've never done) must be off base. Here's an example: cfloop index=i from=1 to=4 cfset variables.imagefield = evaluate(form.strImage#i#New) cfif isdefined(form.strImage#i#New) cfif len(variables.imagefield) * * More processing stuff here * cfset variables.image#i# = photo cfset variables.thumb#i# = thumb cfif len(form.strImage#i#) * * Even more processing stuff * /cfif /cfif /cfif cfloop What am I doing wrong? Cutter ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
CFMX choking on client vars?
Has anyone had issues using CFMX with an ACCESS client storage database? A friend of mine is getting 500 Operation failed on the data source named 'client_storage'. This only seems to happen using CFMX... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Christine Lawson [mailto:[EMAIL PROTECTED]] Sent: Monday, November 18, 2002 4:29 PM To: CF-Talk Subject: RE: MM: when will this bug be fixed? Nope but I can ask for you, I'll let you know what I find. Christine -Original Message- From: Lee Fuller [mailto:[EMAIL PROTECTED]] Sent: Monday, November 18, 2002 7:23 PM To: CF-Talk Subject: RE: MM: when will this bug be fixed? Any idea when we'll get a DWMX update? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Error Executing Database Query.SQLException
Does it validate from the CF Administrator? +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Jennifer Goodenow [mailto:[EMAIL PROTECTED]] Sent: Monday, November 18, 2002 1:47 PM To: CF-Talk Subject: RE: Error Executing Database Query.SQLException Thanks, but our database doesn't require a connectrion string. Jennifer ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Timeout has no effect on CFQUERY?
Here is how I understand the issue: the timeout attribute is passed directly to the ODBC driver (or equivilent) from CF. That means that in order for it to work the driver must support it. Sounds to me like whatever driver you're using (probably the Oracle native driver) does not support timeout. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Stacy Young [mailto:Stacy.Young;sfcommerce.com] Sent: Monday, November 11, 2002 1:20 PM To: CF-Talk Subject: Timeout has no effect on CFQUERY? Running CFMX with updater on win2k pro, Oracle 8i If I specify a timeout setting for a query, it seems to have no effect. It does not throw an error if the timeout is surpassed...just seems to ignore it. Anyone using that attribute successfully? Stace 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. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: sql isNumeric -- Oracle
select * from sometable where substr(somecolumn,1,1) BETWEEN '0' AND '9' +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Sean McCarthy [mailto:SMcCarthy;HealthObjects.com] Sent: Monday, November 11, 2002 2:07 PM To: CF-Talk Subject: sql isNumeric -- Oracle I have a select statement where I want to only return results where the job_code, varchar2(10) is a number Example: gv123 he32134 bc4543 6785 4320 0323 I only want the ones that are all numbers, no conversion, just return the rows where the job_code is a number. So I would get back from my select the following results 6785 4320 0323 -Sean McCarthy -- Webmaster - HealthObjects [EMAIL PROTECTED] 410 895 0379 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: Efax from ColdFusion?
eFax is for receiving faxes - not sending them. The eFax software can send faxes, but I don't think you can link into it. You could get software that will fax docs in a bin at regular intervals and then use CF to write files to that bin... I'll bet there's also software that will integrate directly if you look for it... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Ian Lurie [mailto:ian;portentinteractive.com] Sent: Monday, November 11, 2002 1:58 PM To: CF-Talk Subject: Efax from ColdFusion? Anyone out there used ColdFusion to connect to eFax? We've got a client who needs to fax info by clicking a link/button on a web page... -- Portent Interactive Effective web sites through Conversation Marketing http://www.portentinteractive.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Self submitting Corm inside CFIF question...(More JavaScrip t than CF)
something I noticed a while back is that Netscape requires the HTML comment symbols between the script tags like so: SCRIPT LANGUAGE=JavaScript !-- //-- /SCRIPT I doubt if this is your problem, but I know that in slightly earlier versions their absence would give JS errors even though the JS would still execute. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Les Mizzell [mailto:lesmizz;bellsouth.net] Sent: Wednesday, October 30, 2002 12:44 PM To: CF-Talk Subject: Self submitting Corm inside CFIF question...(More JavaScript than CF) Have a small form problem I need some assistance with I have a form that needs to submit itself with no user interaction (it's on a processing page that the user never sees that passes variables off to Verisign for a product payment). There are actually 4 forms, but each is contained inside a Cold Fusion if statement to determine which one, and only one, gets submitted Abbreviated code below. There's 4 of these blocks on the page: cfif url.ID eq 1year form name=cart method=POST action=https://payflowlink.verisign.com/payflowlink.cfm; form variables and such here /form script type=text/javascriptdocument.cart.submit()/script /cfif This automatically submits the form without having to push a submit button or anything It's working great in I.E. Bombs in Netscape 7. These don't work either script type=text/javascriptdocument.forms[0].submit()/script script type=text/javascriptdocument.forms['cart'].submit()/script What do I need to do differently to get this to function in both? Thanks... ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
(another) Bug in CFMX - incorrect translation of binary data
When retrieving binary data from the DB it should be displayed as a hex string where there are two hex digits for each byte of binary data. Whatever method CFMX is using to convert the bytes to a hex character string is not working correctly. I know the data is good and can successfully write and retrieve data using Java so I know the issue is with CFMX. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 16, 2002 10:17 AM To: CF-Talk Subject: Re: Bug in CFMX - MM JDBC Driver for Sybase On Wednesday, Oct 16, 2002, at 05:38 US/Pacific, Dick Applebaum wrote: I want to report a bug in Macromedia's JDBC driver for Sybase Bear in mind that we didn't write any of the drivers - they are all third-party. So it's not 'our' bug per se. My problem is that I am using CFMX on Mac OS X -- an unsupported platform -- but the bug is in Macromedia's JDBC driver. If anyone using Sybase on a supported platform would like to use Dick's code to reproduce this and then file a bug through the standard web form, I'm sure we'd all be grateful! Thanx! I can smell your brains! -- Mittens the Kitten : http://www.matazone.co.uk/theotherside.html ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: SQL HELP
trimming the value won't help. Numeric IDs are faster however. The DB pads chars with spaces when comparing anyway. Try this: SELECT* FROM temptblJOBEVL t LEFT OUTER JOIN tblEmployee tt ON t.sys_emp_id_nr = tt.emp_id_nr WHEREtt.emp_ID_nr IS NULL +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 11:09 AM To: CF-Talk Subject: Re: SQL HELP Ltrim(rtrim()) might help, though... On 10/15/02 6:03 AM, Joshua Tipton [EMAIL PROTECTED] wrote: The column is char 10 when I change it to int it truncates my numbers so I do not want that. Josh -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 8:59 AM To: CF-Talk Subject: RE: SQL HELP yes it may - unless you put ltrim(rtrim()) around the field values - change to an int and see what hapens -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: 15 October 2002 13:52 To: CF-Talk Subject: RE: SQL HELP Both char(10) I can change them to int is you think it would make a difference. -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 8:44 AM To: CF-Talk Subject: RE: SQL HELP shouldn't make a difference. What field type is emp_id in table tblemployee? Is it the same as SYS_EMP_ID_NR in temptblJOBEVL? Are they integers? Your syntax looks fine to me. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: 15 October 2002 13:38 To: CF-Talk Subject: RE: SQL HELP first of all I don't think you need the first () try this. SELECT * FROM temptblJOBEVL WHERE SYS_EMP_ID_NR NOT IN (SELECT emp_id_nr FROM tblemployee) tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 8:40 AM To: CF-Talk Subject: SQL HELP For some unknown reason this query does not work correctly even though I know that there is data in temptbljobevl that does not match tblemployee data. Can someone please help me do this via a join. Thanks, Joshua Tipton SELECT * FROM temptblJOBEVL WHERE (SYS_EMP_ID_NR NOT IN (SELECT emp_id_nr FROM tblemployee)) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: help with SQL 'IN' operator
First: put a comma before and after the list you are inserting into the DB. So a list of 1,2,3,4 becomes ,1,2,3,4, Second: use this query: cfquery name=query datasource=#request.DB_DSN# dbtype=#request.DB_type# username=#request.DB_username# password=#request.DB_password# SELECT title FROM content WHERE keywordIDs LIKE '%,23,%' AND keywordIDs LIKE '%,12,%' /cfquery +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Gyrus [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 11:14 AM To: CF-Talk Subject: OT: help with SQL 'IN' operator I'm trying to run a query than uses the IN operator in a way I've not come across before: cfquery name=query datasource=#request.DB_DSN# dbtype=#request.DB_type# username=#request.DB_username# password=#request.DB_password# SELECT title FROM content WHERE 23 IN (keywordIDs) AND 12 IN (keywordIDs) /cfquery So, instead of saying WHERE [a certain field] IN ([comma-separated list of dynamic values]), I'm looking for records where a dynamic value is IN a field that contains a comma-separated list of values. I get the error Data type mismatch in criteria expression. I guess this might be an invalid use of IN (i.e. you can only use it with the DB field on the left of the operator). Doesn't seem like something that should be invalid - but if it is, how can I achieve the same query? Gyrus [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net PGP key available ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
CFMX - binary data in query
Has anyone else had trouble retrieving and displaying binary data from a database using CFMX? If an Oracle column is defined as: colName raw(2) then you can insert data into that row like so: INSERT INTO table VALUES( '12AB' ) where 12AB represents 2 bytes (one hex number for every 4 bits) But CFMX is doing something that causes it to be displayed funky after retrieval even though it looks fine when I look directly in the DB. Anyone know why??? Anyone? +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: CFMX - binary data in query
We've spoken to the vendor directly and they deny that any conversion takes place in their JDBC driver. I believe them since we have applications running against the same data using JDBC and also ODBC that do not fail. When using JDBC directly we use the getBytes() method then convert each byte one at a time... I suspect there is a bug in the way that CFMX is converting the byte array to a string. Can anyone confirm or deny this? +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Jared Clinton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 4:03 PM To: CF-Talk Subject: RE: CFMX - binary data in query Bryan, Every time I have seen this before, it is the fault of the database drivers in question, not the CF engine. Maybe? Jared Clinton NEC Australia -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 16 October 2002 9:05 AM To: CF-Talk Subject: CFMX - binary data in query Has anyone else had trouble retrieving and displaying binary data from a database using CFMX? If an Oracle column is defined as: colName raw(2) then you can insert data into that row like so: INSERT INTO table VALUES( '12AB' ) where 12AB represents 2 bytes (one hex number for every 4 bits) But CFMX is doing something that causes it to be displayed funky after retrieval even though it looks fine when I look directly in the DB. Anyone know why??? Anyone? +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: copying db info with cf
Why not just set up replication between the databases to keep them in sync? +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Cornillon, Matthieu [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 10, 2002 10:20 AM To: CF-Talk Subject: copying db info with cf Hi. I work on a site that has development, preview/testing, and production environments. These are fully independent right down to the database environments. It's all Oracle on the back end. I've taken care that the data structure is identical from environment to environment. However, the data itself is a little trickier. Some of it is basic data that I set up when the tables are established. But some stuff gets entered later, and I am trying to figure out a clever way to move data from one of the db environments to another. I could, of course, pull the data, try to have cf spit out sql statements that I then paste into another page, but I am wondering whether there is some smarter way? I am imagining some simple export format that I import on the other boxes. Note: this is probably obvious, but just in case: the CF servers are all independent, so no CF code can access another server's DBs. Thanks, Matthieu Pfizer Information Center ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: CFGRID: can't get .class file
it looks to me like you shouldn't be looking in C:\Inetpub\wwwroot\cfide\classes\cfjava.cab but rather in C:\Inetpub\wwwroot\cfide\classes\CFJava2.jar +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 10, 2002 10:35 AM To: CF-Talk Subject: CFGRID: can't get .class file CF5 Enterprise, Win2K Pro OK, I'm having a little problem with CFGRID. The code is fine, but the OBJECT tag created by CFGRID doesn't match up to the files on the server: Here's the output: OBJECT CLASSID=clsid:8AD9C840-044E-11D1-B3E9-00805F499D93 CODEBASE=/CFIDE/classes/cf-j2re-win.cab STANDBY=First use of this control. Configuring browser. Please wait... WIDTH=100% HEIGHT=50% PARAM NAME=CODE VALUE=allaire.controls2.CFGridApplet.class PARAM NAME=ARCHIVE VALUE=/CFIDE/classes/CFJava2.jar .more stuff Now, when I go to C:\Inetpub\wwwroot\cfide\classes\cf-j2re-win.cab, it's there. When I go to C:\Inetpub\wwwroot\cfide\classes\cfjava.cab and open it up with WinZip, there is an allaire\controls\ directory, but the first CFPARAM from above make it look like it's after a directory called controls2 Has anyone else had this problem? Is there a fix? Thanks Pete ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: multiple case values in switch statement in cfscript
yes, but not exactly as you hoped... Keep in mind that when a case evaluates to true, CF will execute EVERYTHING until it finds a break statement... so this would do what you want... cfscript switch( someVal ){ case a: case b: case c: case d: case e: [execute some code] break; } +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 10, 2002 9:11 AM To: CF-Talk Subject: multiple case values in switch statement in cfscript Hi Could anyone tell me if its possible to define multiple case statements In a switch block in cfscript.. So a cfscript version of : cfcase = a,b,c,d,e Thanks Kola ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Comma-Space as delimiter
You can't. You must use replace() to replace the comma/space with a single character that you can use as the delimiter. The bell character works well since it can't be typed (chr(7)). +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Bruce Holm [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 10:45 AM To: CF-Talk Subject: Comma-Space as delimiter When working with Lists, I'm finding that you can't specify a delimiter of comma-space (, ). CF is treating this as , OR . How do I tell it to delimit as comma-space? The ListAppend function in the Reference states you can use , CHR(32) in the delimiter parameter but it doesn't work. -- Bruce Holm Web Developer Lattice Semiconductor [EMAIL PROTECTED] -- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Can I pass variable to a form on the same page?
I highly recommend using CFINCLUDE in a situation like this. It's much simpler. Have your form submit to some action page that simply does this: CFINCLUDE template=../#form.fiscalyear#/#form.statecode#.cfm +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Mitko Gerensky-Greene [mailto:[EMAIL PROTECTED]] Sent: Friday, October 04, 2002 9:56 AM To: CF-Talk Subject: Can I pass variable to a form on the same page? Hello, I have a page with a form with two drop down menus -- for state and fiscal year. I want the action (target) of the form to be a page whose directory is defined by the fiscal year selected and whose file name is defined by the state selected. I.e. from select_plan.cfm (the page with the form) I want to be able to go to /fy2002/va.cfm if Fiscal Year 2002 and Virginia were selected from the menu options in the form. I understand that I cannot have the following: form action=file=/#fiscalyear#/#statecode#.cfm method=post name=info where both fiscalyear and statecode are selected in this same form. How can I implement this? Thanks in advance, Mitko ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
OT topics and posts about OT topics and posts about OT topics
sorry, had to do it! +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED]] Sent: Friday, October 04, 2002 8:50 AM To: CF-Talk Subject: OT topics and posts about OT topics Seems like there are more posts about Off topic posts and also the off topic posts them selves on this list than ever before. While I enjoy OT post as much as anyone, I highly value this list for its on topic info. My idea is a voting system where after about 20 or so list member votes, via a link at the bottom of all of the posts, would cause the thread to be moved to another list or to block the topic entirely. This idea is just another way that this list could police itself. I have brought the idea up once before, and this will be the last time I bring it up. Thanks Mark W. Breneman -Macromedia Certified ColdFusion Developer -Network / Web Server Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: loop problems
use IN instead of = CFQUERY NAME=fullcheckquery DATASOURCE=brinventory SELECT Steel.width, Steel.weight, Steel.length, Steel.quantity, Steel.price, location.location, lookup.type, lookup2.type as smalltype, method.method, size_lookup.size_type FROMSteel, location, lookup, lookup2, method, size_lookup WHERE steel.type_id = lookup.type_id AND steel.typeid = lookup2.typeid AND steel.size_id = size_lookup.size_id AND steel.location_id = location.location_id AND steel.method_id = method.method_id AND lookup.type_id IN (Select type_id from lookup where lookup.type = '#form.steeltype#') /CFQUERY +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Webmaster [mailto:[EMAIL PROTECTED]] Sent: Friday, October 04, 2002 11:35 AM To: CF-Talk Subject: loop problems This is the query I am running but because I have multiple entries going in to this form that gets submitted. The bottom part of query does not work because it is a list how do I get it to look at each individual record and loop through for each one? CFQUERY NAME=fullcheckquery DATASOURCE=brinventory SELECT Steel.width, Steel.weight, Steel.length, Steel.quantity, Steel.price, location.location, lookup.type, lookup2.type as smalltype, method.method, size_lookup.size_type FROMSteel, location, lookup, lookup2, method, size_lookup WHERE steel.type_id = lookup.type_id AND steel.typeid = lookup2.typeid AND steel.size_id = size_lookup.size_id AND steel.location_id = location.location_id AND steel.method_id = method.method_id AND lookup.type_id = (Select type_id from lookup where lookup.type = '#form.steeltype#') /CFQUERY CFLOOP QUERY=fullcheckquery CFIF (form.steeltype EQ fullcheckquery.type) AND (form.type EQ fullcheckquery.smalltype) AND (form.width EQ fullcheckquery.width) AND (form.weight EQ fullcheckquery.weight) AND (form.length EQ fullcheckquery.length) AND (form.price EQ fullcheckquery.price) AND (form.location EQ fullcheckquery.location) CFQUERY DATASOURCE=brinventory NAME=update SELECT steel.id, steel.quantity FROMSteel, lookup, lookup2, location WHERE steel.type_id = lookup.type_id AND steel.typeid = lookup2.typeid AND steel.location_id = location.location_id AND lookup.type_id = (Select type_id from lookup where lookup.type = '#form.steeltype#') AND lookup2.typeid = (Select typeid from lookup2 where lookup2.type = '#form.type#') AND Steel.width = '#form.width#' AND Steel.weight = '#form.weight#' AND Steel.length = '#form.length#' AND steel.price = '#form.price#' AND location.location_id = (Select location_id from location where location.location = '#form.location#') /CFQUERY CFSET setquantity =update.quantity + form.quantity CFQUERY DATASOURCE=brinventory NAME=update UPDATE Steel SET quantity = #setquantity# WHERE steel.id = #update.id# /CFQUERY CFELSE CFOUTPUTThis is a new entrie!/CFOUTPUT /CFIF /CFLOOP ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.