Newbie needs help with cold fusion in DreamweaverMX - Macromedia Dreamweaver

[colm]

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]

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?

[Redtailhawk webforumsuser@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]

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