Re: Open Source Shopping Cart Coding Guidelines
On 11/19/05, John C. Bland II [EMAIL PROTECTED] wrote: Is there an equivalent for Flash (AS 2.0), Flex, and CF 7? http://www.macromedia.com/devnet/flash/whitepapers/actionscript_standards.pdf Not sure about Flex. I would suggest looking at Cairngorm (a micro-architecture framework that proscribes certain best practices) and the Developing Rich Clients with Macromedia Flex book: http://www.amazon.com/exec/obidos/tg/detail/-/0321255666?v=glance The coding guidelines I mentioned are for CFMX 7 (despite the link's title - I need to update that!): On 11/18/05, Sean Corfield [EMAIL PROTECTED] wrote: http://livedocs.macromedia.com/wtg/public/ There's also some non-Mach II guidelines about OO design in the Mach II Development Guide (also at that link). -- Sean A Corfield -- http://corfield.org/ Got frameworks? If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224751 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: Open Source Shopping Cart Coding Guidelines
On 11/20/05, Sean Corfield [EMAIL PROTECTED] wrote: The coding guidelines I mentioned are for CFMX 7 (despite the link's title - I need to update that!): Fixed. The links now correctly say ColdFusion MX 7! -- Sean A Corfield -- http://corfield.org/ Got frameworks? If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224752 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
wraptext in cfmail
Hi, When I specified wraptext=72 in cfmail, the first line of a paragraph in email message seems to cut off a lot shorter than 72. The rest of the paragraph looks fine. I don't seem to be able to fix it. When I use the wrap() function, I get the same problem. Please help! Johnny ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224753 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
Grouping problems
I always have a hard time grouping my queries and usually resort to the group attribute in cfoutput. Once again, it's not showing me what I need. I think it'd be best to group in the SQL before I even output it but don't know exactly how to do it without making things worse. What I need to do is show the combined product options with their prices in a select, ordered the way I want. What I've currently got *works*, but it isn't ordered properly. You can see it here: http://wtomlinson.com/newcart/productdetail.cfm?PID=114 Here's my query: cfquery name=getproductoptions datasource=#VARIABLES.DSN# SELECT tblSKUS.SKUID, tblSKUS.merchSKUID, tblSKUS.SKU_prodID, tblSKUS.SKUprice,tblSKUoptions_rel.optionID, tblSKUoptions_rel.optionSKUID, tblSKUoptions_rel.option_optionID, tblSKUoptions.SKUoptionID, tblSKUoptions.SKUoptionname, tblSKUoptions.SKUoptionsort FROM tblSKUS, tblSKUoptions_rel, tblSKUoptions WHERE tblSKUS.SKU_prodID = #ARGUMENTS.PRODID# AND tblSKUS.SKUID = tblSKUoptions_rel.optionSKUID AND tblSKUoptions_rel.option_optionID = tblSKUoptions.SKUoptionID /cfquery Here's the output: cfif getproductoptions.recordcount NEQ 0 select option(s): cfselect name=optionID cfoutput query=getProductOptions group=optionSKUID option value=#SKUID#cfoutput#SKUoptionname#nbsp;/cfoutput #DollarFormat(SKUprice)#/option /cfoutput /cfselect Thanks, Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224754 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: Grouping problems
Hi Will, if you add an ORDER BY to your query on the field(s) you want to group on it will usually take care of this problem. -Justin -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Sunday, November 20, 2005 12:44 PM To: CF-Talk Subject: Grouping problems I always have a hard time grouping my queries and usually resort to the group attribute in cfoutput. Once again, it's not showing me what I need. I think it'd be best to group in the SQL before I even output it but don't know exactly how to do it without making things worse. What I need to do is show the combined product options with their prices in a select, ordered the way I want. What I've currently got *works*, but it isn't ordered properly. You can see it here: http://wtomlinson.com/newcart/productdetail.cfm?PID=114 Here's my query: cfquery name=getproductoptions datasource=#VARIABLES.DSN# SELECT tblSKUS.SKUID, tblSKUS.merchSKUID, tblSKUS.SKU_prodID, tblSKUS.SKUprice,tblSKUoptions_rel.optionID, tblSKUoptions_rel.optionSKUID, tblSKUoptions_rel.option_optionID, tblSKUoptions.SKUoptionID, tblSKUoptions.SKUoptionname, tblSKUoptions.SKUoptionsort FROM tblSKUS, tblSKUoptions_rel, tblSKUoptions WHERE tblSKUS.SKU_prodID = #ARGUMENTS.PRODID# AND tblSKUS.SKUID = tblSKUoptions_rel.optionSKUID AND tblSKUoptions_rel.option_optionID = tblSKUoptions.SKUoptionID /cfquery Here's the output: cfif getproductoptions.recordcount NEQ 0 select option(s): cfselect name=optionID cfoutput query=getProductOptions group=optionSKUID option value=#SKUID#cfoutput#SKUoptionname#nbsp;/cfoutput #DollarFormat(SKUprice)#/option /cfoutput /cfselect Thanks, Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224755 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: Open Source Shopping Cart Coding Guidelines
Ahh coo...thanks Sean. On 11/20/05, Sean Corfield [EMAIL PROTECTED] wrote: On 11/20/05, Sean Corfield [EMAIL PROTECTED] wrote: The coding guidelines I mentioned are for CFMX 7 (despite the link's title - I need to update that!): Fixed. The links now correctly say ColdFusion MX 7! -- Sean A Corfield -- http://corfield.org/ Got frameworks? If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224756 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: Grouping problems
ok, you'll need to click on ColdFusion Tshirt under featured products. Thanks, Will ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224757 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: Grouping problems
Hi Will, if you add an ORDER BY to your query on the field(s) you want to group on it will usually take care of this problem. Justin, that's the first thing I tried but it made things get wacky in the select menu. It added menu items - an item for small, for black, etc... along with all the correct ones. Thanks, Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224758 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: Grouping problems
Hi Will, So you have three tables included in the group report, what are you linking the tables on? I'm guessing you need inner or outer joins. If you post your main fields for each of the three tables, especially with the primary id field you are using to link them and I'll have a crack at it :-) Jenny -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: 20 November 2005 17:53 To: CF-Talk Subject: Re: Grouping problems Hi Will, if you add an ORDER BY to your query on the field(s) you want to group on it will usually take care of this problem. Justin, that's the first thing I tried but it made things get wacky in the select menu. It added menu items - an item for small, for black, etc... along with all the correct ones. Thanks, Will ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224759 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: Grouping problems
Thanks much Jennifer! Here's my schema for these three tables: http://wtomlinson.com/cartcap.jpg Here's my current query showing the fields I'm using: SELECT tblSKUS.SKUID, tblSKUS.merchSKUID, tblSKUS.SKU_prodID, tblSKUS.SKUprice, tblSKUoptions_rel.optionID, tblSKUoptions_rel.optionSKUID, tblSKUoptions_rel.option_optionID, tblSKUoptions.SKUoptionID, tblSKUoptions.SKUoptionname, tblSKUoptions.SKUoptionsort FROM tblSKUS, tblSKUoptions_rel, tblSKUoptions WHERE tblSKUS.SKU_prodID = #ARGUMENTS.PRODID# AND tblSKUS.SKUID = tblSKUoptions_rel.optionSKUID AND tblSKUoptions_rel.option_optionID = tblSKUoptions.SKUoptionID Thanks, Will ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224760 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: Grouping problems
Will, Ok, cool, and where is the link between the tables pls? ie .. scenario .. Customers table .. customerid invoices table .. invoiceid / customerid link is on customerid .. so where are the links on your tables? J -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: 20 November 2005 19:31 To: CF-Talk Subject: Re: Grouping problems Thanks much Jennifer! Here's my schema for these three tables: http://wtomlinson.com/cartcap.jpg Here's my current query showing the fields I'm using: SELECT tblSKUS.SKUID, tblSKUS.merchSKUID, tblSKUS.SKU_prodID, tblSKUS.SKUprice, tblSKUoptions_rel.optionID, tblSKUoptions_rel.optionSKUID, tblSKUoptions_rel.option_optionID, tblSKUoptions.SKUoptionID, tblSKUoptions.SKUoptionname, tblSKUoptions.SKUoptionsort FROM tblSKUS, tblSKUoptions_rel, tblSKUoptions WHERE tblSKUS.SKU_prodID = #ARGUMENTS.PRODID# AND tblSKUS.SKUID = tblSKUoptions_rel.optionSKUID AND tblSKUoptions_rel.option_optionID = tblSKUoptions.SKUoptionID Thanks, Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224761 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: wraptext in cfmail
I believe the problem is that the counter doesn't reset when manual line breaks are encountered. So if you start Dear Qwerty, then those 12 characters count toward the line length of the next line. -Original Message- From: Johnny Le [mailto:[EMAIL PROTECTED] Sent: Monday, 21 November 2005 7:31 a.m. To: CF-Talk Subject: wraptext in cfmail Hi, When I specified wraptext=72 in cfmail, the first line of a paragraph in email message seems to cut off a lot shorter than 72. The rest of the paragraph looks fine. I don't seem to be able to fix it. When I use the wrap() function, I get the same problem. Please help! Johnny ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224762 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: Grouping problems
Will, Ok, cool, and where is the link between the tables pls? ie .. scenario .. Customers table .. customerid invoices table .. invoiceid / customerid link is on customerid .. so where are the links on your tables? tblSKUS tableSKUID tblSKUOptions_rel optionID/optionSKUID link is on optionSKUID tblSKUOptions SKUOptionID tblSKUOptions_rel optionID/option_optionID link is on option_optionID Thanks,Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224763 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: wraptext in cfmail
Yep, that is exactly my problem. So what is the solution? Johnny I believe the problem is that the counter doesn't reset when manual line breaks are encountered. So if you start Dear Qwerty, then those 12 characters count toward the line length of the next line. -Original Message- From: Johnny Le [mailto:[EMAIL PROTECTED] Sent: Monday, 21 November 2005 7:31 a.m. To: CF-Talk Subject: wraptext in cfmail Hi, When I specified wraptext=72 in cfmail, the first line of a paragraph in email message seems to cut off a lot shorter than 72. The rest of the paragraph looks fine. I don't seem to be able to fix it. When I use the wrap() function, I get the same problem. Please help! Johnny ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224764 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: wraptext in cfmail
Perhaps this? http://www.cflib.org/udf.cfm?ID=249 You'll need to rename the function as wrap() is now reserved. -Original Message- From: Johnny Le [mailto:[EMAIL PROTECTED] Sent: Monday, 21 November 2005 10:02 a.m. To: CF-Talk Subject: Re: wraptext in cfmail Yep, that is exactly my problem. So what is the solution? Johnny I believe the problem is that the counter doesn't reset when manual line breaks are encountered. So if you start Dear Qwerty, then those 12 characters count toward the line length of the next line. -Original Message- From: Johnny Le [mailto:[EMAIL PROTECTED] Sent: Monday, 21 November 2005 7:31 a.m. To: CF-Talk Subject: wraptext in cfmail Hi, When I specified wraptext=72 in cfmail, the first line of a paragraph in email message seems to cut off a lot shorter than 72. The rest of the paragraph looks fine. I don't seem to be able to fix it. When I use the wrap() function, I get the same problem. Please help! Johnny ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224765 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: Grouping problems
Hi Will, Try this out, hope it sorts things for you :-) Jenny SELECT dbo.tblSKUS.SKUID, dbo.tblSKUS.merchSKUID, dbo.tblSKUS.SKU_prodID, dbo.tblSKUS.SKUprice, dbo.tblSKUoptions.SKUoptionname, dbo.tblSKUoptions.SKUoptionsort, dbo.tblSKUoptions.SKUoptionID, dbo.tblSKUoptions_rel.optionID, dbo.tblSKUoptions_rel.optionSKUID, dbo.tblSKUoptions_rel.option_optionID FROM dbo.tblSKUoptions_rel RIGHT OUTER JOIN dbo.tblSKUoptions ON dbo.tblSKUoptions_rel.optionID = dbo.tblSKUoptions.SKUoptionID RIGHT OUTER JOIN dbo.tblSKUS ON dbo.tblSKUoptions.SKUoptionID = dbo.tblSKUS.SKUID WHERE (dbo.tblSKUS.SKU_prodID = #ARGUMENTS.PRODID#) GROUP BY dbo.tblSKUS.SKUID, dbo.tblSKUS.merchSKUID, dbo.tblSKUS.SKU_prodID, dbo.tblSKUS.SKUprice, dbo.tblSKUoptions.SKUoptionname, dbo.tblSKUoptions.SKUoptionsort, dbo.tblSKUoptions.SKUoptionID, dbo.tblSKUoptions_rel.optionID, dbo.tblSKUoptions_rel.optionSKUID, dbo.tblSKUoptions_rel.option_optionID ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224766 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: Grouping problems
Thanks much Jennifer! I'm gettin' a db error but don't have time to work with it til later tonight. I don't spot the problem at first glance. Here's the error: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'dbo.tblSKUoptions_rel.optionID = dbo.tblSKUoptions.SKUoptionID RIGHT OUTER JOIN dbo.tblSKUS ON dbo.tblSKUoptions.SKUoptionID = dbo.tblSKUS.SKUID'. Here's the generated SQL statement: SELECT dbo.tblSKUS.SKUID, dbo.tblSKUS.merchSKUID, dbo.tblSKUS.SKU_prodID, dbo.tblSKUS.SKUprice, dbo.tblSKUoptions.SKUoptionname,dbo.tblSKUoptions.SKUoptionsort, dbo.tblSKUoptions.SKUoptionID,dbo.tblSKUoptions_rel.optionID, dbo.tblSKUoptions_rel.optionSKUID, dbo.tblSKUoptions_rel.option_optionID FROM dbo.tblSKUoptions_rel RIGHT OUTER JOIN dbo.tblSKUoptions ON dbo.tblSKUoptions_rel.optionID = dbo.tblSKUoptions.SKUoptionID RIGHT OUTER JOIN dbo.tblSKUS ON dbo.tblSKUoptions.SKUoptionID = dbo.tblSKUS.SKUID WHERE (dbo.tblSKUS.SKU_prodID = 114) GROUP BY dbo.tblSKUS.SKUID, dbo.tblSKUS.merchSKUID, dbo.tblSKUS.SKU_prodID, dbo.tblSKUS.SKUprice, dbo.tblSKUoptions.SKUoptionname, dbo.tblSKUoptions.SKUoptionsort, dbo.tblSKUoptions.SKUoptionID, dbo.tblSKUoptions_rel.optionID, dbo.tblSKUoptions_rel.optionSKUID, dbo.tblSKUoptions_rel.option_optionID Thanks, Will ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224767 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: Grouping problems
Hi Will, I built the query using MS SQL, but as far as i can see the code is pretty standard. One comment i would make is re. the naming of your id fields. When I create relational databases I always use the same name for the ID on which you will link the tables. Scenario - customers, invoices Customer table - CustomerID, Address, customer details ... Invoice Table - InvoiceID, CustomerID, invoice details ... This would make it much easier for you to see where links are happening. Also, make sure you set the same data types and paramaters on the link field. On MS SQL I use Int data type (whenever possible), been a while since I used access. Last of all, you should avoid running complex queries in CF. On your own example, build and run the query in access and only use CF for the where clauses. Once you have the query built in Access/MS SQL when you access it from CF you are effectively handling one table of data. So doing searches on it is very easy, and it will run much faster and leaner this way. Here's a link I found to Access and relational databases http://www.utexas.edu/its/windows/database/access/start.html#rel Good luck! Jenny ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224768 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: Grouping problems
One comment i would make is re. the naming of your id fields. When I create relational databases I always use the same name for the ID on which you will link the tables. Yeah I agree! I borrowed this db design from Cartweaver and never changed them over. Also, make sure you set the same data types and paramaters on the link field. These are all ok On MS SQL I use Int data type (whenever possible), been a while since I used access. I'm usin access to prototype this thang. Then will change over to sql server Last of all, you should avoid running complex queries in CF. On your own example, build and run the query in access and only use CF for the where clauses. Good luck! Jenny Thanks a ton jenny! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224769 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: Grouping problems
I'm usin access to prototype this thang. Then will change over to sql server Will, make the move now and save yourself a ton of work! I used Access for a long while, many moons ago, but it's not a serious product (ok Access fans, shoot me down in flames). Jenny ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224770 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: Grouping problems
Will, make the move now and save yourself a ton of work! Jenny! I aint gunna use it! lol I just mess round with it for testing. Dave loves access! He's probably gonna come in and attack you! Will ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224771 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: Grouping problems
Just trying to protect you jenny. dave the disruptured is an access fanatic. I heard they called him Captain Access back home. Please be warned that he'll protect it more than even his own family! I'll go on record and say access SUCKS! I'm sorry dave, it just does! Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224772 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: Grouping problems
when you are talking about will, access is about his speed. a lil bit too fast but for a blue bus kid borrowed the code from cartweaver huh? you mean stole it, since you are the king of code thieves.. It's funny how you steal something, actually copy paste and you still mess it up lol Yup I love access, oh hell, i just LOVE microsoft products!!! The best SHIT ever made (least the shit part is the right) And access purrs like a kitten on my mac... (a dead kitten that is) So tell us the story about your parents dog HAHAHAHA ok ppl help the blue bus kid and go buy one of will's shirts, so he can go buy codelifter (dont be a connie!!) ~Dave the disruptor~ good sites - make money getting rid of ie :) http://explorerdestroyer.com/ http://www.killbillsbrowser.com/ From: Will Tomlinson [EMAIL PROTECTED] Sent: Sunday, November 20, 2005 6:48 PM To: CF-Talk cf-talk@houseoffusion.com Subject: Re: Grouping problems Will, make the move now and save yourself a ton of work! Jenny! I aint gunna use it! lol I just mess round with it for testing. Dave loves access! He's probably gonna come in and attack you! Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224773 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
CFMX 7 CFMODULE
Does anyone know why a CFMODULE call does not perform the same as it did on CF5 and CF6.1 ? In CFMX7 it is as if the call never happens. Thanks! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224774 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: Grouping problems
I'm usin access to prototype this thang. Then will change over to sql server Ok girl! It's a sql server db now. You happy?? :) Will ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224775 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: Grouping problems
Now you have to tell us about the dog... lol ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Sunday, November 20, 2005 7:00 PM To: CF-Talk Subject: Re: Grouping problems when you are talking about will, access is about his speed. a lil bit too fast but for a blue bus kid borrowed the code from cartweaver huh? you mean stole it, since you are the king of code thieves.. It's funny how you steal something, actually copy paste and you still mess it up lol Yup I love access, oh hell, i just LOVE microsoft products!!! The best SHIT ever made (least the shit part is the right) And access purrs like a kitten on my mac... (a dead kitten that is) So tell us the story about your parents dog HAHAHAHA ok ppl help the blue bus kid and go buy one of will's shirts, so he can go buy codelifter (dont be a connie!!) ~Dave the disruptor~ good sites - make money getting rid of ie :) http://explorerdestroyer.com/ http://www.killbillsbrowser.com/ From: Will Tomlinson [EMAIL PROTECTED] Sent: Sunday, November 20, 2005 6:48 PM To: CF-Talk cf-talk@houseoffusion.com Subject: Re: Grouping problems Will, make the move now and save yourself a ton of work! Jenny! I aint gunna use it! lol I just mess round with it for testing. Dave loves access! He's probably gonna come in and attack you! Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224776 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: Grouping problems
Now you have to tell us about the dog... lol N!! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224777 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: Grouping problems
if he doesnt i will haha ~Dave the disruptor~ good sites - make money getting rid of ie :) http://explorerdestroyer.com/ http://www.killbillsbrowser.com/ From: Bobby Hartsfield [EMAIL PROTECTED] Sent: Sunday, November 20, 2005 7:45 PM To: CF-Talk cf-talk@houseoffusion.com Subject: RE: Grouping problems Now you have to tell us about the dog... lol ...:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Sunday, November 20, 2005 7:00 PM To: CF-Talk Subject: Re: Grouping problems when you are talking about will, access is about his speed. a lil bit too fast but for a blue bus kid borrowed the code from cartweaver huh? you mean stole it, since you are the king of code thieves.. It's funny how you steal something, actually copy paste and you still mess it up lol Yup I love access, oh hell, i just LOVE microsoft products!!! The best SHIT ever made (least the shit part is the right) And access purrs like a kitten on my mac... (a dead kitten that is) So tell us the story about your parents dog HAHAHAHA ok ppl help the blue bus kid and go buy one of will's shirts, so he can go buy codelifter (dont be a connie!!) ~Dave the disruptor~ good sites - make money getting rid of ie :) http://explorerdestroyer.com/ http://www.killbillsbrowser.com/ From: Will Tomlinson Sent: Sunday, November 20, 2005 6:48 PM To: CF-Talk Subject: Re: Grouping problems Will, make the move now and save yourself a ton of work! Jenny! I aint gunna use it! lol I just mess round with it for testing. Dave loves access! He's probably gonna come in and attack you! Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224778 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: Grouping problems
ROFL ! I'm not getting into an Access war - been there and done it ;) lol And i'm happy if your code is running now, it does ? :-D Jenny p.s. Dave, if you're reading this, I think Access is wonderful ;) rofl -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: 20 November 2005 23:43 To: CF-Talk Subject: Re: Grouping problems I'm usin access to prototype this thang. Then will change over to sql server Ok girl! It's a sql server db now. You happy?? :) Will ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224779 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: CFMX 7 CFMODULE
Cfmodule should work the same in CF7 as in CF6. However, I've had some users of custom tags of mine reporting issues like that. I haven't been able to replicate the issue and for other reasons I've had trouble working with the users to explore the problem. If you use cf_ or cfimport styles to call custom tags do you get the same failure or does it work? -Original Message- From: ColdFusion Developer [mailto:[EMAIL PROTECTED] Sent: Monday, 21 November 2005 1:33 p.m. To: CF-Talk Subject: CFMX 7 CFMODULE Does anyone know why a CFMODULE call does not perform the same as it did on CF5 and CF6.1 ? In CFMX7 it is as if the call never happens. Thanks! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224780 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: happy bday will!
lolol .. happy birthday Will :-) -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: 06 November 2005 21:11 To: CF-Talk Subject: ot: happy bday will! yup ppl its wills bday, I know you all are poor but if we all kick in a couple of bucks we can get him a starter membership to hair club for men!! ;)~ haha hahaha jk... kinda happy bday wilber ~Dave the disruptor~ Some people just don't appreciate how difficult it is to dispense wisdom and abuse at the same time. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224781 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: CFMX 7 CFMODULE
Actually it is a simple call: CFMODULE TEMPLATE=dir_actions.cfm ACTION=LIST DIRECTORY=#REQUEST.DIRECTORY_PATH# The dir_actions.cfm resides in the same directory (there are no subdirectories) And the REQUEST.DIRECTORY_PATH variable is valid and does exists. Inside the tag, it does a simple CFDIRECTORY call and then does a QoQ to sort the directories by name (since CFDIRECTORY does not do that). Then I set the QuerySet to CALLER.THEDIR and nothing is returned. I get the error THEDIR does not exist. -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED] Sent: Sunday, November 20, 2005 7:54 PM To: CF-Talk Subject: RE: CFMX 7 CFMODULE Cfmodule should work the same in CF7 as in CF6. However, I've had some users of custom tags of mine reporting issues like that. I haven't been able to replicate the issue and for other reasons I've had trouble working with the users to explore the problem. If you use cf_ or cfimport styles to call custom tags do you get the same failure or does it work? -Original Message- From: ColdFusion Developer [mailto:[EMAIL PROTECTED] Sent: Monday, 21 November 2005 1:33 p.m. To: CF-Talk Subject: CFMX 7 CFMODULE Does anyone know why a CFMODULE call does not perform the same as it did on CF5 and CF6.1 ? In CFMX7 it is as if the call never happens. Thanks! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224782 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: happy bday will!
lolol .. happy birthday Will :-) awww thanks! :) ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224783 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: happy bday will!
well gee... if that's all it takes to make you happy.. happy birthday! On 11/20/05, Will Tomlinson [EMAIL PROTECTED] wrote: lolol .. happy birthday Will :-) awww thanks! :) ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224784 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: happy bday will!
Same here you old bas.. :) -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Monday, 21 November 2005 10:28 AM To: CF-Talk Subject: Re: happy bday will! lolol .. happy birthday Will :-) awww thanks! :) ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224785 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: Grouping problems
H .. all those lines of pretty sql code ... REALLY would like to know about this dog? lol and if you don't tell, we'll just have to make something up ;) Jenny -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: 20 November 2005 23:51 To: CF-Talk Subject: Re: Grouping problems Now you have to tell us about the dog... lol N!! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224786 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: CFMX 7 CFMODULE
Sure, so what happens if you replace your cfmodule with: CF_dir_actions ACTION=LIST DIRECTORY=#REQUEST.DIRECTORY_PATH# -Original Message- From: ColdFusion Developer [mailto:[EMAIL PROTECTED] Sent: Monday, 21 November 2005 2:15 p.m. To: CF-Talk Subject: RE: CFMX 7 CFMODULE Actually it is a simple call: CFMODULE TEMPLATE=dir_actions.cfm ACTION=LIST DIRECTORY=#REQUEST.DIRECTORY_PATH# The dir_actions.cfm resides in the same directory (there are no subdirectories) And the REQUEST.DIRECTORY_PATH variable is valid and does exists. Inside the tag, it does a simple CFDIRECTORY call and then does a QoQ to sort the directories by name (since CFDIRECTORY does not do that). Then I set the QuerySet to CALLER.THEDIR and nothing is returned. I get the error THEDIR does not exist. -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED] Sent: Sunday, November 20, 2005 7:54 PM To: CF-Talk Subject: RE: CFMX 7 CFMODULE Cfmodule should work the same in CF7 as in CF6. However, I've had some users of custom tags of mine reporting issues like that. I haven't been able to replicate the issue and for other reasons I've had trouble working with the users to explore the problem. If you use cf_ or cfimport styles to call custom tags do you get the same failure or does it work? -Original Message- From: ColdFusion Developer [mailto:[EMAIL PROTECTED] Sent: Monday, 21 November 2005 1:33 p.m. To: CF-Talk Subject: CFMX 7 CFMODULE Does anyone know why a CFMODULE call does not perform the same as it did on CF5 and CF6.1 ? In CFMX7 it is as if the call never happens. Thanks! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224787 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: Grouping problems
H .. all those lines of pretty sql code ... REALLY would like to know about this dog? lol and if you don't tell, we'll just have to make something up ;) Jenny They're pretty, but we needta work on em some more. :) They ain't quite rightchet. I'll post again when I get closer to it tonight. Thanks for your help! NO DOG STORIES!! WIll ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224788 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
