Newbie ... CFSQLTYPE of CFQueryParam

[BobSharp]

I have been searching for some explanation of 
the different  Types  used in  CFQueryParam.  

understand that SCALE=  is used to validate the position of decimal,   
but still confused by ...  FLOAT, DECIMAL,  MONEY, MONEY4.  


I am usingINSERT  
do I need to use   for all values ? 





-- 
I am using the free version of SPAMfighter.
We are a community of 6 million users fighting spam.
SPAMfighter has removed 12962 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len

The Professional version does not have this message



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321645
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Newbie ... Date / Time formatting

[BobSharp]

Was actually trying to find a way of using DateTime fields in queries.


Just found TIMESTAMP type for  CFQueryParam.

To: "cf-talk" 
Sent: Wednesday, April 15, 2009 2:22 PM
Subject: Re: Newbie ... Date / Time formatting


>
> You can't output a time with dateformat() - you need to use
> timeformat() for that bit.
>
> mxAjax / CFAjax docs and other useful articles:
> http://www.bifrost.com.au/blog/
>
>
>
> 2009/4/15 BobSharp :
>>
>> I am having a problem with erroneous MINUTES in my DateTime 
>> creation/formatting.
>> The rest of the DateTime comes out correctly. >>> LINK <<<
>>
>> 
>> 
>> 
>> 
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321633
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Newbie ... Date / Time formatting

[BobSharp]

I am having a problem with erroneous MINUTES in my DateTime 
creation/formatting.  
The rest of the DateTime comes out correctly.   >>> LINK <<<

OUTPUT ...  

Date Formatting tests

   vStartDate =   01/01/2000  vEndDate =   14/4/2009



   CreateDateTime (vStartDate) =   {ts '2000-01-01 00:00:00'}

   DateFormat of the above =   2000-01-01 00:01:00


   CreateDateTime (vEndDate) =   {ts '2009-04-14 23:59:59'}

   DateFormat of the above =   2009-04-14 23:04:59



AFFECTED CODE ... 

 

 







-- 
I am using the free version of SPAMfighter.
We are a community of 6 million users fighting spam.
SPAMfighter has removed 12962 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len

The Professional version does not have this message


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321607
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Replace()

[BobSharp]

Table has a Primary Key of  DealerCode  (UUID) 
A form  POSTs   the required key ( form.txtDealer ) to be picked up by the 
Details Update page.


My scripting for the Update Details page  includes ...   
#form.txtDealer#  
 
 #matchDealer#
   
Outputs from that are correct.  


This query fails ...  
 
SELECT  * 
FROM  Dealers d 
WHERE Replace(d.DealerCode,'-','','all')=#matchDealer#;
 


Errors are  ...  
  Error Executing Database Query.
You have an error in your SQL syntax; check the manual that corresponds to your 
MySQL server version for the right syntax to use near 
''all')=4A1BC12D6C1D460FB50D7420A5BA306B' at line 3
 
The error occurred in /web/PurchaseOrders/update_Dealer.cfm: line 40
38 : SELECT  * 
39 : FROM  Dealers d 
40 : WHERE Replace(d.DealerCode,'-','','all')=#matchDealer#;
41 :  

SQLSELECT * FROM Dealers d WHERE 
Replace(d.DealerCode,'-','','all')=4A1BC12D6C1D460FB50D7420A5BA306B; 


-- 
I am using the free version of SPAMfighter.
We are a community of 6 million users fighting spam.
SPAMfighter has removed 12892 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len

The Professional version does not have this message


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321329
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Button to support both IE and Firefox

[BobSharp]

location.href= was correct,  although it could be 
window.location.href=




- Original Message - 
From: "Don L" 
To: "cf-talk" 
Sent: Wednesday, April 01, 2009 6:25 PM
Subject: Re: Button to support both IE and Firefox


>
> Yeah, you all, good catch on width= instead of width:
> also, there's a semicolon for the onclick event, still to no avail. 
> hmmm... thks.
>
>>I missed that but yes, width= should be width:.  Here's the code that it
>>should be:
>>
>>>onclick="window.location='http://xyz.com/somefile.zip';" value=" Download
>>the File ">
>>
>>HEXVAL should be the actual Hex value of the lightgreen color that you are
>>looking for.
>>
>>>onclick="location.href='http://xyz.com/somefile.zip';" value=" Download 
>>the
>>File ">
>>
>>two things I can see  ...
>>Should   width=   not be   width:   ?
>>Does onclick need the semicolon  ;   ?
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321207
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Button to support both IE and Firefox

[BobSharp]

http://xyz.com/somefile.zip';" value=" Download the
File ">

two things I can see  ...
Should   width=   not be   width:   ?
Does onclick need the semicolon  ;   ?




