FYI. Macromedia is listening and fixing some of the problems with the beta
1 of their new website.
-Original Message-
From: On Behalf Of Mike Chambers
Subject: Macromedia.com Beta : Stage 2
Well, I know that it may not always be obvious, but we do listen to the
community's feedback. We
March 18th Meeting - Contribute
Our next meeting will be on Tuesday, March 18th at 7pm.
The presented will be by Brad Miller of Accesszone Design
(www.accesszonedesign.com) and will be an introduction/demo on using
Macromedia Contribute. The presentation will be roughly 30 minutes long
(followed
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 and put #form.value2# instead of
#hlist#.
Christopher V. Holdman
Webmaster - City of Olathe
(913) 971-6286
(913) 238-4681 Cell
[EMAIL PROTECTED]
-Or
yeah, they are right, the 'IN' statement is the way to go
geez, what the heck was i thinkin? ;P
-Original Message-
From: Justin Hansen
Sent: Thursday, March 13, 2003 4:24 PM
To: [EMAIL PROTECTED]
Subject: RE: [KCFusion] Simple Query Question
oops.. correction, i dont know how all th
oops.. correction, i dont know how all the 3D's came from anyway.
This should do the trick
field2='#listGetAt(form.value2,i)#' OR
Or
select * from table
where field1='value1' AND (#preservesinglequotes(locList2OR)#)
You could add a boolean variable and then use it to
check to see if it's the first time through, if it is
don't use the OR, otherwise add the OR before you add
the next variable.
Might be able to use the IN clause as well instead of
hte OR.
select * from table
where field1='value1'
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
select * from table
where field1='value1' AND field2 IN ( ' #hlist# ' )
This should do the trick
field2=3D'#listGetAt(form.value2,i)#' OR
Or
select * from table
where field1=3D'value1' AND (#preservesinglequotes(locList2OR)#)
Or
Now its your turn Matt... :)
Justin Hansen
~~
Title: Message
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