oops.. correction, i dont know how all the 3D's came from.... anyway.....
This should do the trick........
<cfloop from="1" to="#listLen(form.value2)#" index="i">
field2='#listGetAt(form.value2,i)#' <cfif i lt listLen()>OR</cfif>
</cfloop>
Or....
<cfset locList2OR ="field2='" & replace(form.value2,",","' OR = field2='" &
"'">
<cfquery name="query" datasource="data">
select * from table
where field1='value1' AND (#preservesinglequotes(locList2OR)#)
</cfquery>
Or....
Now its your turn Matt... :)
Justin Hansen
~~~~~~~~~~~~~~~~~~~~~~
Uhlig Communications
Systems Engineer
~~~~~~~~~~~~~~~~~~~~~~
[EMAIL PROTECTED]
913-754-4273 Office
816-695-4045 Mobile
~~~~~~~~~~~~~~~~~~~~~~
-----Original Message-----
From: Chris Holdman [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 13, 2003 3:59 PM
To: '[EMAIL PROTECTED]'
Subject: [KCFusion] Simple Query Question
I have a form with a multiple select box that I am want to build a query from, but am
having problems. I set up an index loop with an OR statement, but I have obviously
set it up wrong beacuase it is adding an OR to the end of the query. How do I set it
up to not put an OR after the last index?
<cfquery name="query" datasource="data">
select * from table
where field1='value1' AND (
<cfloop index="index" list="#form.value2#" delimiters=",">
field2='#index#' OR
</cfloop>
)
</cfquery>
Christopher V. Holdman
Webmaster - City of Olathe
(913) 971-6286
(913) 238-4681 Cell
[EMAIL PROTECTED]
-----Original Message-----
From: Dunwiddie, Bruce [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 11, 2003 3:16 PM
To: '[EMAIL PROTECTED]'
Subject: RE: [KCFusion] Printer Friendly Directory Listing
style="page-break-after: always"
if you say apply that to a <table> tag, and then have multiple tables each having that
style, it will have a page break between them. of course, I'm sure it's only ie, but
better than nothing.
-----Original Message-----
From: Chris Holdman [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 11, 2003 3:03 PM
To: '[EMAIL PROTECTED]'
Subject: [KCFusion] Printer Friendly Directory Listing
I have a directory listing pulling from a database and sorting by departments.
Everything work great online, but some people are wanting to print it out...when they
do sometimes the page break for printing occurs in the middle of a department listing
and the second page does not have the department title. Is there a way to determine
where a printing page break will occur and force the follwoing page to repeat the
department title. Below is an example of what I mean and the code I currently use.
Department A
address
phone # - name
phone # - name
phone # - name
Department B
address
phone # - name
phone # - name
phone # - name
phone # - name
phone # - name
phone # - name
phone # - name
phone # - name
phone # - name
[page break]
Department B
address
phone # - name
phone # - name
phone # - name
Department C
address
phone # - name
phone # - name
phone # - name
<cfoutput query="list" group="Department">
<b><font size="+1">#Department#</font></b><br>
#building#<br>
<hr align="left" width="300">
<cfoutput>
#Ext# - <b>#Name#</b><br>
</cfoutput>
<p>
</cfoutput>
Christopher V. Holdman
Webmaster - City of Olathe
(913) 971-6286
(913) 238-4681 Cell
[EMAIL PROTECTED]
______________________________________________________________________
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives........ http://www.mail-archive.com/[EMAIL PROTECTED]
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe.................... mailto:[EMAIL PROTECTED]
To Unsubscribe................ mailto:[EMAIL PROTECTED]
______________________________________________________________________
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives........ http://www.mail-archive.com/[EMAIL PROTECTED]
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe.................... mailto:[EMAIL PROTECTED]
To Unsubscribe................ mailto:[EMAIL PROTECTED]