- Original Message - 
From: "Jake Churchill" 
To: "cf-talk" 
Sent: Wednesday, April 01, 2009 4:29 PM
Subject: RE: Button to support both IE and Firefox


>
> Try swapping out "lightgreen" with the hex value of that color and add 
> "px"
> after 150 and it'll probably work fine.
>
> -Original Message-
> From: Don L [mailto:do...@yahoo.com]
> Sent: Wednesday, April 01, 2009 11:16 AM
> To: cf-talk
> Subject: Button to support both IE and Firefox
>
>
> The following code for Button triggered download works with IE7 (hopefully
> IE6 & 8 as well) but not FireFox3, do you know how to make it supports 
> both
> browsers?  Getting rusty on this kind of stuff... Thanks.
>
> Don
>
>  onclick="location.href='http://xyz.com/somefile.zip';" value=" Download 
> the
> File ">
>
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321180
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: ColdFusion - facts

[BobSharp]

Great answers.

Thanks very much !


- Original Message - 
From: "Justin Scott" 
To: "cf-talk" 
Sent: Wednesday, April 01, 2009 4:58 AM
Subject: RE: ColdFusion - facts


>
>> Are there any disadvantages in using Coldfusion for a
>> web-based shopping catalogue ?
>
> That depends on the skill of the programmer using it.  This is about like
> asking if there are any disadvantages in using a particular brand of 
> hammer
> to sink a nail.  How big is the nail?  What's it being sunk into?  Who's
> using it?  ColdFusion can make an excellent platform on which to build an
> e-commerce system, but like any other tool, it can be used poorly as well.
> You can say that about nearly any programming language though.
>
>> Does CF replace ASP, Javascript/VBscript and flatfiles ?
>
> ColdFusion can be used in place of ASP and other web-specific languages.
> JavaScript and VBScript are primarily client-side technology, so no,
> ColdFusion doesn't replace them (ColdFusion is server-side).  "Flatfiles"
> implies data storage.  You *can* use flatfiles in conjunction with
> ColdFusion, but it's much more powerful when connected to a relational
> database that supports SQL.
>
>> Is there a dependancy between Coldfusion and MySQL ?
>
> No.  ColdFusion can be used with a wide variety of database platforms
> including MySQL, SQL Server, Access, Oracle, etc.  ColdFusion doesn't
> *require* a database, but it is designed with database interaction in 
> mind.
>
>
> --
> Justin Scott | GravityFree
> Member of the Technical Staff
>
> 1960 Stickney Point Road, Suite 210
> Sarasota | FL | 34231 | 800.207.4431
> 941.927.7674 x115 | f 941.923.5429
> www.GravityFree.com
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321164
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: ColdFusion - facts

[BobSharp]

Thanks 


> I'll bite.
> 
> a) Disadvantages over what?
> 

ASP,  PHP,   etc 

-- 
I am using the free version of SPAMfighter.
We are a community of 6 million users fighting spam.
SPAMfighter has removed 12840 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len

The Professional version does not have this message



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321163
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

ColdFusion - facts

[BobSharp]

Need some facts for a Report   
  a.. Are there any disadvantages in using Coldfusion for a web-based shopping 
catalogue ? 

  b.. Does CF replace ASP, Javascript/VBscript and flatfiles ?

  c.. Is there a dependancy between Coldfusion and MySQL ? 



-- 
I am using the free version of SPAMfighter.
We are a community of 6 million users fighting spam.
SPAMfighter has removed 12840 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len

The Professional version does not have this message


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321158
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Finding schema details with CF 6.1 ?

[BobSharp]

No.

Asking how to put it into a .cfm page with tidy output.

I'm new to CF and haven't seen  CFCs or   before.



- Original Message - 
From: "Brian Kotek" 
To: "cf-talk" 
Sent: Monday, March 30, 2009 4:02 PM
Subject: Re: Finding schema details with CF 6.1 ?


>
> Correct me if I'm wrong, but it sounds like you're actually requesting 
> that
> someone go through that CFC for you and turn it into something that you 
> can
> copy and paste into a template.
>
> On Mon, Mar 30, 2009 at 10:11 AM, BobSharp  wrote:
>
>>
>> Thanks,  but the CFC is a bit beyond me at the moment.
>>
>> How would I insert it in a CFM page ?
>>
>>
>>
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:32
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Finding schema details with CF 6.1 ?

[BobSharp]

Thanks,  but the CFC is a bit beyond me at the moment.

How would I insert it in a CFM page ?




- Original Message - 
From: "Gerald Guido" 
To: "cf-talk" 
Sent: Monday, March 30, 2009 2:25 PM
Subject: Re: Finding schema details with CF 6.1 ?


