where clause.
-------Original Message-------
From: [EMAIL PROTECTED]
Date: Wednesday, March 10, 2004 01:24:27 PM
To: CF-Newbie
Subject: RE: transfering data
make sure your strings are enclosed in single quotes in the SQL statement.
IE.
SELECT tutTYPE, tutNAME,img3
FROM tutorials
WHERE
tutTYPE = '#Form.searchForTut#'
-----Original Message-----
From: Lisa Naillon [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 10, 2004 3:24 PM
To: CF-Newbie
Subject: transfering data
I have been trying to get my form to pass info from a search text box to
another page. Here is what I wrote
<CFQUERY NAME='tutListRetrieve'>
SELECT tutTYPE, tutNAME,img3
FROM tutorials
WHERE tutTYPE = #Form.searchForTut#
</CFQUERY>
If someone types in the type of tutorial i.e. Flash then the following page
error says, there is no column "Flash". Duh I know that. How do I get the
page to know?
cicero
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
