Resturant/Golf reservation system
Has anyone out there created a reservation system for either a resturant or a golf course? I am looking to see if there is anything out there that already exists so that I do not have to re invent the wheel for this. Thank you Alan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Multiple CFFile
I have 4 cffiles set up on one form page. The first cffile uploads to the proper location and also inserts into the db however the other 3 do not get the proper information. My code looks like this. UPDATE ProdPics SET ItemPicLB = '#ItemPicLB#' WHERE #ItemID# = PicID UPDATE ProdPics Set ItemPicF = '#ItemPicF#' WHERE #ItemID# = PicID UPDATE ProdPics Set ItemPicB = '#ItemPicB#' WHERE #ItemID# = PicID TIA Alan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL Returns
That did not help, now I am getting 14 returns for each record. Now I am in confusion. Is there another way for me to return just one record. Do I need to refine my where clause? TIA - Original Message - From: "Bob Silverberg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, April 12, 2001 7:24 AM Subject: RE: SQL Returns > Well, one way it to use the DISTINCT keyword. Change your statement from: > > SELECT Products.ItemID, etc. > > to > > SELECT DISTINCT Products.ItemID, etc. > > but I'm not sure if that will give you what you want. > > Give it a try and see what the result set looks like. > > Bob > > -Original Message- > From: Alan Koenig [mailto:[EMAIL PROTECTED]] > Sent: April 12, 2001 12:58 PM > To: CF-Talk > Subject: SQL Returns > > > I would like to refine my sql searches down. From the following sql > statement I am recieving up to 12 returns of the same record. How can I > make this so that there is only 1 return for each record? > > SELECT Products.ItemID, > Products.SKU, Products.ItemName, > Products.CategoryID, > Products.SubCatID, > Products.S_Description, > Products.Description, > Products.Price, > Products.Weight, > Products.A1, > Products.A1Vals, > Products.A2, > Products.A2Vals, > Products.Units, > Products.Layout, > Products.Key_Word, > ProdPics.PicID, > ProdPics.ItemPic, > ProdPics.ItemPicLB, > ProdPics.ItemPicF, > ProdPics.ItemPicB > FROMProducts, ProdPics > WHERE Products.ItemID = ProdPics.PicID > AND Description LIKE '%#form.keyword#%' > ORItemName LIKE '%#form.keyword#%' > AND ItemID > 1 > ORDER BY ItemName > > > TIA > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL Returns
It is a 1 to 1 relationship between them. Thanks - Original Message - From: "Hayes, David" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, April 12, 2001 7:21 AM Subject: RE: SQL Returns > Is your join correct? Should it, perhaps, be WHERE products.ItemID = > prodPics.itemID? > Is there a 1 to 1 relationship between products and pics? > > -Original Message- > From: Alan Koenig [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 12, 2001 11:58 AM > To: CF-Talk > Subject: SQL Returns > > > I would like to refine my sql searches down. From the following sql > statement I am recieving up to 12 returns of the same record. How can I > make this so that there is only 1 return for each record? > > SELECT Products.ItemID, > Products.SKU, Products.ItemName, > Products.CategoryID, > Products.SubCatID, > Products.S_Description, > Products.Description, > Products.Price, > Products.Weight, > Products.A1, > Products.A1Vals, > Products.A2, > Products.A2Vals, > Products.Units, > Products.Layout, > Products.Key_Word, > ProdPics.PicID, > ProdPics.ItemPic, > ProdPics.ItemPicLB, > ProdPics.ItemPicF, > ProdPics.ItemPicB > FROMProducts, ProdPics > WHERE Products.ItemID = ProdPics.PicID > AND Description LIKE '%#form.keyword#%' > ORItemName LIKE '%#form.keyword#%' > AND ItemID > 1 > ORDER BY ItemName > > > TIA > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL Returns
I would like to refine my sql searches down. From the following sql statement I am recieving up to 12 returns of the same record. How can I make this so that there is only 1 return for each record? SELECT Products.ItemID, Products.SKU, Products.ItemName, Products.CategoryID, Products.SubCatID, Products.S_Description, Products.Description, Products.Price, Products.Weight, Products.A1, Products.A1Vals, Products.A2, Products.A2Vals, Products.Units, Products.Layout, Products.Key_Word, ProdPics.PicID, ProdPics.ItemPic, ProdPics.ItemPicLB, ProdPics.ItemPicF, ProdPics.ItemPicB FROMProducts, ProdPics WHERE Products.ItemID = ProdPics.PicID AND Description LIKE '%#form.keyword#%' ORItemName LIKE '%#form.keyword#%' AND ItemID > 1 ORDER BY ItemName TIA ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfform input w/rollover
Thanks Alan - Original Message - From: "Jon Hall" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, April 10, 2001 9:51 AM Subject: Re: cfform input w/rollover > cfform does not inhibit a standard submit rollover javascript. Check out > Mikodocs tutorial on the subject. > http://www.mikodocs.com/tags/forms/index_famsupp_107.html > > jon > - Original Message - > From: "Alan Koenig" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, April 10, 2001 2:58 PM > Subject: cfform input w/rollover > > > > Is there a way to do a cfform and have the submit button with rollover > properties? > > > > TIA > > > > Alan > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfform input w/rollover
Is there a way to do a cfform and have the submit button with rollover properties? TIA Alan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Preserve #
Thank you Alan - Original Message - From: "Aidan Whitehall" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, April 10, 2001 12:29 AM Subject: RE: Preserve # > How can I preserver just a single # for a single line of code? > I am using cf 4.01 on a windows platform. > > http://www.thenetprofits.co.uk/coldfusion/faq/index.cfm#answer89 > > > -- > Aidan Whitehall <[EMAIL PROTECTED]> > Netshopper UK Ltd > Advanced Web Solutions & Services > > Telephone +44 (01744) 648650 > Fax +44 (01744) 648651 > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Preserve #
How can I preserver just a single # for a single line of code? I am using cf 4.01 on a windows platform. TIA Alan Koenig ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Form Submital
I have a rollover that needs to be a form submital. I need to make this rollover pass some paramaters for me. How can I best do this? TIA Alan Koenig ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Dynamic Rollovers
I need to display front and back covers of videos that are from a search. Each will be displayed in blocks of ten. How do I get the Javascript to recognize the new rollovers? TIA Alan Koenig ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists