quotes. I changed all my cf to double quotes and now it works. Here is the
site. It is intended to be the start of bigger and better things but this
stage is done.
http://webmm230.ioaxis.com/~george/project3/sdsGFX_homepage2.html
I like this forum thingy too.
Lisa
-------Original Message-------
From: [EMAIL PROTECTED]
Date: Tuesday, March 16, 2004 08:08:28 AM
To: CF-Newbie
Subject: RE: transfering data
Did you manage to fix the problem?
-----Original Message-----
From: Lisa Naillon [mailto:[EMAIL PROTECTED]
Sent: 11 March 2004 01:42
To: CF-Newbie
Subject: RE: transfering data
Thanx Adrian, Yes, That is the exact code...I copied and pasted it. I
have
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]
