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
 
 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: 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

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

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 
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

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 :-)

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

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,
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

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]
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: 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 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: 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, 
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

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 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

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
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

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 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

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





~|
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

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 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

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

~|
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

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 
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


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%
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

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 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

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 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

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 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

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 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: 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: 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: 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 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