mrandrew2u
Posts: 9
|
| Posted: 08/04/2006, 5:09 PM |
|
This sql datasource in a list box:
select FamilyID, concat_ws('',LName,',',FName) as FullName from
Families order by LName ASC
causes this error:
# Error Type:
ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested name or ordinal.
/saintschool/Classes.asp, line 2534
with mysql, iis, xp pro, ccs 3.0. familyid is the bound column and FullName is the text column
Anyone? Thanks!
|
 |
 |
mrandrew2u
Posts: 9
|
| Posted: 08/04/2006, 5:11 PM |
|
oops...found the typo..too embarassed to explain 
|
|
|
|
wkempees
Posts: 1679
|
| Posted: 08/06/2006, 5:26 AM |
|
select FamilyID, concat_ws(',', LName, FName) as FullName from...
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
|