>
> Sorry about that I had my coffee now... I wrote a query to do that a
> while back. I can't find it now. :-(
>
> Brian Rinaldi has a CFC in his CFC generator (Illudium)  project that will
> tease this out for you.
>
> http://code.google.com/p/cfcgenerator/source/browse/trunk/cfcgenerator/com/cf/model/datasource/mysql.cfc
>
> There are other cfc's in there for other DB's
>
> http://code.google.com/p/cfcgenerator/source/browse/trunk/cfcgenerator/com/cf/model/datasource/
>
> HTH
>
> G!
>
>
> On Mon, Mar 30, 2009 at 9:19 AM, BobSharp  wrote:
>
>>
>> MySQL
>>
>> See previous posts in this thread.
>>
>> I have done it for a list of Tables,  now need to
>> extract FULL details of individual Tables.
>>
>>
>>
>>
>> - Original Message -
>> From: "Gerald Guido" 
>> To: "cf-talk" 
>> Sent: Monday, March 30, 2009 1:55 PM
>> Subject: Re: Finding schema details with CF 6.1 ?
>>
>>
>> >
>> > What database are you using?  There are different dialects on how to
>> tease
>> > that out.  I would take a look at sql.cfc for the MSSQL . I have the 
>> > sql
>> > for
>> > MySQL some where in my archive if you need it..
>> >
>> >
>> > H!
>> >
>> > On Mon, Mar 30, 2009 at 6:57 AM, BobSharp  
>> > wrote:
>> >
>> >>
>> >>  Can I use  CF 6.1  (including hot fixes)
>> >> to see what tables are in the schema ?
>> >>
>> >>
>> >>
>> >>
>> >> --
>> >> I am using the free version of SPAMfighter.
>> >> We are a community of 6 million users fighting spam.
>> >> SPAMfighter has removed 12840 of my spam emails to date.
>> >> Get the free SPAMfighter here: http://www.spamfighter.com/len
>> >>
>> >> The Professional version does not have this message
>> >>
>> >>
>> >>
>> >>
>> >
>> >
>>
>>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321104
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Finding schema details with CF 6.1 ?

[BobSharp]

Yes, thanks very much

Works well.

What is the equivalent for columns ?
Could I output the Table's schema details   ...
(column name, data type, size, format, NULL allowed ?, PrimaryKey, Indexes)
 ...ie:  like a DUMP, without the data  ?






- Original Message - 
From: "Azadi Saryev" 
To: "cf-talk" 
Sent: Monday, March 30, 2009 1:36 PM
Subject: Re: Finding schema details with CF 6.1 ?


>
> seen my follow-up post? it was posted same time you posted your reply...
>
> Azadi Saryev
> Sabai-dee.com
> http://www.sabai-dee.com/
>
>
>
> BobSharp wrote:
>> MySQL
>>
>>
>>
>> - Original Message - 
>> From: "Azadi Saryev" 
>> To: "cf-talk" 
>> Sent: Monday, March 30, 2009 12:58 PM
>> Subject: Re: Finding schema details with CF 6.1 ?
>>
>>
>>
>>> which db are you using?
>>>
>>> Azadi Saryev
>>> Sabai-dee.com
>>> http://www.sabai-dee.com/
>>>
>>>
>>>
>>> BobSharp wrote:
>>>
>>>>  Can I use  CF 6.1  (including hot fixes)
>>>> to see what tables are in the schema ?
>>>>
>>>>
>>>>
>>>>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321096
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Finding schema details with CF 6.1 ?

[BobSharp]

MySQL

See previous posts in this thread.

I have done it for a list of Tables,  now need to
extract FULL details of individual Tables.




- Original Message - 
From: "Gerald Guido" 
To: "cf-talk" 
Sent: Monday, March 30, 2009 1:55 PM
Subject: Re: Finding schema details with CF 6.1 ?


>
> What database are you using?  There are different dialects on how to tease
> that out.  I would take a look at sql.cfc for the MSSQL . I have the sql 
> for
> MySQL some where in my archive if you need it..
>
>
> H!
>
> On Mon, Mar 30, 2009 at 6:57 AM, BobSharp  wrote:
>
>>
>>  Can I use  CF 6.1  (including hot fixes)
>> to see what tables are in the schema ?
>>
>>
>>
>>
>> --
>> I am using the free version of SPAMfighter.
>> We are a community of 6 million users fighting spam.
>> SPAMfighter has removed 12840 of my spam emails to date.
>> Get the free SPAMfighter here: http://www.spamfighter.com/len
>>
>> The Professional version does not have this message
>>
>>
>>
>>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321095
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Finding schema details with CF 6.1 ?

[BobSharp]

MySQL



- Original Message - 
From: "Azadi Saryev" 
To: "cf-talk" 
Sent: Monday, March 30, 2009 12:58 PM
Subject: Re: Finding schema details with CF 6.1 ?


