Professional Web Applications Themes

Recordset sometimes works - sometimes doesn't! - Macromedia Dynamic HTML

I am developing a php site using mysql and apache. I have finally managed to get a database connection and am trying now to create some recordsets. This is where the difficulties lie..... I have 14 tables, the majority of which are for drop down menus. - All these (Single columns) return recordsets with no problems. The two main relational tables have multiple columns. If I select a the majority of single selected columns, I have no problem but there are two columns where no recordset is returned. I have tried renaming these columns with no effect. The sql query ...

  1. #1

    Default Recordset sometimes works - sometimes doesn't!

    I am developing a php site using mysql and apache.

    I have finally managed to get a database connection and am trying now to
    create some recordsets.

    This is where the difficulties lie.....

    I have 14 tables, the majority of which are for drop down menus. - All these
    (Single columns) return recordsets with no problems.

    The two main relational tables have multiple columns.

    If I select a the majority of single selected columns, I have no problem but
    there are two columns where no recordset is returned. I have tried renaming
    these columns with no effect. The sql query seems fine and does work with all
    but two columns.

    Can ayone explain this inconsistency?

    Is it something to do with field definition?

    I am really dying for any help here.

    RichardOMarketing Guest

  2. #2

    Default Re: Recordset sometimes works - sometimes doesn't!

    The Appdev forum would be the best place to post this, Richard!

    --
    Murray --- ICQ 71997575
    Adobe Community Expert
    (If you *MUST* email me, don't LAUGH when you do so!)
    ==================
    [url]http://www.dreamweavermx-templates.com[/url] - Template Triage!
    [url]http://www.projectseven.com/go[/url] - DW FAQs, Tutorials & Resources
    [url]http://www.dwfaq.com[/url] - DW FAQs, Tutorials & Resources
    [url]http://www.macromedia.com/support/search/[/url] - Macromedia (MM) Technotes
    ==================


    "RichardOMarketing" <webforumsusermacromedia.com> wrote in message
    news:ejf3gn$f6o$1forums.macromedia.com...
    >I am developing a php site using mysql and apache.
    >
    > I have finally managed to get a database connection and am trying now to
    > create some recordsets.
    >
    > This is where the difficulties lie.....
    >
    > I have 14 tables, the majority of which are for drop down menus. - All
    > these
    > (Single columns) return recordsets with no problems.
    >
    > The two main relational tables have multiple columns.
    >
    > If I select a the majority of single selected columns, I have no problem
    > but
    > there are two columns where no recordset is returned. I have tried
    > renaming
    > these columns with no effect. The sql query seems fine and does work with
    > all
    > but two columns.
    >
    > Can ayone explain this inconsistency?
    >
    > Is it something to do with field definition?
    >
    > I am really dying for any help here.
    >

    Murray *ACE* Guest

Similar Threads

  1. Question Foxfire works, IE doesn't
    By davidhilfiker in forum Macromedia Dreamweaver
    Replies: 0
    Last Post: March 22nd, 05:11 PM
  2. Web service that works in CF 6 doesn't not in CF 7
    By JNokes in forum Coldfusion - Advanced Techniques
    Replies: 2
    Last Post: March 23rd, 10:42 PM
  3. Recordset doesn't return identity field
    By A_X_L_V in forum ASP Components
    Replies: 7
    Last Post: October 21st, 02:48 PM
  4. Replies: 25
    Last Post: August 21st, 09:01 PM
  5. #25043 [Opn->Bgs]: doc_root doesn't works
    By sniper@php.net in forum PHP Development
    Replies: 0
    Last Post: August 11th, 04:56 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