Recordset error message

[dfullerton]

Hello,

I am creating a recordset from a query. The recorset returns the correct
information until I add the Column Names to the query. In the select statement
I added 2 double quotes around the column name to display the name. This is
required in order toto make the web page viewable. If I remove the double
quotes the recordset works but the web page doe not. Is there something I can
do to get it to work in both places.


pathways_all.Source = "SELECT Distinct PERSON.PERS_LOGIN_ID ""Associate
Person ID"", PERSON.PERS_LAST_NAME ""Associate Last Name"",
PERSON.PERS_FIRST_NAME ""Associate First Name"",
HIER.LOCAL_CD ""Hierarchy"", CURRICULUM.LOCAL_CD ""Curriculum ID"",
CURRICULUM.TTL ""Curriculum Title"", CURRICULUM.STATUS_CD
""Curriculum Status Code"", PERSON.PERS_EMAIL_ADR ""Associate Email"",
PERSON_CURRIC_ASSIGNMENT.ADDED_DT ""Enrollment date"",
PERSON_CURRIC.COMPLETED_DT ""Completion Date"", PERSON.ADDRESS_CITY
""Associate Location City"", PERSON.ADDRESS_STATE ""Associate Location
State"", MANAGER.PERS_LAST_NAME ""Manager Last Name"",
MANAGER.PERS_FIRST_NAME ""Manager First Name"", MANAGER.PERS_EMAIL_ADR
""Manager Email""

[Nancy Gill]

Try single quotes on the interior set.


--
Nancy Gill
Team Macromedia Volunteer for Dreamweaver MX/UltraDev
[url]http://www.macromedia.com/go/team/[/url]
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner's
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development

"dfullerton" <webforumsuser@macromedia.com> wrote in message
news:d362hu$1pt$1@forums.macromedia.com...

> Hello,
>
> I am creating a recordset from a query. The recorset returns the correct
> information until I add the Column Names to the query. In the select

statement

> I added 2 double quotes around the column name to display the name. This

is

> required in order toto make the web page viewable. If I remove the double
> quotes the recordset works but the web page doe not. Is there something I

can

> do to get it to work in both places.
>
>
> pathways_all.Source = "SELECT Distinct PERSON.PERS_LOGIN_ID ""Associate
> Person ID"", PERSON.PERS_LAST_NAME ""Associate Last Name"",
> PERSON.PERS_FIRST_NAME ""Associate First Name"",
> HIER.LOCAL_CD ""Hierarchy"", CURRICULUM.LOCAL_CD ""Curriculum

ID"",

> CURRICULUM.TTL ""Curriculum Title"", CURRICULUM.STATUS_CD
> ""Curriculum Status Code"", PERSON.PERS_EMAIL_ADR ""Associate

Email"",

> PERSON_CURRIC_ASSIGNMENT.ADDED_DT ""Enrollment date"",
> PERSON_CURRIC.COMPLETED_DT ""Completion Date"",

PERSON.ADDRESS_CITY

> ""Associate Location City"", PERSON.ADDRESS_STATE ""Associate

Location

> State"", MANAGER.PERS_LAST_NAME ""Manager Last Name"",
> MANAGER.PERS_FIRST_NAME ""Manager First Name"",

MANAGER.PERS_EMAIL_ADR

> ""Manager Email""
>