Resturant/Golf reservation system

2001-05-10 Thread Alan Koenig 

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

2001-04-13 Thread Alan Koenig 

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.
   
   cffile action="UPLOAD" filefield="ItemPicLB" destination="#storepath#\images" 
nameconflict="OVERWRITE"
   
   cfquery datasource="#datasource#"
   UPDATE ProdPics
   SET 
   ItemPicLB = '#ItemPicLB#'
   WHERE #ItemID# = PicID
   /cfquery
   cffile action="UPLOAD" filefield="ItemPicF" destination="#storepath#\images" 
nameconflict="OVERWRITE" 
   cfquery datasource="#datasource#"
   UPDATE ProdPics 
   Set
   ItemPicF = '#ItemPicF#'
   WHERE #ItemID# = PicID
   /cfquery
   cffile action="UPLOAD" filefield="ItemPicB" destination="#storepath#\images" 
nameconflict="OVERWRITE"
   cfquery datasource="#datasource#"
   UPDATE ProdPics 
   Set
   ItemPicB = '#ItemPicB#'
   WHERE #ItemID# = PicID
   /cfquery

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

SQL Returns

2001-04-12 Thread Alan Koenig 

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?
 cfquery datasource="#datasource#" name="prodpage"
 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
 /cfquery

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

2001-04-12 Thread Alan Koenig 

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?
  cfquery datasource="#datasource#" name="prodpage"
  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
  /cfquery

 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

2001-04-12 Thread Alan Koenig 

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?
  cfquery datasource="#datasource#" name="prodpage"
  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
  /cfquery

 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

cfform input w/rollover

2001-04-10 Thread Alan Koenig 

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: cfform input w/rollover

2001-04-10 Thread Alan Koenig 

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

Preserve #

2001-04-10 Thread Alan Koenig 

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

Re: Preserve #

2001-04-10 Thread Alan Koenig 

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

Form Submital

2001-04-05 Thread Alan Koenig 

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

2001-03-30 Thread Alan Koenig 

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