You can do like
cfparam name=Form.sku default=1!--- added line
cfparam name=Form.pn default=0
---cfquery name=product datasource=carbs SELECT Product_ID, Name, SKU,
Description1, Description2, Vend_Name, Vend_Number, Image1, Image1ParamsFROM
carbs.productsWHERE sku = cfqueryparam cfsqltype=cf_sql_varchar
value=#FORM.sku# maxlength=40 /
orVend_Number = cfqueryparam cfsqltype=cf_sql_varchar value=#FORM.pn#
maxlength=40 /
/cfquery
pSKU:input type=text name=SKU input type=submit value=Find
Please enter the SKU Number and then clickstrongFind/strong.!--- ADDED
OUTPUT LINE
br/Vend_Number:input type=text name=Vend_Number input type=submit
value=Find Please enter the Part Number and then
clickstrongFind/strong.
---/form
OR
cfparam name=Form.sku default=1!--- added line
cfparam name=Form.pn default=0
---
cfparam name=Form.sku default=1cfset whFlag = 0cfquery name=product
datasource=carbs SELECT Product_ID, Name, SKU, Description1, Description2,
Vend_Name, Vend_Number, Image1, Image1ParamsFROM carbs.productsWHERE
cfif #FORM.sku# neq 1!--- even you can plave condition as per your
value---
sku = cfqueryparam cfsqltype=cf_sql_varchar value=#FORM.sku#
maxlength=40 /cfset whFlag = 1
/cfif
cfif whFlag eq 1 or /cfif
cfif #FORM.pn# neq 0!--- even you can plave condition as per your
value---
Vend_Number = cfqueryparam cfsqltype=cf_sql_varchar value=#FORM.pn#
maxlength=40 /
/cfif
/cfquery
pSKU:input type=text name=SKU input type=submit value=Find
Please enter the SKU Number and then clickstrongFind/strong.!--- ADDED
OUTPUT LINE
br/Vend_Number:input type=text name=Vend_Number input type=submit
value=Find Please enter the Part Number and then
clickstrongFind/strong.
---/form
I tried, I hope it will give you some idea to solve your problem.
Sincerely
Hiren Patel
From: [EMAIL PROTECTED]: [EMAIL PROTECTED]: [ACFUG Discuss] Form Parameters and
SQL Language for WHERE logicDate: Wed, 14 Mar 2007 07:27:01 -0500
I am trying to make a form where I can use a couple search fields.
Right now I have a singe search variable: SKU, but I would like to use the same
page and choose PN as well.
You can see that I am trying to add Form.pn as a variable to use optionally as
opposed to Form.sku in a different box.
---cfparam name=Form.sku default=1!--- added
line
cfparam name=Form.pn default=0
---cfquery name=product datasource=carbs SELECT Product_ID, Name, SKU,
Description1, Description2, Vend_Name, Vend_Number, Image1, Image1ParamsFROM
carbs.productsWHERE sku = cfqueryparam cfsqltype=cf_sql_varchar
value=#FORM.sku# maxlength=40 /!--- added line
orWHERE Vend_Number = cfqueryparam cfsqltype=cf_sql_varchar
value=#FORM.pn# maxlength=40 /
---/cfquery
pSKU:input type=text name=SKU input type=submit value=Find
Please enter the SKU Number and then clickstrongFind/strong.!--- ADDED
OUTPUT LINE
br/Vend_Number:input type=text name=Vend_Number input type=submit
value=Find Please enter the Part Number and then
clickstrongFind/strong.
---/form
--
If I remove the !--- --- from this code I would need it to work.
I konw the OR statement between the WHERE's is wrong. I cant find a way to
make this statement and dont know how to word a search to find a way to do this.
Any guidance out there what I need to use to do this?
Robert P. Reil
Managing Director,
Motorcyclecarbs.com, Inc.
4292 Country Garden Walk NW
Kennesaw, Ga. 30152
Office 770-974-8851
Fax 770-974-8852
www.motorcyclecarbs.com
_
Call friends with PC-to-PC calling -- FREE
http://get.live.com/messenger/overview
-
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-