No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
Hi, I would like to search one field in database with multiple words. Also i will allow searches for example : a or cs....(one,two characters). My code: [code] <cfparam name="URL.NAME" default="1" type="Any"> <cfquery name="search" datasource="datasource"> SELECT * FROM search WHERE NAME LIKE ="%#URL.NAME#%" ORDER BY DATE DESC </cfquery> [/code] this … 
|
|
|
Re:
dynamic Query
I have a SQL Query build as a string but i cant seem to pass it into to the <cfquery> But it does not work any one can help me? [ICODE] <cfif ISDEFINED ('member')> <CFSET SQL = "SELECT * FROM precontract "> <CFSET SQL_Coubr = 0 > <cfif form.member neq …
|
|
|
I have data for a drop down box that is up to 250 digits. This places the drop down box outside the range of the screen. I need to limit the drop down box to 150 digits on the screen but also need to display the extra 100 digits somehow. … |