Try removing the quotes, eg:
<cfquery name="GetDetail" datasource="#odbc#">
SELECT *
FROM Items
WHERE ItemID=#ItemID#
</cfquery>
(ItemID should be a numeric field, not a text field.)
-----Original Message-----
From: Chip Sigourney [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 13 July 2000 11:20 AM
To: Cf-Talk@Houseoffusion. Com
Subject: cf insert
having problems b/c this query is only returning one word for each field:::
<cfquery name="GetDetail" datasource="#odbc#">
SELECT * FROM Items WHERE ItemID='#ItemID#'
</cfquery>
thanks
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
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.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
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.