>
> which db are you using?
>
> Azadi Saryev
> Sabai-dee.com
> http://www.sabai-dee.com/
>
>
>
> BobSharp wrote:
>>  Can I use  CF 6.1  (including hot fixes)
>> to see what tables are in the schema ?
>>
>>
>>
>>
>>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321092
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Finding schema details with CF 6.1 ?

[BobSharp]

 Can I use  CF 6.1  (including hot fixes)  
to see what tables are in the schema ? 




-- 
I am using the free version of SPAMfighter.
We are a community of 6 million users fighting spam.
SPAMfighter has removed 12840 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len

The Professional version does not have this message



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321089
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Finding schema details with CF ?

[BobSharp]

Can I use CF to see what tables are in the schema ? 


-- 
I am using the free version of SPAMfighter.
We are a community of 6 million users fighting spam.
SPAMfighter has removed 12840 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len

The Professional version does not have this message


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321087
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Help requested - Syntax for GROUP BY with HAVING ... ommitted code

[BobSharp]

Sorry,   forgot to include the revised script ...
 =    ===

OK,  think I've got it now ...
GROUP BY  contains the main criteria for the query  (not to be confused with 
ORDER BY)
HAVING  should contain any (both) conditions needed for the search.

http://ttcfm.open.ac.uk/~bs3578/test1/Week9_Act6.cfm



SELECT  a.Amount AS aAmount,
d.DeptName AS dName,
AVG(a.Amount) AS  AverageAward,
SUM(a.Amount) AS  DeptTotal
  FROM  incentiveawards a
   INNER JOIN  employeedirectory e ON (e.ID = a.RecipientIDfk)
   INNER JOIN  departments d  ON (d.DepartmentID = e.DepartmentIDfk)
  GROUP BY  a.Amount
  HAVING  SUM(a.Amount) > 5000 AND AVG(a.Amount) > 3000
  ORDER BY  d.DeptName DESC;





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320888
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Help requested - Syntax for GROUP BY with HAVING ...

[BobSharp]

OK,  think I've got it now ...
GROUP BY  contains the main criteria for the query  (not to be confused with 
ORDER BY)
HAVING  should contain any (both) conditions needed for the search.

http://ttcfm.open.ac.uk/~bs3578/test1/Week9_Act6.cfm


thanks


BTWare there any tutorials online that cover this kind of CFquery ?





- Original Message - 
From: 
To: "cf-talk" 
Sent: Tuesday, March 24, 2009 10:19 PM
Subject: RE: Help requested - Syntax for GROUP BY with HAVING ...


>
> Try putting a.Amount in your group by clause.  Everything in your select
> list should be in the group by OR should have an aggregate function
> applied to it.
>
> Also, I noticed you are referencing an alias "AverageAward" in your
> order by.  I'm pretty certain SQL Server doesn't let you do that, but
> you might be OK with MySQL.
>
> ~Brad
>
>  Original Message 
> Subject: Help requested - Syntax for GROUP BY with HAVING ...
> From: "BobSharp" 
> Date: Tue, March 24, 2009 4:56 pm
> To: cf-talk 
>
>
> http://ttcfm.open.ac.uk/~bs3578/test1/Week9_Act6.cfm
>
> There is a problem with this script ... any clues, or links to examples,
> would be appreciated.
>
> 
> SELECT a.Amount AS aAmount,
> d.DeptName AS dName,
> AVG(a.Amount) AS AverageAward,
> SUM(a.Amount) AS DeptTotal
> FROM incentiveawards a
> INNER JOIN employeedirectory e ON (e.ID = a.RecipientIDfk)
> INNER JOIN departments d ON (d.DepartmentID = e.DepartmentIDfk)
> WHERE SUM(a.Amount) > 5000
> GROUP BY d.DeptName
> HAVING AVG(a.Amount) > 3000
> ORDER BY AverageAward DESC;
> 
>
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320887
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Help requested - Syntax for GROUP BY with HAVING ...

[BobSharp]

http://ttcfm.open.ac.uk/~bs3578/test1/Week9_Act6.cfm

There is a problem with this script ...  any clues, or links to examples, would 
be appreciated.


SELECT  a.Amount AS aAmount,
d.DeptName AS dName,
AVG(a.Amount) AS  AverageAward, 
SUM(a.Amount) AS  DeptTotal
  FROM  incentiveawards a  
   INNER JOIN  employeedirectory e ON (e.ID = a.RecipientIDfk)
   INNER JOIN  departments d  ON (d.DepartmentID = e.DepartmentIDfk) 
  WHERE  SUM(a.Amount) > 5000 
  GROUP BY  d.DeptName  
  HAVING  AVG(a.Amount) > 3000  
  ORDER BY  AverageAward DESC;




  Department 
  Total  
  Average  



   #dName#
 #LSCurrencyFormat(DeptTotal)#    
 #LSCurrencyFormat(AverageAward)#     







~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320875
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Eliminating repeated data in CFoutput field

