So I thought I was doing something totally wrong and that Access SQL
uses something beside the +.
But! Good news!
I tried that code in an SQL Statement with nothing else but
Select atfname + ' ' + atlname AS Agentname
FROM tblagent
And it worked fine.
So there must be something else in the syntax of
SELECT tblusers.username, tblJobSeekers.jsfname,
tblJobSeekers.jslname,tblJobSeekers.jsemail, tblJobSeekers.jscountry,
tblJobSeekers.pverify,tblJobSeekers.jsphone1
[atfname] + " " + [atlname] AS AgentName
FROM tblAgent INNER JOIN (tblusers INNER JOIN tblJobSeekers ON
tblusers.userid = tblJobSeekers.userid) ON tblAgent.atid =
tblJobSeekers.agentid
ORDER BY tblJobSeekers.jslname;
That's causing it to fail. *sigh*
I hate syntax errors.
And I don't understand why the MSACcess SQL string failed to work.
Could someone explain that?
Thanks for the help :)
-Gel
-----Original Message-----
From: CF-Talk [mailto:[EMAIL PROTECTED]
Sent: Saturday, May 15, 2004 3:01 AM
To: CF-Talk
Subject: CF-Talk: Digest every 2 hours
Subject: How do you concatanate two table fields in CFQUERY with MS
Access
From: "Sandy Clark"
Date: Fri, 14 May 2004 22:18:07 -0400
Thread:
http://www.houseoffusion.com/cf_lists/index.cfm/method=messages&threadid
=32529&forumid=4#163293
Sql uses +
& is the CF concatenation.
Silly gel.
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
