Professional Web Applications Themes

Recordset error message - Dreamweaver AppDev

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 ...

  1. #1

    Default Recordset error message

    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""

    dfullerton Guest

  2. #2

    Default Re: Recordset error message

    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" <webforumsusermacromedia.com> wrote in message
    news:d362hu$1pt$1forums.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""
    >

    Nancy Gill Guest

Similar Threads

  1. How To Supress Acrobat Error Message And Alert Message
    By ckpang@adobeforums.com in forum Adobe Acrobat SDK
    Replies: 10
    Last Post: January 15th, 11:33 AM
  2. Replies: 4
    Last Post: March 23rd, 12:56 AM
  3. recordset error
    By -D- in forum Dreamweaver AppDev
    Replies: 5
    Last Post: November 9th, 02:30 PM
  4. recordset error
    By -D- in forum Dreamweaver AppDev
    Replies: 1
    Last Post: March 31st, 03:20 AM
  5. Error after creating second recordset
    By illufox in forum Dreamweaver AppDev
    Replies: 3
    Last Post: March 17th, 06:07 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139