since changed it and put the single quote marks and it makes no difference.
Here is my page...http://webmm230.ioaxis
com/~george/project3/sdsGFX_homepage.html
-------Original Message-------
From: [EMAIL PROTECTED]
Date: Wednesday, March 10, 2004 05:12:08 PM
To: CF-Newbie
Subject: RE: transfering data
Greg was right, that error appears when you forget the quotes around the
variable. The code you posted, is that the exact code you are using?
Ade
-----Original Message-----
From: Lisa Naillon [mailto:[EMAIL PROTECTED]
Sent: 10 March 2004 22:38
To: CF-Newbie
Subject: RE: transfering data
Thanx, I tried that and nothing changes. It says unknown column 'Flash'
in
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]