[BobSharp]

Yep ! That's it.

http://ttcfm.open.ac.uk/~bs3578/test1/abEmpAssets_02.cfm


Thanks



- Original Message - 
From: "Nick G" 
To: "cf-talk" 
Sent: Thursday, March 19, 2009 9:14 PM
Subject: Re: Eliminating repeated data in CFoutput field


>
> You should be able to do this but I haven't tried it.
>
> 
>   
>   Name 
>   Asset 
> Category 
>   
>
>   
>   
>#qEmpAssets.eName#  
>
> #qEmpAssets.aTitle#  
>  #qEmpAssets.cCategory#  
>
>   
>   
> 
>
>
>
> On Thu, Mar 19, 2009 at 1:45 PM, BobSharp  wrote:
>
>>
>> Tried it several ways,  yet to get it to work as I want it.
>> http://ttcfm.open.ac.uk/~bs3578/test1/abEmpAssets_02.cfm<http://ttcfm.open.ac.uk/%7Ebs3578/test1/abEmpAssets_02.cfm>
>>
>> Must be the postion of the , in relation to the  table 
>> cells.
>>
>>
>> 
>>SELECT  concat(e.firstname, ' ', e.lastname) AS eName,
>>LEFT(a.assetdescription,30) AS aTitle,
>>c.assetcategory AS cCategory
>>FROM employees e
>>INNER JOIN assets a ON e.employeeID = a.employeeID
>>INNER JOIN assetcategories c ON a.assetcategoryID = c.assetcategoryID
>>ORDER BY eName
>> 
>>
>> 
>>
>> Name 
>>Asset 
>>Category 
>>
>>
>>
>>
>> #qEmpAssets.eName#  
>>   
>>  #qEmpAssets.aTitle#  
>>   #qEmpAssets.cCategory#  
>>   
>>
>>
>> 
>>
>>
>>
>>
>>
>> - Original Message -
>> From: "Dave Watts" 
>> To: "cf-talk" 
>> Sent: Thursday, March 19, 2009 2:23 PM
>> Subject: Re: Eliminating repeated data in CFoutput field
>>
>>
>> >
>> >> Thanks for the tip about Grouping
>> >>
>> >> Sadly, it would remove the eName column, when I just want it blank.
>> >> ( ie. output shifts left one column )
>> >
>> > No, it needn't do that, and grouping is really the correct way to
>> > solve this problem. You can find an example here:
>> >
>> >
>> http://www.adobe.com/education/instruction/teach/coldfusion/CF8-2_advanced_cf8_development_unit3.pdf
>> >
>> > Dave Watts, CTO, Fig Leaf Software
>> > http://www.figleaf.com/
>> >
>> > Fig Leaf Software provides the highest caliber vendor-authorized
>> > instruction at our training centers in Washington DC, Atlanta,
>> > Chicago, Baltimore, Northern Virginia, or on-site at your location.
>> > Visit http://training.figleaf.com/ for more informatio
>> >
>> >
>>
>>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320723
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Eliminating repeated data in CFoutput field

[BobSharp]

Tried it several ways,  yet to get it to work as I want it.  
http://ttcfm.open.ac.uk/~bs3578/test1/abEmpAssets_02.cfm

Must be the postion of the , in relation to the  table cells. 


 
SELECT  concat(e.firstname, ' ', e.lastname) AS eName, 
LEFT(a.assetdescription,30) AS aTitle, 
c.assetcategory AS cCategory
FROM employees e
INNER JOIN assets a ON e.employeeID = a.employeeID
INNER JOIN assetcategories c ON a.assetcategoryID = c.assetcategoryID
ORDER BY eName  
 



 Name  
Asset  
Category 

 
   
  
 #qEmpAssets.eName#   

  #qEmpAssets.aTitle#
   #qEmpAssets.cCategory# 
   
  







- Original Message - 
From: "Dave Watts" 
To: "cf-talk" 
Sent: Thursday, March 19, 2009 2:23 PM
Subject: Re: Eliminating repeated data in CFoutput field


>
>> Thanks for the tip about Grouping
>>
>> Sadly, it would remove the eName column, when I just want it blank.
>> ( ie. output shifts left one column )
> 
> No, it needn't do that, and grouping is really the correct way to
> solve this problem. You can find an example here:
> 
> http://www.adobe.com/education/instruction/teach/coldfusion/CF8-2_advanced_cf8_development_unit3.pdf
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> 
> Fig Leaf Software provides the highest caliber vendor-authorized
> instruction at our training centers in Washington DC, Atlanta,
> Chicago, Baltimore, Northern Virginia, or on-site at your location.
> Visit http://training.figleaf.com/ for more informatio
> 
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320711
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Eliminating repeated data in CFoutput field

[BobSharp]

Thanks for the tip about Grouping

