with database logic. Is this access? I think you want something like this:
<cfquery datasource="datasource" dbtype="odbc" name="photo_find">
SELECT p.autoid, p.mls_no, e.property_id_no,
iif (e.property_id_no is not null, photo2, 'No photo available') AS photo2
FROM properties p LEFT OUTER JOIN property_photos e ON p.autoid EQ
e.property_id_no
WHERE 1=1
<cfif isdefined("form.mls_no")>
AND p.mls_no = <cfqueryparam cfsqltype="cf_sql_varchar"
value="#form.mls_no#">
</cfif>
</cfquery>
----- Original Message -----
From: "Tim Laureska" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 10, 2004 8:13 AM
Subject: RE: Sorting Logic question
> 1st try at embedding CFIFS in Query but failing... getting "Error
> resolving parameter P.AUTOID" ... this must be a syntax thing:
>
> <cfquery datasource="datasource" dbtype="odbc" name="photo_find">
> SELECT p.autoid, e.photo AS photo2, p.mls_no, e.property_id_no
> FROM properties p, property_photos e
> WHERE <cfif (p.autoid EQ e.property_id_no) AND (p.mls_no EQ
> '#form.mls_no#')><cfelse>no photo available</cfif>
> </cfquery>
>
>
> -----Original Message-----
> From: Raymond Camden [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, February 10, 2004 8:40 AM
> To: CF-Talk
> Subject: RE: Sorting Logic question
>
> Yea I've seen that too. You couldn't book mark form results or detail
> pages.
> I hate it.
>
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
