Re: Open Source Shopping Cart Coding Guidelines

2005-11-20 Thread Sean Corfield
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

Re: Open Source Shopping Cart Coding Guidelines

2005-11-20 Thread Sean Corfield
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

wraptext in cfmail

2005-11-20 Thread Johnny Le
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

Grouping problems

2005-11-20 Thread Will Tomlinson
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

RE: Grouping problems

2005-11-20 Thread Justin D. Scott
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

Re: Open Source Shopping Cart Coding Guidelines

2005-11-20 Thread John C. Bland II
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! --

Re: Grouping problems

2005-11-20 Thread Will Tomlinson
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

Re: Grouping problems

2005-11-20 Thread Will Tomlinson
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

RE: Grouping problems

2005-11-20 Thread Jennifer Gavin-Wear
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

Re: Grouping problems

2005-11-20 Thread Will Tomlinson
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,

RE: Grouping problems

2005-11-20 Thread Jennifer Gavin-Wear
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]

RE: wraptext in cfmail

2005-11-20 Thread Matthew Walker
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

Re: Grouping problems

2005-11-20 Thread Will Tomlinson
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

Re: wraptext in cfmail

2005-11-20 Thread Johnny Le
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-

RE: wraptext in cfmail

2005-11-20 Thread Matthew Walker
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

RE: Grouping problems

2005-11-20 Thread Jennifer Gavin-Wear
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,

Re: Grouping problems

2005-11-20 Thread Will Tomlinson
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

RE: Grouping problems

2005-11-20 Thread Jennifer Gavin-Wear
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

Re: Grouping problems

2005-11-20 Thread Will Tomlinson
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

RE: Grouping problems

2005-11-20 Thread Jennifer Gavin-Wear
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

Re: Grouping problems

2005-11-20 Thread Will Tomlinson
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

Re: Grouping problems

2005-11-20 Thread Will Tomlinson
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

Re: Grouping problems

2005-11-20 Thread dave
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

CFMX 7 CFMODULE

2005-11-20 Thread ColdFusion Developer
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

Re: Grouping problems

2005-11-20 Thread Will Tomlinson
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%

RE: Grouping problems

2005-11-20 Thread Bobby Hartsfield
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

Re: Grouping problems

2005-11-20 Thread Will Tomlinson
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

RE: Grouping problems

2005-11-20 Thread dave
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

RE: Grouping problems

2005-11-20 Thread Jennifer Gavin-Wear
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

RE: CFMX 7 CFMODULE

2005-11-20 Thread Matthew Walker
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

RE: happy bday will!

2005-11-20 Thread Jennifer Gavin-Wear
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

RE: CFMX 7 CFMODULE

2005-11-20 Thread ColdFusion Developer
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

Re: happy bday will!

2005-11-20 Thread Will Tomlinson
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:

Re: happy bday will!

2005-11-20 Thread Dana
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

RE: happy bday will!

2005-11-20 Thread Peter Tilbrook
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! :)

RE: Grouping problems

2005-11-20 Thread Jennifer Gavin-Wear
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:

RE: CFMX 7 CFMODULE

2005-11-20 Thread Matthew Walker
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

Re: Grouping problems

2005-11-20 Thread Will Tomlinson
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