Sadly,  it would remove the eName column, when I just want it blank.
( ie.  output shifts left one column )




- Original Message - 
From: "Adrian Lynch" 
To: "cf-talk" 
Sent: Wednesday, March 18, 2009 11:26 PM
Subject: RE: Eliminating repeated data in CFoutput field


>
> Order your query by eName then do something like this:
>
> 
> #yourQuery.eName#
> 
> #yourQuery.aTitle#
> #yourQuery.cCategory#
> 
> 
>
> You'll need to tweak it to fit in your table layout mind.
>
> Adrian
>
>> -Original Message-
>> From: BobSharp [mailto:bobsh...@ntlworld.com]
>> Sent: 18 March 2009 22:45
>> To: cf-talk
>> Subject: Eliminating repeated data in CFoutput field
>>
>>
>> rom this output,  I would like to eliminate repeated names 
>>
>>   eName   aTitle  cCategory
>> Doug Briggs  HP Omni 510Notebook PC
>> Nick Heap  IBM Netfinity Server Desktop PC
>> Nick Heap  HP Omni 510Notebook PC
>> Nick Heap  Motorola T60Mobile Phone
>> Audrey Ibbotson   Toshiba Satelite XL  Notebook PC
>> Karen Kear Viglen 733   Desktop PC
>> Karen Kear HP Omni 510   Notebook PC
>> Office Manager HP LaserJet XLLaser Printer
>> Office Manager Epson Phaser   Laser Printer
>> Glyn Martin Toshiba Tecra 8000Notebook PC
>> Glyn Martin  Nokia 7650  Mobile Phone
>> Bluetooth
>>
>> I am trying to use a variable LastEmp  and  but the
>> output is just the same as the original.
>>
>> My script is  ...
>>
>> 
>> 
>>  Name   Asset   Category 
>> 
>> 
>> 
>>  
>> 
>>
>> 
>> 
>>  #eName#   
>>  #aTitle#   
>>  #cCategory#   
>> 
>> 
>> 
>>
>>
>>
>> Am in anyway close to achieving it ?
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320684
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Eliminating repeated data in CFoutput field

[BobSharp]

rom this output,  I would like to eliminate repeated names    

  eName   aTitle  cCategory 
Doug Briggs  HP Omni 510Notebook PC
Nick Heap  IBM Netfinity Server Desktop PC
Nick Heap  HP Omni 510Notebook PC
Nick Heap  Motorola T60Mobile Phone
Audrey Ibbotson   Toshiba Satelite XL  Notebook PC
Karen Kear Viglen 733   Desktop PC
Karen Kear HP Omni 510   Notebook PC
Office Manager HP LaserJet XLLaser Printer
Office Manager Epson Phaser   Laser Printer
Glyn Martin Toshiba Tecra 8000Notebook PC
Glyn Martin  Nokia 7650  Mobile Phone Bluetooth

I am trying to use a variable LastEmp  and  but the 
output is just the same as the original. 

My script is  ...  



 Name   Asset   Category 

  
  
  

 


 #eName#
 #aTitle#
 #cCategory#  
   





Am in anyway close to achieving it ?  



-- 
I am using the free version of SPAMfighter.
We are a community of 6 million users fighting spam.
SPAMfighter has removed 12747 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len

The Professional version does not have this message


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320679
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CF Express ... Syntax error - CFQUERY -> UPDATE Options

[BobSharp]

How can CFQUERYPARAM be applied to a boolean (Yes/No) field ?

I cannot find it in the  CFSQLTYPE  list



- Original Message - 
From: "Al Musella, DPM" 
To: "cf-talk" 
Sent: Monday, December 29, 2008 5:40 PM
Subject: Re: CF Express ... Syntax error - CFQUERY -> UPDATE Options


>I just want to point out that you should be using cfqueryparam around
> all of those form elements.  The way you have it will last about 2
> hours before someone hacks into your database.
> see:
> http://www.forta.com/blog/index.cfm/2005/12/21/SQL-Injection-Attacks-Easy-To-Prevent-But-Apparently-Still-Ignored
> for details
>
>
>
> At 11:45 AM 12/28/2008, you wrote:
>> >Thanks,   but that is supposed to be the right bracket of the  SET
>> >
>> >
>> >> >Comments = '#trim(Form.Comments)#')
>> >>
>> >> Should be Comments =  Comments = '#trim(Form.Comments)#'
>> >>
>>Yep, but syntactically (sqlwise) you can't have the construct
>>(opening and closing bracket) the way it's laid out unlike your
>>INSERT statements.
>
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317226
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CF Express ... Syntax error - CFQUERY -> UPDATE Options

[BobSharp]

How can CFQUERYPARAM be applied to a boolean (Yes/No) field ?

I cannot find it in the  CDSQLTYPE list




