Sorry about that. You use CFQUERYPARAM to wrap the values you pass
into your query. So instead of this;
INSERT INTO myTable
(agent,
dateEntered,
timeEntered
)
VALUES
('WEB USER',
'#theDate#',
'#theTime#'
)
you'd do this:
INSERT INTO myTable
(agent,
dateEntered,
timeEntered
)
VALUES
('WEB USER',
<cfqueryparam cfsqltype="cf_sql_date" value="#theDate#" />,
<cfqueryparam cfsqltype="cf_sql_time" value="'#theTime#" />
)
CFQUERYPARAM is your friend. Use it everywhere. It saves enormous
hassles, and helps protect you.
cheers,
barneyb
On Mon, 20 Dec 2004 13:54:24 -0700, Jason Smith
<[EMAIL PROTECTED]> wrote:
> I've been reading about CFQUERYPARAM
> to see where this needs to be inserted to fix my date problem but I am
> new to CF and I'm most likely overlooking a simple solution can anyone
> pointme in the right direction or a site that has some better tutorial type
> information about storing date/time stamps correctly?
>
--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/blog/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188331
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
