CF Web Based Keyboard

2005-09-29 Thread grovem
I am developing a kiosk system that will simply use IE and a cold fusion server. I will be using a touch screen and would like to eliminate the keyboard. Has anyone developed a web based keyboard that when you press the keys, they fill in a form. I am assuming this can be done in flash, but can

RE: SQL Query Help (I'm stuck again)

2003-09-10 Thread grovem
Using the following code, I get cfquery name=Auction_GetAuctions datasource=#DatasourceName# dbtype=ODBC SELECT ai.Product_ID, ai.Status FROM Auction_Items ai, Auction_Bids ab WHERE ai.Status = 'ACTIVE' AND ai.date_EndDate #createODBCDate(now())# AND ai.Product_ID = ab.Product_ID GROUP BY

RE: SQL Query Help (I'm stuck again)

2003-09-10 Thread grovem
or disclose its contents to anyone else. Any unauthorised use may be unlawful. Any views expressed in this e-mail are those of the individual sender and may not necessarily reflect the views of ICLP. -Original Message- From: grovem [mailto:[EMAIL PROTECTED] Sent: 10 September 2003 15:16

RE: SQL Query Help (I'm stuck again)

2003-09-10 Thread grovem
need ai.Reserve_Price in the select (NOT the aggregate function) AND the HAVING clause. Because of the inner join, you will NOT get the records that did not receive a bid. -Oorspronkelijk bericht- Van: grovem [mailto:[EMAIL PROTECTED] Verzonden: wo 10/09/2003 16:43

RE: SQL Query Help (I'm stuck again)

2003-09-10 Thread grovem
(NOT the aggregate function) AND the HAVING clause. Because of the inner join, you will NOT get the records that did not receive a bid. -Oorspronkelijk bericht- Van: grovem [mailto:[EMAIL PROTECTED] Verzonden: wo 10/09/2003 16:43 Aan: CF-Talk CC