Re: Newbie needs help with cold fusion in DreamweaverMX

What's the code for your recordset look like?

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


"Redtailhawk" <webforumsuser (AT) macromedia (DOT) com> wrote

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?

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>

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
http://www.moosepucky.com/links/links.cfm > Links
http://www.colmgallagher.com/extensions.htm > Extensions


"Redtailhawk" <webforumsuser (AT) macromedia (DOT) com> wrote

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