Forum Home
Press F1
 
Thread ID: 13690 2001-12-12 07:00:00 Any Coldfusion types out there? Guest (0) Press F1
Post ID Timestamp Content User
27437 2001-12-12 07:00:00 I have the following code searching my database the way i want, but when there is no result i cannot get the 'sorry, no result' to display (all i get is a blank page). Can anyone help? Thanks in advance.

<!---
<body>


<!-- The Query -->

<CFQUERY name='Search' datasource='cfmBayfair'>
SELECT Title, Genre, Format FROM movies WHERE Title LIKE '%#Form.search#%' ORDER BY Title ASC
</CFQUERY>

<!---------------------------------- Display results ------------------------------------------------------->

<CFIF ParameterExists(Form.search) IS 'Yes'>

<table cellpadding = '0' cellspacing = '0' border = '1' width = '620px' align = 'Center'>

<CFOUTPUT QUERY='Search'>

<tr>

<td align = 'center'>#Title#</td>

<td align = 'center'>#Genre#</td>

<td align = 'Center'>#Format#</td>

</tr>

</CFOUTPUT>

</table>

<CFELSE>

<h1>Sorry, no result</h1>

</CFIF>

</BODY>

--->

ps..i have quotes around my code so as it will display properly in this forum, so please dont tell me thats the problem!! 		Guest (0)
27438 2001-12-13 08:41:00 I met Cold Fusion briefly and really need to learn more. 2day.com (North Shore based) have an ASP discussion list and I had a feeling they offered a cold fusion one as well.

Found it and here's the link: mail.2day.com

Try them with your question. 		Guest (0)
1