Any ideas guys?
~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187958
Archives:
[quote]Any ideas guys?[/quote]
yeah
he's what u do *
sorry this post has been censored ;)
-- Original Message --
From: Jamie Price [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date: Thu, 16 Dec 2004 18:06:21 -0400
Any ideas guys?
GROUP_CONCAT works only for 4.1+ MySQL versions...
http://dev.mysql.com/doc/mysql/en/GROUP-BY-Functions.html
Cheers
Marco
On Tue, 14 Dec 2004 22:25:14 -0400, Jamie Price [EMAIL PROTECTED] wrote:
Jamie Price wrote:
SELECT o.UserID, GROUP_CONCAT(o.CardID)
FROM mycards t INNER JOIN
Simon - Here's the dumps - the GetMatches dump has never returned results for
me (though it seems like it is doing something since it's outputting results)
GetWantedCards Query - query
CARDID USERID
1 41001101 7
2 41001102 7
3 41001151 7
4 41001152 7
5 41001153 7
GetMatches Query -
OK Jamie
you could migrate to PostgreSQL? Do that...
Cheers
Marco
On Wed, 15 Dec 2004 09:46:18 -0400, Jamie Price [EMAIL PROTECTED] wrote:
Simon - Here's the dumps - the GetMatches dump has never returned results for
me (though it seems like it is doing something since it's outputting
Jamie Price wrote:
SELECT o.UserID, GROUP_CONCAT(o.CardID)
FROM mycards t INNER JOIN mycards o ON t.cardid = o.cardid
WHEREt.trade = 1
AND
o.own = 1
AND
t.UserID = cfqueryparam value=#cUserID#
cfsqltype=cf_sql_integer
GROUP BY o.UserID
I
Hi jamie ... took a look
I know its a bit of a fudge but as SQL's letting you down cant you wrap the
bit that outputs the results in a cfif like this ?
cfif qGetMatches.rowcont NEQ 0
tr ..
/tr
/cfif
Not ideal I know
Simon - Here's the dumps - the GetMatches dump has never
Jochem - that code worked (with some minor adjustment)!
Thanks!
Now, to up the level of complexity a bit. currently it outputs like so:
userid1
cardid1
cardid2
.
.
.
userid2
cardid1
cardid2
In other words it lists the other users with matching cards and then below each
user it lists the
although its a little 'windy' can you cfdump the qGetWantedCards query and post
it ?
also the first and the last 'qGetMatches' cfdumped would be helpful too
Cheers
Simon
GROUP_CONCAT works only for 4.1+ MySQL versions...
http://dev.mysql.com/doc/mysql/en/GROUP-BY-Functions.html
Cheers
Jamie Price wrote:
SELECT o.UserID, GROUP_CONCAT(o.CardID)
FROM mycards t INNER JOIN mycards o ON t.cardid = o.cardid
WHEREt.trade = 1
AND
o.own = 1
AND
t.UserID = cfqueryparam value=#cUserID#
cfsqltype=cf_sql_integer
GROUP BY o.UserID
Jochem
Jamie
what you need?
Cheers
Marco
On Sat, 11 Dec 2004 21:25:39 -0400, Jamie Price [EMAIL PROTECTED] wrote:
I know that this sounds like a pretty wild problem, but I would REALLY
appreciate any help you guys could give - I've been putting my head through a
wall for about two weeks trying
Jamie Price wrote:
...which is close, but no cigar. I need to get rid of those 'blank' entries,
plus I need to arrange it so what's left comes out like this:
Quote:
UserID: 3
Owns Cards: 41001152
UserID: 8
Owns Cards: 41001151
UserID: 9
Owns Cards: 41001151
UserID: 13
I know that this sounds like a pretty wild problem, but I would REALLY
appreciate any help you guys could give - I've been putting my head through a
wall for about two weeks trying to get this function right. If you need
clarification on anything, just let me know. Thanks!
I'm working on a trading card site for an online card game. One of the key
functions of the site will be that a user can login and click on match and
the database will return a 'matching' trader - one that has all the cards the
user needs. I've setup a test version that counts on the user with
I have a query that is giving a generic error and I cannot see what hte problem is ...
below you will see the insert statement and the generic error.This is running on mySQL
3.2x and Windows XP, the #variables.urlRoot# is http://localhost/cfquery
datasource=#form.dsn# name=step1
Paul,
At first glance I think you've omitted single quotes around the largetext
value i.e. the first NULL in your values list below should be 'NULL'
Dave
-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: 11 February 2003 15:12
To: CF-Talk
Subject: CFMX/mySQL
type requested
Any help would be greatly appreciated!
Paul Giesenhagen
QuillDesign
- Original Message -
From: Paul Giesenhagen [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, February 11, 2003 9:11 AM
Subject: CFMX/mySQL Query Problem
I have a query that is giving
But that would make NULL a string instead of a NULL value ...
Paul Giesenhagen
QuillDesign
- Original Message -
From: Dave Wilson [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, February 11, 2003 9:13 AM
Subject: RE: CFMX/mySQL Query Problem
Paul,
At first glance I
, 2003 7:19 AM
To: CF-Talk
Subject: Re: CFMX/mySQL Query Problem
Lets try that one again! (copy and paste just didn't cut it)
I have a query that is giving a generic error and I cannot see what hte
problem is ... below you will see the insert statement and the generic
error.
This is running
', '#variables.urlRoot#', NULL, NULL, NULL, NULL,
'#form.adminUser#')
/cfquery
ie. without the cfqueryparam.
Regards
Stephen
- Original Message -
From: Paul Giesenhagen [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, February 11, 2003 3:18 PM
Subject: Re: CFMX/mySQL Query Problem
Lets
If the columns allow NULL values, could you not just omit them?
- Original Message -
From: Paul Giesenhagen [EMAIL PROTECTED]
What the insert looks like:
values('36','urlRoot',' (param 1) ',NULL,NULL,NULL,NULL,'admin') are the
values being put into the database.
PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, February 11, 2003 9:35 AM
Subject: Re: CFMX/mySQL Query Problem
Its daft and people will shout at me, but try this instead :
cfquery datasource=#form.dsn# name=step1 username=#form.dbUserName#
password=#form.dbPassword#
insert
Paul Giesenhagen wrote:
cfquery datasource=#form.dsn# name=step1 username=#form.dbUserName#
password=#form.dbPassword#insert into
settings(id,datatype,smalltext,largetext,numberdata,datedata,edit_date,admin
_user) values('36','urlRoot','cfqueryparam value=#variables.urlRoot#
:[EMAIL PROTECTED]]
Sent: 11 February 2003 15:21
To: CF-Talk
Subject: Re: CFMX/mySQL Query Problem
But that would make NULL a string instead of a NULL value ...
Paul Giesenhagen
QuillDesign
- Original Message -
From: Dave Wilson [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent
Subject: RE: CFMX/mySQL Query Problem
Yes sorry my bad, however the error message is pointing out a problem with
datatypes. How about id field? is that a string or a value? because you're
trying to insert it as a string although it looks like it should be a
value
to me.
Dave
-Original
25 matches
Mail list logo