Depend on what the data type of the field you are calling from the table.
If it is a numeric field you will not need to have any ' around the numeric
values, but if the data type is varchar / char then you will have to have
' around the string.
varchar/char
select * from table
where field1='value1' AND field2 IN ( 'a','b','c')
select * from table
where field1='value1' AND field2 IN (1,2,3,4)
Chris Holdman
<[EMAIL PROTECTED] To: "'[EMAIL PROTECTED]'" <[EMAIL
PROTECTED]>
KS.ORG> cc:
Sent by: Subject: RE: [KCFusion] Simple Query
Question
[EMAIL PROTECTED]
fusion.org
03/13/03 04:35
PM
Please respond
to CF-List
I am not receiving any errors but I am not receiving any records and when I
do a record count I get 0.
Also, why couln;t I just skip the <cfset> and put #form.value2# instead of
#hlist#.
Christopher V. Holdman
Webmaster - City of Olathe
(913) 971-6286
(913) 238-4681 Cell
[EMAIL PROTECTED]
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 13, 2003 4:11 PM
To: [EMAIL PROTECTED]
Subject: Re: [KCFusion] Simple Query Question
not setup exactly like you have it but you can use the IN sql statment with
your list of variables
it does not require you to split it up
<cfset hlist = replace(form.value2, "," , "','" , "all")>
<cfquery name="query" datasource="data">
select * from table
where field1='value1' AND field2 IN ( ' #hlist# ' ) </cfquery>
Chris Holdman
<[EMAIL PROTECTED] To: "'[EMAIL PROTECTED]'"
<[EMAIL PROTECTED]>
KS.ORG> cc:
Sent by: Subject: [KCFusion] Simple
Query Question
[EMAIL PROTECTED]
fusion.org
03/13/03 03:58
PM
Please respond
to CF-List
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]
______________________________________________________________________
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]
