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]

Reply via email to