Hello,
I am new to Coldfusion, and have been working on
a simple guestbook. I followed through the tutorials
that came with CFExpress and had no problems setting
up a database, form and outputting the data until I
tried to format the data in descending order (last entry
to the first entry).
I tried some create ways with CFSET & counting
the total records, then tried using CFQUERY STARTROW
, but this didn't work. I read through all of the various CFML
commands & tried to find one that would do this. Finally, I resorted
to SQL commands and found ORDER BY.... ASC/DESC.
This, however, only worked when a field name was
given, so I gave up & decided to look at someone else's
CFML guestbook.
I found one located at:
http://www.iiseutu.fi/cfdocs/Docs/UGuide/UserGuide.htm
In the action page, there was reference to the automated ID in the
database, but when I tried to run this code, I got the error message
ODBC Error Code = 07001 (Wrong number of parameters)
SQL = "SELECT MAX(guestbook_ID)AS ID FROM guestbook"
The code that in error is:
<CFQUERY NAME="GetEnteredRecordID" DATASOURCE="GFGuestbook1">
SELECT MAX(guestbook_ID)AS ID FROM guestbook
</CFQUERY>
Can anyone shed some light on this problem? I'm running CFExpress locally
and have had no problems with the basic forms.
Thanks so much,
Kristin Thu
[EMAIL PROTECTED]
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
