Re: What am I doing wrong? (Problem with cfqueryparam)

DateSent = Now() er, won't that insert the string Now() into your db? Why not use a date field in your DB? On 25/11/06, Will Tomlinson [EMAIL PROTECTED] wrote: DateSent = Now()To this And you might also think about using CreateODBCDate() for this. Will

What am I doing wrong? (Problem with cfqueryparam)

This works CFQUERY DATASOURCE=#APPLICATION.DB# USERNAME=#APPLICATION.UN# PASSWORD=#APPLICATION.PW# INSERT INTO #APPLICATION.DBPRE#VisSaveAd (VisitorID, AdID, DateSent) VALUES (#Val(ARGUMENTS.VisitorID)#, #Val(ARGUMENTS.AdID)#, '#Trim(ARGUMENTS.DateSent)#') /CFQUERY And

Re: What am I doing wrong? (Problem with cfqueryparam)

- Original Message - From: Doug Brown [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Saturday, November 25, 2006 2:28 PM Subject: What am I doing wrong? (Problem with cfqueryparam) This works CFQUERY DATASOURCE=#APPLICATION.DB# USERNAME=#APPLICATION.UN# PASSWORD

Re: What am I doing wrong? (Problem with cfqueryparam)

DateSent = Now()To this And you might also think about using CreateODBCDate() for this. Will ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your