- Original Message - 
From: "Al Musella, DPM" 
To: "cf-talk" 
Sent: Monday, December 29, 2008 5:40 PM
Subject: Re: CF Express ... Syntax error - CFQUERY -> UPDATE Options


>I just want to point out that you should be using cfqueryparam around
> all of those form elements.  The way you have it will last about 2
> hours before someone hacks into your database.
> see:
> http://www.forta.com/blog/index.cfm/2005/12/21/SQL-Injection-Attacks-Easy-To-Prevent-But-Apparently-Still-Ignored
> for details
>
>
>
> At 11:45 AM 12/28/2008, you wrote:
>> >Thanks,   but that is supposed to be the right bracket of the  SET
>> >
>> >
>> >> >Comments = '#trim(Form.Comments)#')
>> >>
>> >> Should be Comments =  Comments = '#trim(Form.Comments)#'
>> >>
>>Yep, but syntactically (sqlwise) you can't have the construct
>>(opening and closing bracket) the way it's laid out unlike your
>>INSERT statements.
>
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317225
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: IIS 6.0 and Coldfusion 8

[BobSharp]

I assume you are looking for a way to REDIRECT the default page.
Easy enough with ASP, PHP or CF;  but in your case you may have
to look to the IIS Server Administrator or Control Panel  (?)



- Original Message - 
From: "Derrick Sterzel" 
To: "cf-talk" 
Sent: Monday, December 29, 2008 2:33 PM
Subject: IIS 6.0 and Coldfusion 8


>I have multiple website running on a new server which isn't live yet.
> We are trying to test all functionality before rolling the new box into
> place which will eventually take the IP of the current box.  The new box
> is coldfusion 8 which we also have .htm going through the coldfusion  8
> runtime which I know isn't best practice but the web page was given to
> us that way.  We add default.htm to IIS as the Homepage and the server
> ends up going to the default IIS homepage.  Any other homepage name
> works but default.htm and I don't want to update the homepage name due
> too paid for links all over the place going to the homepage.  Any help
> would be greatly appreciated I've been running in circles.
>
>
>
> http://www.restasis.com/default.htm
>
> http://www.restasisprofessional.com/default.htm
>
>
>
>
>
> Derrick Sterzel
> Programmer/Analyst
>
> Redi-Mail Direct Marketing, Inc.
> 5 Audrey Place
> Fairfield, New Jersey 07004
> Phone: 973.808.4500 ext: 4251
> Fax: 973.808-5511
> dster...@redimail.com 
>
> www.redimail.com 
>
>
>
>
>
> *** IMPORTANT--PLEASE READ 
> ***
> This electronic message, including its attachments, is COMPANY 
> CONFIDENTIAL and may contain PROPRIETARY or
> LEGALLY PRIVILEGED information. If you are not the intended recipient, you 
> are hereby notified that any use,
> disclosure, copying, or distribution of this message or any of the 
> information included in it is unauthorized and strictly prohibited.
> If you have received this message in error, please immediately notify the 
> sender by reply e-mail and permanently delete this
> message and its attachments, along with any copies thereof. Thank you
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317224
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: ColdFusion Express?

[BobSharp]

Courses were free to me ...  on Benefits.

Totally deaf,  57,  and unemployed for 7 years.
Need anything to get my feet through the doors again.





- Original Message - 
From: "Raymond Camden" 
To: "cf-talk" 
Sent: Monday, December 29, 2008 3:24 PM
Subject: Re: ColdFusion Express?


> Thanks. I'd definitely ditto the other recommendations here. Any
> course using such an old product is not something I'd recommend you
> spend your money on. You can get courses from Adobe (and providers
> like Figleaf) with much more relevant, recent content.
>
> On Mon, Dec 29, 2008 at 7:38 AM, David Low  wrote:
>> http://telemat.open.ac.uk/webapps/
>>
>> 2008/12/29 Raymond Camden :
>>> Got a URL for Open University's courses?
>>>
>>> On Sun, Dec 28, 2008 at 11:25 PM, BobSharp  
>>> wrote:
>>>> I'm doing a series of Open University short courses,
>>>> and being introduced to CF with this version.
>>>>
>>>>
>>>> It also came with the SAMs Teach Yourself  ColdFusion Express in 24 
>>>> hrs.
>>>>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317214
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: ColdFusion Express?

[BobSharp]

I am aiming at this certificate.
http://www3.open.ac.uk/courses/bin/p12.dll?Q01C39

The 6 courses are quite thorough and demanding,  but do
not go deep into any methods/scripting language.

The course I need CF and MySQL for is TT380 ...
http://www3.open.ac.uk/courses/bin/p12.dll?C01TT380


Has anyone heard of  "SQL-92"  ?






- Original Message - 
From: "Raymond Camden" 
To: "cf-talk" 
Sent: Monday, December 29, 2008 1:33 PM
Subject: Re: ColdFusion Express?


