Professional Web Applications Themes

Newbie needs help with cold fusion in DreamweaverMX - Macromedia Dreamweaver

If you post the code, someone may be able to help... -- Colm [url]http://www.moosepucky.com/links/links.cfm[/url] > Links [url]http://www.colmgallagher.com/extensions.htm[/url] > Extensions "Redtailhawk" <webforumsusermacromedia.com> wrote in message news:beirf0$5rc$1forums.macromedia.com... > I have been using the Cold Fusion development tools in Dreamweaver to facilitate accessing databases in my website. I keep getting the following message when I debug: > An expression that began on line 51, column 21. > Your expression might be missing an ending "#" (it might look like #expr )....

  1. #1

    Default Re: Newbie needs help with cold fusion in DreamweaverMX

    If you post the code, someone may be able to help...

    --
    Colm
    [url]http://www.moosepucky.com/links/links.cfm[/url] > Links
    [url]http://www.colmgallagher.com/extensions.htm[/url] > Extensions


    "Redtailhawk" <webforumsusermacromedia.com> wrote in message
    news:beirf0$5rc$1forums.macromedia.com...
    > I have been using the Cold Fusion development tools in Dreamweaver to
    facilitate accessing databases in my website. I keep getting the following
    message when I debug:
    > An expression that began on line 51, column 21.
    > Your expression might be missing an ending "#" (it might look like
    #expr ).


    colm Guest

  2. #2

    Default Re: Newbie needs help with cold fusion in DreamweaverMX

    What's the code for your recordset look like?

    --
    Colm
    [url]http://www.moosepucky.com/links/links.cfm[/url] > Links
    [url]http://www.colmgallagher.com/extensions.htm[/url] > Extensions


    "Redtailhawk" <webforumsusermacromedia.com> wrote in message
    news:ben4ao$qsi$1forums.macromedia.com...
    > I checked, and they are all changed accordingly. No more spaces in the ##
    statements.
    > I am still getting "Element FIRSTNAME is undefined" as an error message.
    Do I need
    > to do an "IsDefined" statement or is it something else?

    colm Guest

  3. #3

    Default Re: Newbie needs help with cold fusion in DreamweaverMX

    This is the code for my queries. There are 3. I have been working on one of them with some
    friends and we keep having the same problem no matter what we change.

    Thanks for your help
    Redtailhawk

    <cfquery name="rscouple" datasource="Justwhat">
    SELECT BrideFirst, BrideLast, GroomFirst, GroomLast, WeddingDate, WeddingState,
    Gift, Price, SalesCompany, CompanyWebSite FROM Register WHERE #PreserveSingleQuotes(WhereClause)#
    </cfquery>

    <cfparam name="PageNum_rsweddingstate" default="1">
    <cfquery name="rsweddingstate" datasource="Justwhat">
    SELECT "Bride First", "Bride Last", "Groom First", "Groom Last", "Wedding Date",
    "Wedding State" FROM Register
    </cfquery>

    <cfparam name="PageNum_rsregistry" default="1">

    <cfquery name="rsregistry" datasource="Justwhat">
    SELECT "First Name", "Last Name", "Billing Address", City, "State", "Zip Code",
    "Amount given" FROM Giftgiver ORDER BY "Last Name" ASC
    </cfquery>



    Redtailhawk webforumsuser@macromedia.com Guest

  4. #4

    Default Re: Newbie needs help with cold fusion in DreamweaverMX

    You're still using spaces in your recordsets. Do the names in the recordsets
    match the names in the database?
    Try this...
    In your database rename the columns so that there aren't any spaces.
    Rebuild the recordsets one at a time in DW, testing each as you build it.
    Once the simple recordsets are built, add any custom code and test again.

    --
    Colm
    [url]http://www.moosepucky.com/links/links.cfm[/url] > Links
    [url]http://www.colmgallagher.com/extensions.htm[/url] > Extensions


    "Redtailhawk" <webforumsusermacromedia.com> wrote in message
    news:bev3u6$jj5$1forums.macromedia.com...
    > This is the code for my queries. There are 3. I have been working on one
    of them with some
    > friends and we keep having the same problem no matter what we change.
    >
    > Thanks for your help
    > Redtailhawk
    > <cfquery name="rscouple" datasource="Justwhat">
    > SELECT BrideFirst, BrideLast, GroomFirst, GroomLast, WeddingDate,
    WeddingState,
    > Gift, Price, SalesCompany, CompanyWebSite FROM Register WHERE
    #PreserveSingleQuotes(WhereClause)#
    > </cfquery>
    >
    > <cfparam name="PageNum_rsweddingstate" default="1">
    > <cfquery name="rsweddingstate" datasource="Justwhat">
    > SELECT "Bride First", "Bride Last", "Groom First", "Groom Last", "Wedding
    Date",
    > "Wedding State" FROM Register
    > </cfquery>
    >
    > <cfparam name="PageNum_rsregistry" default="1">
    >
    > <cfquery name="rsregistry" datasource="Justwhat">
    > SELECT "First Name", "Last Name", "Billing Address", City, "State", "Zip
    Code",
    > "Amount given" FROM Giftgiver ORDER BY "Last Name" ASC
    > </cfquery>
    >
    >
    colm Guest

Similar Threads

  1. Migrating from Cold fusion 5 to Cold fusion 7
    By Ashish Khanna in forum Coldfusion Server Administration
    Replies: 1
    Last Post: October 6th, 12:37 PM
  2. Should we buy Cold Fusion?
    By Nu2Fusion in forum Coldfusion - Getting Started
    Replies: 4
    Last Post: September 28th, 08:27 PM
  3. Using Cold Fusion
    By allan_DJ in forum Coldfusion - Getting Started
    Replies: 9
    Last Post: June 7th, 03:10 PM
  4. Cold Fusion on MAC OSX
    By Simon_E in forum Macromedia ColdFusion
    Replies: 2
    Last Post: April 28th, 03:58 PM
  5. Cold Fusion 5 & ASP
    By THSee2 in forum Coldfusion - Getting Started
    Replies: 2
    Last Post: April 6th, 07:15 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