>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
ubject: 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
ECTED]
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
~~~
5 PM
To: CF-Talk
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: G
>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
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
>>>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%
: Will Tomlinson <[EMAIL PROTECTED]>
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
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
~
>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
>>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
~~~
>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 da
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
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 err
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.tblSKUoptio
>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
]
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, tbl
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,
tblSK
rack 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 pr
>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
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=
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
> Su
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
23 matches
Mail list logo