> Got a URL for Open University's courses?
>
> On Sun, Dec 28, 2008 at 11:25 PM, BobSharp  wrote:
>> I'm doing a series of Open University short courses,
>> and being introduced to CF with this version.
>>
>>
>> It also came with the SAMs Teach Yourself  ColdFusion Express in 24 hrs.
>>
>>
>>
>> - Original Message -
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317213
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: ColdFusion Express?

[BobSharp]

Thanks for the advice.   Will check with OU about using CF-8.

Any advice for someone needing to learn MySQL ?
It's supposed to be "easy",  but it's DOS-window appearance is depressing(!)




- Original Message - 
From: "Charlie Griefer" 
To: "cf-talk" 
Sent: Monday, December 29, 2008 5:29 AM
Subject: Re: ColdFusion Express?


> That version, as has been pointed out, is quite a number of years old. 
> You
> might be better off downloading the developer's edition of the latest
> version (CF 8) from Adobe's site.  It's free and fully functional (only
> limitation is that it can only be accessed by 2 external IP addresses... 
> but
> developing and testing locally is no different than using the full
> commercial version).
>
> On Sun, Dec 28, 2008 at 9:25 PM, BobSharp  wrote:
>
>> I'm doing a series of Open University short courses,
>> and being introduced to CF with this version.
>>
>>
>> It also came with the SAMs Teach Yourself  ColdFusion Express in 24 hrs.
>>
>>
>>
>> - Original Message -
>> From: "Don L" 
>> To: "cf-talk" 
>> Sent: Sunday, December 28, 2008 11:19 PM
>> Subject: ColdFusion Express?
>>
>>
>> > One of the last few threads mentioned about ColdFusion Express?  Last
>> > heard was like four or five years ago, have I been sleeping all these
>> > years?  Or is it something sort of Adobe's interesting secret?  Or does
>> > the thread refer to the same old express?
>> >
>> > Enlight me please.
>> >
>> >
>>
>>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317200
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: ColdFusion Express?

[BobSharp]

I'm doing a series of Open University short courses,
and being introduced to CF with this version.


It also came with the SAMs Teach Yourself  ColdFusion Express in 24 hrs.



- Original Message - 
From: "Don L" 
To: "cf-talk" 
Sent: Sunday, December 28, 2008 11:19 PM
Subject: ColdFusion Express?


> One of the last few threads mentioned about ColdFusion Express?  Last 
> heard was like four or five years ago, have I been sleeping all these 
> years?  Or is it something sort of Adobe's interesting secret?  Or does 
> the thread refer to the same old express?
>
> Enlight me please.
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317198
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CF Express ... Syntax error - CFQUERY -> UPDATE Options

[BobSharp]

Woo !   Thanks for thatworks ok now.
- Original Message - 
From: "Jide Aliu" 
To: "cf-talk" 
Sent: Sunday, December 28, 2008 4:35 PM
Subject: Re: CF Express ... Syntax error - CFQUERY -> UPDATE Options


>>>Comments = '#trim(Form.Comments)#')
>>
>>Should be Comments =  Comments = '#trim(Form.Comments)#'
>
> Sorry that should be Comments = '#trim(Form.Comments)#)'
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317180
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CF Express ... Syntax error - CFQUERY -> UPDATE Options

[BobSharp]

Woo !Thanks for that. works ok now.


- Original Message - 
From: "Casey Dougall" 
To: "cf-talk" 
Sent: Sunday, December 28, 2008 4:37 PM
Subject: Re: CF Express ... Syntax error - CFQUERY -> UPDATE Options


> On Sun, Dec 28, 2008 at 11:33 AM, Jide Aliu  wrote:
>
>> >Comments = '#trim(Form.Comments)#')
>>
>> Should be Comments =  Comments = '#trim(Form.Comments)#'
>>
>>
> Remove the opening bracket as well
>
> 
>   UPDATE  GuestBook
>   SET
> GuestName = '#Form.GuestName#',
>   Email = '#Form.Email#',
>   FirstVisit = #Form.FirstVisit#,
>   GotHere = '#Form.GotHere#',
>   Rating = '#Form.Rating#',
>   Comments = '#trim(Form.Comments)#'
>
>   WHERE   GuestBook_ID = #Form.GuestBook_ID#
> 
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317179
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CF Express ... Syntax error - CFQUERY -> UPDATE Options

[BobSharp]

Thanks,   but that is supposed to be the right bracket of the  SET


- Original Message - 
From: "Jide Aliu" 
To: "cf-talk" 
Sent: Sunday, December 28, 2008 4:33 PM
Subject: Re: CF Express ... Syntax error - CFQUERY -> UPDATE Options


> >Comments = '#trim(Form.Comments)#')
>
> Should be Comments =  Comments = '#trim(Form.Comments)#'
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317177
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4