Every since I switched to CF 7 my code seems to add a comma in front of some
fields when it does a search. See my code below. I don't have this in the
Access dbase nor in my script. Is there an issue with CF 7? Are there any fixes
or updates that address this?
This problem cause searches to fail because its looking for ",NJ", for example,
and not just "NJ".
Any workaround?
Thanks
Robert O.
HWW
My query displayed in debug:
Getcustomer (Datasource=wweb, Time=0ms, Records=0) in
D:\Inetpub\Intranet\Searchforms\wwebsearch\getwwebsearch.cfm @ 10:54:02.002
SELECT * FROM wweb where 0 = 0
And customer LIKE '%'
And Institution LIKE '%'
And State = ',AL'
And country = ',0'
ORDER BY ID DESC
Code in script:
<CFIF IsDefined("FORM.customer")>
And customer LIKE '#FORM.customer#%'
</CFIF>
<CFIF IsDefined("FORM.Institution")>
And Institution LIKE '#FORM.Institution#%'
</CFIF>
<CFIF FORM.State NEQ 0>
And State = '#FORM.State#'
</CFIF>
<CFIF FORM.country NEQ 0>
And country = '#FORM.country#'
</CFIF>
ORDER BY ID DESC
</cfquery>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238291
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
