View Full Version : Any Coldfusion types out there?

12-12-2001, 07:00 PM
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.


<!-- The Query -->

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

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

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

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



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

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

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





<h1>Sorry, no result</h1>




ps..i have quotes around my code so as it will display properly in this forum, so please dont tell me thats the problem!!

13-12-2001, 08:41 PM
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: http://mail.2day.com/cf-discuss/

Try them with your question.